Table slot9.WORLD.TSTA.PROPERTY_XREFS
This table stores external ids for a property from external applications or interfaces. Data is uploaded through the Property XML import
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
PRIMARY_PROPERTY_ID number 0
PROPERTIES.PROPERTY_ID PROPX_PRI_PROPERTY_FK C
PROPERTY ID number assigned for Parent Property
RELATED_PROPERTY_ID number 0
PROPERTIES.PROPERTY_ID PROPX_REL_PROPERTY_FK C
PROPERTY ID assigned to Related/Child Property
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null Date Record was created
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null Date Record was last updated
XREF_COMMENT varchar2 255  √  null Comments
REC_ID number 0  √  null
DATE_OF_INFO date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"PRIMARY_PROPERTY_ID" IS NOT NULL PROPX_PRIMARY_PROPERTY_ID_NN
"RELATED_PROPERTY_ID" IS NOT NULL PROPX_RELATED_PROPERTY_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
PRIMARY_PROPERTY_ID + RELATED_PROPERTY_ID Primary key Asc/Asc PROPX_PK
PRIMARY_PROPERTY_ID Performance Asc PROPX_PRI_PROPERTY_FK_I
RELATED_PROPERTY_ID Performance Asc PROPX_REL_PROPERTY_FK_I

Close relationships  within of separation: