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