dbKeys: Keys in relational db.

In b-becker/eatGADS: Normalizing, Subsetting and Reshaping Hierarchical Data

Description

Function to get the primary and foreign keys in the relational data base.

Usage

dbKeys(filePath, includeMeta = FALSE)

Arguments

filePath

Path of the existing db file.

Details

Data in a relational data base are indexed by primary and foreign keys. Primary keys are unique indentifiers inside the same data table. Foreign keys reference (link) to other data tables. This function returns the key structure of a relational data base

Value

Returns a list named as the data tables in the db. Each elements contains a list with the primary key, the other referenced data table and the foreign key.

Examples

# See vignette.

b-becker/eatGADS documentation built on May 24, 2019, 8:47 p.m.