program_folder


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_file.folder_id FK_tdy9ta026virwhrdkpabir6e6 R
program_folder.parent_id FK_80y2jk0jo2cuao7wb9d0akox5 R
archived BIT 1 b'0'
company_id INT 10 √ null
sys_companies.company_id FK_m9i49q4bj2tj5h9lsimop0b0c R
company_type_id INT 10 √ null
sys_company_types.type_id FK_1i1naghrorf4497ss7u6ya8lg R
date_created DATETIME 19 null
description VARCHAR 255 √ null
document_type_id BIGINT 19 √ null
program_document_type.id FK_rvy8wwltsknl2xtee45j1ekwh R
last_updated DATETIME 19 null
name VARCHAR 255 null
parent_id BIGINT 19 √ null
program_folder.id FK_80y2jk0jo2cuao7wb9d0akox5 R
program_id BIGINT 19 √ null
program.id FK_rov7cjd3aoreli3gt9bn4yvgb R
s3name VARCHAR 255 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_1i1naghrorf4497ss7u6ya8lg Performance Asc company_type_id
FK_m9i49q4bj2tj5h9lsimop0b0c Performance Asc company_id
FK_rov7cjd3aoreli3gt9bn4yvgb Performance Asc program_id
FK_rvy8wwltsknl2xtee45j1ekwh Performance Asc document_type_id
unique_name Must be unique Asc/Asc parent_id + name

Relationships

Close relationships within degrees of separation