Table-CONTACT_XREF
Field | Type | Constraints | Default Description |
XREF_ID | Bigint | NOT NULL | |
CONTENT_ID | Bigint | NOT NULL | |
SOURCE | Varchar(20) | NOT NULL | |
XORDER | Smallint | DEFAULT 0 | If set to 0, only single record allowed Positive to add order to multiple records of the same type |
XREF | Bigint | DEFAULT 0 | Link to cross reference record |
XKEY | Varchar(32) | Move to CONTENT_XREF | |
XKEY_EXT | Varchar(250) | Move to CONTENT_XREF | |
DATA | Blob | ||
START_DATE | Timestamp | DEFAULT 'NOW' | |
LAST_UPDATE_DATE | Timestamp | DEFAULT 'NOW' | |
ENTRY_DATE | Timestamp | DEFAULT 'NOW' | |
END_DATE | Timestamp | ||
CONTENT_ID -> LIBERTY_CONTENT
XREF -> CONTACT
SOURCE -> CONTACT_XREF_SOURCE