dbo.schema_updates (Imports/Updates)
| Documentation | Dataedo repository 7 |
| Schema | dbo |
| Name | schema_updates |
| Title | Imports/Updates |
| Module | Schema Change Tracking |
| Type | Metadata |
| Status | Active |
Holds all schema imports/updates from source database.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | Type | Status | ||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | update_id | int | Identity | Id of the schema import/update from source database | Metadata | Active | ||||
| Id of the schema import/update from source database Identity Type: Metadata Status: Active |
||||||||||
| 2 | type | nvarchar(100) | Type of import: IMPORT - first schema import, UPDATE - subsequent connection | Metadata | Active | |||||
| Type of import: IMPORT - first schema import, UPDATE - subsequent connection Type: Metadata Status: Active |
||||||||||
| 3 | datetime | datetime | Default: getdate() | Time of beginnig of import/update operation | Metadata | Active | ||||
| Time of beginnig of import/update operation Default: getdate() Type: Metadata Status: Active |
||||||||||
| 4 | repository_login | nvarchar(1024) | Default: suser_sname() | Dataedo username that intiated connection | Metadata | Active | ||||
| Dataedo username that intiated connection Default: suser_sname() Type: Metadata Status: Active |
||||||||||
| 5 | database_id | int | dbo.databases (Documentations) | Documentation that was imported/updated | Metadata | Active | ||||
| Documentation that was imported/updated References: dbo.databases (Documentations) Type: Metadata Status: Active |
||||||||||
| 6 | connection_database_type | nvarchar(100) | Connection database type: ORACLE, SQLSERVER, etc. | Connection | Active | |||||
| Connection database type: ORACLE, SQLSERVER, etc. Type: Connection Status: Active |
||||||||||
| 7 | connection_host | nvarchar(1024) | Connection host name/address | Connection | Active | |||||
| Connection host name/address Type: Connection Status: Active |
||||||||||
| 8 | connection_user | nvarchar(1024) | Connection username | Connection | Active | |||||
| Connection username Type: Connection Status: Active |
||||||||||
| 9 | connection_port | int | Connection port number | Connection | Active | |||||
| Connection port number Type: Connection Status: Active |
||||||||||
| 10 | connection_service_name | nvarchar(100) | Connection service name for Oracle connection | Connection | Active | |||||
| Connection service name for Oracle connection Type: Connection Status: Active |
||||||||||
| 11 | connection_database_name | nvarchar(1024) | Connection database name | Connection | Active | |||||
| Connection database name Type: Connection Status: Active |
||||||||||
| 12 | connection_dbms_version | nvarchar(500) | Connection DBMS version as returned by DBMS | Connection | Active | |||||
| Connection DBMS version as returned by DBMS Type: Connection Status: Active |
||||||||||
| 13 | creation_date | datetime | Default: getdate() | Standard row creation timestamp | Metadata | Active | ||||
| Standard row creation timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
| 14 | created_by | nvarchar(1024) | Default: suser_sname() | Dataedo username that created row | Metadata | Active | ||||
| Dataedo username that created row Default: suser_sname() Type: Metadata Status: Active |
||||||||||
| 15 | last_modification_date | datetime | Default: getdate() | Standard row last update timestamp | Metadata | Active | ||||
| Standard row last update timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
| 16 | modified_by | nvarchar(1024) | Default: suser_sname() | Dataedo username that last updated row | Metadata | Active | ||||
| Dataedo username that last updated row Default: suser_sname() Type: Metadata Status: Active |
||||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| dbo.schema_updates (Imports/Updates) | dbo.databases (Documentations) | dbo.schema_updates.database_id = dbo.databases.database_id | fk_schema_updates_databases | |
|
dbo.schema_updates.database_id = dbo.databases.database_id Name: fk_schema_updates_databases |
||||
| dbo.columns (Columns) | dbo.schema_updates (Imports/Updates) | dbo.columns.update_id = dbo.schema_updates.update_id | fk_columns_schema_updates | |
|
dbo.columns.update_id = dbo.schema_updates.update_id Name: fk_columns_schema_updates |
||||
| dbo.columns_changes | dbo.schema_updates (Imports/Updates) | dbo.columns_changes.update_id = dbo.schema_updates.update_id | fk_columns_changes_schema_updates | |
|
dbo.columns_changes.update_id = dbo.schema_updates.update_id Name: fk_columns_changes_schema_updates |
||||
| dbo.parameters (Parameters) | dbo.schema_updates (Imports/Updates) | dbo.parameters.update_id = dbo.schema_updates.update_id | fk_parameters_schema_updates | |
|
dbo.parameters.update_id = dbo.schema_updates.update_id Name: fk_parameters_schema_updates |
||||
| dbo.parameters_changes | dbo.schema_updates (Imports/Updates) | dbo.parameters_changes.update_id = dbo.schema_updates.update_id | fk_parameters_changes_schema_updates | |
|
dbo.parameters_changes.update_id = dbo.schema_updates.update_id Name: fk_parameters_changes_schema_updates |
||||
| dbo.procedures (Procedures and Functions) | dbo.schema_updates (Imports/Updates) | dbo.procedures.update_id = dbo.schema_updates.update_id | fk_procedures_schema_updates | |
|
dbo.procedures.update_id = dbo.schema_updates.update_id Name: fk_procedures_schema_updates |
||||
| dbo.procedures_changes | dbo.schema_updates (Imports/Updates) | dbo.procedures_changes.update_id = dbo.schema_updates.update_id | fk_procedures_changes_schema_updates | |
|
dbo.procedures_changes.update_id = dbo.schema_updates.update_id Name: fk_procedures_changes_schema_updates |
||||
| dbo.tables (Tables and Views) | dbo.schema_updates (Imports/Updates) | dbo.tables.update_id = dbo.schema_updates.update_id | fk_tables_schema_updates | |
|
dbo.tables.update_id = dbo.schema_updates.update_id Name: fk_tables_schema_updates |
||||
| dbo.tables_changes | dbo.schema_updates (Imports/Updates) | dbo.tables_changes.update_id = dbo.schema_updates.update_id | fk_tables_changes_schema_updates | |
|
dbo.tables_changes.update_id = dbo.schema_updates.update_id Name: fk_tables_changes_schema_updates |
||||
| dbo.tables_relations (Table relationships) | dbo.schema_updates (Imports/Updates) | dbo.tables_relations.update_id = dbo.schema_updates.update_id | fk_tables_relations_schema_updates | |
|
dbo.tables_relations.update_id = dbo.schema_updates.update_id Name: fk_tables_relations_schema_updates |
||||
| dbo.tables_relations_changes | dbo.schema_updates (Imports/Updates) | dbo.tables_relations_changes.update_id = dbo.schema_updates.update_id | fk_tables_relations_changes_schema_updates | |
|
dbo.tables_relations_changes.update_id = dbo.schema_updates.update_id Name: fk_tables_relations_changes_schema_updates |
||||
| dbo.tables_relations_columns (Tables relations' columns) | dbo.schema_updates (Imports/Updates) | dbo.tables_relations_columns.update_id = dbo.schema_updates.update_id | fk_tables_relations_columns_schema_updates | |
|
dbo.tables_relations_columns.update_id = dbo.schema_updates.update_id Name: fk_tables_relations_columns_schema_updates |
||||
| dbo.tables_relations_columns_changes | dbo.schema_updates (Imports/Updates) | dbo.tables_relations_columns_changes.update_id = dbo.schema_updates.update_id | fk_tables_relations_columns_changes_schema_updates | |
|
dbo.tables_relations_columns_changes.update_id = dbo.schema_updates.update_id Name: fk_tables_relations_columns_changes_schema_updates |
||||
| dbo.triggers (Triggers) | dbo.schema_updates (Imports/Updates) | dbo.triggers.update_id = dbo.schema_updates.update_id | fk_triggers_schema_updates | |
|
dbo.triggers.update_id = dbo.schema_updates.update_id Name: fk_triggers_schema_updates |
||||
| dbo.triggers_changes | dbo.schema_updates (Imports/Updates) | dbo.triggers_changes.update_id = dbo.schema_updates.update_id | fk_triggers_changes_schema_updates | |
|
dbo.triggers_changes.update_id = dbo.schema_updates.update_id Name: fk_triggers_changes_schema_updates |
||||
| dbo.unique_constraints (Unique keys) | dbo.schema_updates (Imports/Updates) | dbo.unique_constraints.update_id = dbo.schema_updates.update_id | fk_unique_constraints_schema_updates | |
|
dbo.unique_constraints.update_id = dbo.schema_updates.update_id Name: fk_unique_constraints_schema_updates |
||||
| dbo.unique_constraints_changes | dbo.schema_updates (Imports/Updates) | dbo.unique_constraints_changes.update_id = dbo.schema_updates.update_id | fk_unique_constraints_changes_schema_updates | |
|
dbo.unique_constraints_changes.update_id = dbo.schema_updates.update_id Name: fk_unique_constraints_changes_schema_updates |
||||
| dbo.unique_constraints_columns (Unique keys' columns) | dbo.schema_updates (Imports/Updates) | dbo.unique_constraints_columns.update_id = dbo.schema_updates.update_id | fk_unique_constraints_columns_schema_updates | |
|
dbo.unique_constraints_columns.update_id = dbo.schema_updates.update_id Name: fk_unique_constraints_columns_schema_updates |
||||
| dbo.unique_constraints_columns_changes | dbo.schema_updates (Imports/Updates) | dbo.unique_constraints_columns_changes.update_id = dbo.schema_updates.update_id | fk_unique_constraints_columns_changes_schema_updates | |
|
dbo.unique_constraints_columns_changes.update_id = dbo.schema_updates.update_id Name: fk_unique_constraints_columns_changes_schema_updates |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_schema_updates | update_id |
Uses
| Name |
|---|
|
dbo.schema_updates (Imports/Updates)
|
Used by
| Name |
|---|
|
dbo.schema_updates (Imports/Updates)
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:11