Relational Data Models
![[R logo]](../../../doc/html/Rlogo.svg)
![[Up]](../../../doc/html/left.jpg)
![[Top]](../../../doc/html/up.jpg)
Documentation for package ‘dm’ version 0.2.8
- DESCRIPTION file.
- User guides, package vignettes and other documentation.
- Code demos. Use demo() to run them.
Help Pages
A C D E F G H I L M N P R S T U V
-- A --
| anti_join.zoomed_dm | 'dplyr' join methods for zoomed dm objects |
| arrange.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
| as_dm | Data model class |
-- C --
| check_cardinality_0_1 | Check table relations |
| check_cardinality_0_n | Check table relations |
| check_cardinality_1_1 | Check table relations |
| check_cardinality_1_n | Check table relations |
| check_key | Check if column(s) can be used as keys |
| check_set_equality | Check column values for set equality |
| check_subset | Check column values for subset |
| collect.dm | Materialize |
| compute.dm | Materialize |
| compute.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
| copy_dm_to | Copy data model to data source |
| count.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
-- D --
| db_schema_create | Create a schema on a database |
| db_schema_drop | Remove a schema from a database |
| db_schema_exists | Check for existence of a schema on a database |
| db_schema_list | List schemas on a database |
| decompose_table | Decompose a table into two linked tables |
| distinct.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
| dm | Data model class |
| dm_add_fk | Add foreign keys |
| dm_add_pk | Add a primary key |
| dm_add_tbl | Add tables to a 'dm' |
| dm_apply_filters | Filtering |
| dm_apply_filters_to_tbl | Filtering |
| dm_bind | Merge several 'dm' |
| dm_disambiguate_cols | Resolve column name ambiguities |
| dm_discard_zoomed | Mark table for manipulation |
| dm_draw | Draw a diagram of the data model |
| dm_enum_fk_candidates | Foreign key candidates |
| dm_enum_pk_candidates | Primary key candidate |
| dm_examine_cardinalities | Learn about your data model |
| dm_examine_constraints | Validate your data model |
| dm_filter | Filtering |
| dm_financial | Creates a dm object for the Financial data |
| dm_financial_sqlite | Creates a dm object for the Financial data |
| dm_flatten_to_tbl | Flatten a part of a 'dm' into a wide table |
| dm_from_src | Load a dm from a remote data source |
| dm_get_all_fks | Get foreign key constraints |
| dm_get_all_pks | Get all primary keys of a 'dm' object |
| dm_get_available_colors | Color in database diagrams |
| dm_get_colors | Color in database diagrams |
| dm_get_con | Data model class |
| dm_get_filters | Get filter expressions |
| dm_get_referencing_tables | Get the names of referencing tables |
| dm_get_tables | Data model class |
| dm_has_pk | Check for primary key |
| dm_insert_zoomed | Mark table for manipulation |
| dm_is_referenced | Check foreign key reference |
| dm_join_to_tbl | Join two tables |
| dm_mutate_tbl | Update tables in a 'dm' |
| dm_nest_tbl | Nest a table inside its dm |
| dm_nrow | Number of rows |
| dm_nycflights13 | Creates a dm object for the 'nycflights13' data |
| dm_pack_tbl | dm_pack_tbl() |
| dm_paste | Create R code for a dm object |
| dm_pixarfilms | Creates a dm object for the 'pixarfilms' data |
| dm_ptype | Prototype for a dm object |
| dm_rename | Rename columns |
| dm_rename_tbl | Select and rename tables |
| dm_rm_fk | Remove foreign keys |
| dm_rm_pk | Remove a primary key |
| dm_rm_tbl | Remove tables |
| dm_rows_delete | Modifying rows for multiple tables |
| dm_rows_insert | Modifying rows for multiple tables |
| dm_rows_patch | Modifying rows for multiple tables |
| dm_rows_truncate | Modifying rows for multiple tables |
| dm_rows_update | Modifying rows for multiple tables |
| dm_rows_upsert | Modifying rows for multiple tables |
| dm_select | Select columns |
| dm_select_tbl | Select and rename tables |
| dm_set_colors | Color in database diagrams |
| dm_squash_to_tbl | Flatten a part of a 'dm' into a wide table |
| dm_unnest_tbl | Unnest columns from a wrapped table |
| dm_unpack_tbl | Unpack columns from a wrapped table |
| dm_unwrap_tbl | Unwrap a single table dm |
| dm_update_zoomed | Mark table for manipulation |
| dm_wrap_tbl | Wrap dm into a single tibble dm |
| dm_zoom_to | Mark table for manipulation |
| dplyr_join | 'dplyr' join methods for zoomed dm objects |
| dplyr_table_manipulation | 'dplyr' table manipulation methods for zoomed dm objects |
-- E --
| enum_fk_candidates | Foreign key candidates |
| enum_pk_candidates | Primary key candidate |
| examine_cardinality | Check table relations |
-- F --
| filter.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
| full_join.zoomed_dm | 'dplyr' join methods for zoomed dm objects |
-- G --
| get_returned_rows | Extract and check the RETURNING rows |
| group_by.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
-- H --
| has_returned_rows | Extract and check the RETURNING rows |
| head.zoomed_dm | 'utils' table manipulation methods for 'zoomed_dm' objects |
-- I --
| inner_join.zoomed_dm | 'dplyr' join methods for zoomed dm objects |
| is_dm | Data model class |
-- L --
| left_join.zoomed_dm | 'dplyr' join methods for zoomed dm objects |
-- M --
| materialize | Materialize |
| mutate.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
-- N --
| new_dm | Data model class |
-- P --
| pack_join | Pack Join |
| pull.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
| pull_tbl | Retrieve a table |
-- R --
| relocate.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
| rename.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
| reunite_parent_child | Merge two tables that are linked by a foreign key relation |
| reunite_parent_child_from_list | Merge two tables that are linked by a foreign key relation |
| right_join.zoomed_dm | 'dplyr' join methods for zoomed dm objects |
| rows-db | Updating database tables |
| rows-dm | Modifying rows for multiple tables |
| rows_delete.tbl_dbi | Updating database tables |
| rows_insert.tbl_dbi | Updating database tables |
| rows_patch.tbl_dbi | Updating database tables |
| rows_truncate | Truncate all rows |
| rows_update.tbl_dbi | Updating database tables |
| rows_upsert.tbl_dbi | Updating database tables |
-- S --
| select.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
| semi_join.zoomed_dm | 'dplyr' join methods for zoomed dm objects |
| separate.zoomed_dm | 'tidyr' table manipulation methods for zoomed dm objects |
| slice.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
| sql_output_cols | Updating database tables |
| sql_returning_cols | Updating database tables |
| sql_rows_delete | Updating database tables |
| sql_rows_insert | Updating database tables |
| sql_rows_patch | Updating database tables |
| sql_rows_truncate | Truncate all rows |
| sql_rows_update | Updating database tables |
| summarise.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
-- T --
| tail.zoomed_dm | 'utils' table manipulation methods for 'zoomed_dm' objects |
| tally.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
| tidyr_table_manipulation | 'tidyr' table manipulation methods for zoomed dm objects |
| transmute.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
-- U --
| ungroup.zoomed_dm | 'dplyr' table manipulation methods for zoomed dm objects |
| unite.zoomed_dm | 'tidyr' table manipulation methods for zoomed dm objects |
-- V --
| validate_dm | Data model class |