catissue_base_shipment

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
LABEL VARCHAR 50 √ null
SENDER_SITE_ID BIGINT 19 √ null
catissue_site.IDENTIFIER FK84DE7ECCB0ACF1C7R
RECEIVER_SITE_ID BIGINT 19 √ null
catissue_site.IDENTIFIER FK84DE7ECCCAF26781R
SENDER_USER_ID BIGINT 19 √ null
catissue_user.IDENTIFIER FK84DE7ECC2ABD7347R
RECEIVER_USER_ID BIGINT 19 √ null
catissue_user.IDENTIFIER FK84DE7ECC4502E901R
SENDER_COMMENTS VARCHAR 255 √ null
RECEIVER_COMMENTS VARCHAR 255 √ null
CREATED_DATE DATE 10 √ null
SEND_DATE DATETIME 19 √ null
ACTIVITY_STATUS VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK84DE7ECC2ABD7347 Performance Asc SENDER_USER_ID
FK84DE7ECC4502E901 Performance Asc RECEIVER_USER_ID
FK84DE7ECCB0ACF1C7 Performance Asc SENDER_SITE_ID
FK84DE7ECCCAF26781 Performance Asc RECEIVER_SITE_ID

Relationships

Close relationships within degrees of separation