target_area_document


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
date_created DATETIME 19 √ null
extension VARCHAR 255 √ null
file_size BIGINT 19 √ null
index_number INT 10 √ null
stores_non_branded.number Implied Constraint R
last_update_user_id INT 10 √ null
sys_users.user_id FK_qehxlv74jodsx7lf7yw723v38 R
last_updated DATETIME 19 √ null
s3name VARCHAR 255 √ null
type_id INT 10 √ null
target_area_document_type.id FK_1jdlxqxh7m9hinlj2pqdtmoe3 R
candidate_id BIGINT 19 √ null
target_area_candidate.id FK_4ygvyo4h37a4mv2jxwh20g7p3 R
exception_type_id BIGINT 19 √ null
target_area_exception_document_type.id fk_exception_type R
target_area_id INT 10 null
target_area.id fk_ta_doc_ta R
infix VARCHAR 40 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_1jdlxqxh7m9hinlj2pqdtmoe3 Performance Asc type_id
FK_4ygvyo4h37a4mv2jxwh20g7p3 Performance Asc candidate_id
fk_exception_type Performance Asc exception_type_id
FK_qehxlv74jodsx7lf7yw723v38 Performance Asc last_update_user_id
fk_ta_doc_ta Performance Asc target_area_id

Relationships

Close relationships within degrees of separation