Description Usage Arguments Examples
Returns the db_fields variable with columns: KeyType, Table, Column, Type, Comment, RelationshipWithTable, RelationshipWithColumn, Transformation
1 2 3 4 5 6 7 8 9 |
csv_path |
A String. The path of the db_fields .csv file. |
ExcludeIdentities |
A Boolean. The default inclusion behaviour for SQL Table Identities. If we're going to perform more joins afterwards or if we need to have a reference as to which table each column belongs to, then we shouldn't exclude them; if we only care about extrapolating information from each specific row, then we can exclude them by default and edit to include just the row identifier ID. |
ExcludeForeignKeys |
A Boolean. If we need to perform manual joins afterwards or keep a reference as to with which table there's a connection, then we need them; otherwise we can safely exclude them |
Update_DBEnv_DBFields |
A Boolean. If set to TRUE, you can have an internal main db_fields accessible via db$db_fields usually acting as the main db_fields. Default is FALSE as having local db_fields variables is the default behaviour. |
DefaultToExclude |
A Boolean. If TRUE, every non-ID and non-FK column will default to Include == FALSE, unless ExcludeIdentities or ExcludeForeignKeys is set to TRUE |
ExcludeAuditingFields. |
A Boolean. If TRUE, any SQL Columns ending with "_OrigEntryOn", "_OrigEntryBy", "_EntryOn", "_EntryBy", "_CompName", "_Remote" or "_Username" will have INCLUDE == FALSE by default |
ExcludeSYSDIAGRAMS. |
A Boolean. If TRUE, any SQL Columns on the table "sysdiagrams" will have INCLUDE == FALSE by default |
1 | db_fields <- zinternal_create_default_db_fields_from_db_con("db_fields.csv")
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.