sys_company_types


Columns

Column Type Size Nulls Auto Default Children Parents Comments
type_id INT 10 √ null
asset_type.company_type_id FK_asset_type_company_type R
plg_asset_type.company_type_id FK_plg_asset_type_company_type R
program_folder.company_type_id FK_1i1naghrorf4497ss7u6ya8lg R
survey_participation.company_type_id FK_jt8fimjcbq7lbappcdtisroi8 R
survey_response.company_type_id FK_fp5mvl50ttg02gxfkvmyxi17g R
sys_companies.type_id FKFD9A3EE973874CAE R
workflow_type.vendor_quote_vendor_type_id FK_bfd55mv84uxtqwuj6x57o9uiv R
name VARCHAR 100 null
role_id INT 10 √ null
sys_roles.role_id FK5B8C0C45839C9EC3 R
store_watch_eligible BIT 1 b'1'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc type_id
FK5B8C0C45839C9EC3 Performance Asc role_id
name Must be unique Asc name

Relationships

Close relationships within degrees of separation