Relational Data Models
Check if column(s) can be used as keys
Check column values for set equality
Check column values for subset
Copy data model to data source
Create a schema on a database
Remove a schema from a database
Check for existence of a schema on a database
List schemas on a database
Decompose a table into two linked tables
Deprecated functions
Add foreign keys
Add a primary key
Add a unique key
Create code to deconstruct a dm object
Resolve column name ambiguities
Draw a diagram of the data model
Foreign key candidates
Primary key candidate
Learn about your data model
Validate your data model
Filtering
Creates a dm object for the Financial data
Flatten a part of a dm into a wide table
Load a dm from a remote data source
Load a dm from a remote data source
Get foreign key constraints
Get all primary keys of a dm object
Get all unique keys of a dm object
Get connection
Primary key column names
Get tables
Shiny app for defining dm objects
Check if foreign keys exists
Check for primary key
Update tables in a dm
Nest a table inside its dm
Number of rows
Creates a dm object for the nycflights13 data
dm_pack_tbl()
Create R code for a dm object
Creates a dm object for the pixarfilms data
Prototype for a dm object
Rename columns
Remove foreign keys
Remove a primary key
Remove a unique key
Select and rename tables
Select columns
Color in database diagrams
Add info about a dm's tables
Create DDL and DML scripts for a dm a and database connectio...
Unnest columns from a wrapped table
Unpack columns from a wrapped table
Unwrap a single table dm
Validator
Wrap dm into a single tibble dm
Mark table for manipulation
dm: Relational Data Models
Data model class
dplyr join methods for zoomed dm objects
dm as data source
dplyr table manipulation methods for zoomed dm objects
Check table relations
Get a glimpse of your dm object
JSON nest join
JSON nest
JSON pack join
JSON pack
Unnest a JSON column
Unpack a JSON column
Materialize
Pack Join
Retrieve a table
Objects exported from other packages
Merge two tables that are linked by a foreign key relation
Modifying rows for multiple tables
tidyr table manipulation methods for zoomed dm objects
utils table manipulation methods for dm_zoomed objects
Provides tools for working with multiple related tables, stored as data frames or in a relational database. Multiple tables (data and metadata) are stored in a compound object, which can then be manipulated with a pipe-friendly syntax.