CompLink
Component Link
|
Name |
Type (MS SQL) |
Type (Oracle) |
Type (PostgreSQL) |
Nullable |
Description |
|---|---|---|---|---|---|
|
Id |
BIGINT |
NUMBER(20,0) |
int8 |
not null unique |
Id of the object |
|
Name |
NVARCHAR(255) |
NVARCHAR2(255) |
varchar(255) |
not null |
Name of the object |
|
Description |
NVARCHAR(2000) |
NVARCHAR2(2000) |
varchar(2000) |
|
Description of the object |
|
CreationTime |
DATETIME |
TIMESTAMP(4) |
timestamp |
not null |
Creation time |
|
Creator |
NVARCHAR(255) |
NVARCHAR2(255) |
varchar(255) |
not null |
Creator |
|
LastChanged |
DATETIME |
TIMESTAMP(4) |
timestamp |
|
Last modification time |
|
LastModifiedBy |
NVARCHAR(255) |
NVARCHAR2(255) |
varchar(255) |
|
User who modified the item |
|
OfComponentId |
BIGINT |
NUMBER(20,0) |
int8 |
|
Reference to the component on which the link is defined |
|
ToComponentId |
BIGINT |
NUMBER(20,0) |
int8 |
|
Reference to the component to which the link is established |
Foreign Keys
|
Name |
Local References |
Foreign References |
|---|---|---|
|
FK_CompLink_From |
OfComponentId |
Component |
|
FK_CompLink_To |
ToComponentId |
Component |