Table: dbo.ignored_objects (Ignored objects)

Schema dbo
Name ignored_objects
Title Ignored objects
Module Utils

Objects ignored from import from DBMS.

Columns
PK Name Data type Null Attributes Description
1 ignored_object_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 database_id int Documentation from which object was ignored.
Documentation from which object was ignored.
3 schema nvarchar(250) Schema name.
Schema name.
4 name nvarchar(250) Database object name.
Database object name.
5 object_type nvarchar(100) Type of database object: TABLE/VIEW/PROCEDURE/FUNCTION
Type of database object: TABLE/VIEW/PROCEDURE/FUNCTION
6 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
7 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
8 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
9 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
Relations
Foreign table Primary table Join Title / Name / Description
dbo.ignored_objects dbo.databases dbo.ignored_objects.database_id = dbo.databases.database_id FK_ignored_objects_databases
dbo.ignored_objects.database_id = dbo.databases.database_id
FK_ignored_objects_databases
Unique keys
Key name Columns Description
PK_ignored_objects ignored_object_id Table primary key.
Table primary key.
Triggers
Key name When Description
trg_ignored_objects_Modify After Insert, Update Standard insert/update trigger setting last_modification_date, modified by columns
Standard insert/update trigger setting last_modification_date, modified by columns
Uses
Name
dbo.ignored_objects (Ignored objects)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30