Module:Schema and Metadata

column_id

column_id

table_id

table_id

name

name

dbo.columns

dbo.columns

Columns

Columns

database_id

database_id

title

title

type

type

dbo.databases

dbo.databases

Documentations

Documentations

module_id

module_id

database_id

database_id

title

title

description

description

dbo.modules

dbo.modules

Modules

Modules

parameter_id

parameter_id

procedure_id

procedure_id

name

name

dbo.parameters

dbo.parameters

Parameters

Parameters

procedure_id

procedure_id

database_id

database_id

schema

schema

name

name

title

title

description

description

object_type

object_type

dbo.procedures

dbo.procedures

Procedures and Functions

Procedures and Functions

procedure_module_id

procedure_module_id

procedure_id

procedure_id

module_id

module_id

dbo.procedures_modules

dbo.procedures_modules

Procedures-modules

Procedures-modules

table_id

table_id

database_id

database_id

schema

schema

name

name

title

title

description

description

object_type

object_type

dbo.tables

dbo.tables

Tables and Views

Tables and Views

table_module_id

table_module_id

table_id

table_id

module_id

module_id

dbo.tables_modules

dbo.tables_modules

Tables-modules

Tables-modules

table_relation_id

table_relation_id

pk_table_id

pk_table_id

fk_table_id

fk_table_id

name

name

dbo.tables_relations

dbo.tables_relations

Tables relations

Tables relations

table_relation_column_id

table_relation_column_id

table_relation_id

table_relation_id

column_fk_id

column_fk_id

column_pk_id

column_pk_id

dbo.tables_relations_columns

dbo.tables_relations_columns

Tables relations' columns

Tables relations' columns

trigger_id

trigger_id

table_id

table_id

name

name

description

description

dbo.triggers

dbo.triggers

Triggers

Triggers

unique_constraint_id

unique_constraint_id

table_id

table_id

name

name

dbo.unique_constraints

dbo.unique_constraints

Unique keys

Unique keys

unique_constraint_column_id

unique_constraint_column_id

unique_constraint_id

unique_constraint_id

column_id

column_id

dbo.unique_constraints_columns

dbo.unique_constraints_columns

Uniquie keys' columns

Uniquie keys' columns

All documented database objects are stored in Dataedo repository.

 

Distinct database documentations are stored in databases table which holds their title and DBMS connection details.

 

Object status

Tables, views, columns, procedures, functions and parameters can be in one of two states identified by status column:

 

When object gets deleted with editor it gets physically deleted from Dataedo tables. There is no way to undelete it.

 

Standard metadata columns

Every table has following metadata columns that describe who and when created and last updated data in repository:

 

DBMS import columns

Tables, views, procedures and functions have following metadata columns that facilitate change tracking and database schema updates:

 

Object source

Objects representing data stuctures (tables, columns, relations etc) can have following sources identified by source column:

Tables

  1. dbo.columns (Columns)
  2. dbo.databases (Documentations)
  3. dbo.modules (Modules)
  4. dbo.parameters (Parameters)
  5. dbo.procedures (Procedures and Functions)
  6. dbo.procedures_modules (Procedures-modules)
  7. dbo.tables (Tables and Views)
  8. dbo.tables_modules (Tables-modules)
  9. dbo.tables_relations (Tables relations)
  10. dbo.tables_relations_columns (Tables relations' columns)
  11. dbo.triggers (Triggers)
  12. dbo.unique_constraints (Unique keys)
  13. dbo.unique_constraints_columns (Uniquie keys' columns)