sys_companies


Columns

Column Type Size Nulls Auto Default Children Parents Comments
company_id INT 10 √ null
asset_type.vendor_id FK7EF1B3298A57A86 R
company_email.company_id FK5193D95A16D99B31 R
company_subcontractor.company_id FK_4m0n148qldxi5eqmoe45cr3i4 R
legal.law_firm_id FK62162B9EF708433 R
program_company.company_id FK_nvusa1grl64uxm1pc889lrvmn R
program_company_contact.company_id FK_55e0cju3q0li25we2oigckine R
program_folder.company_id FK_m9i49q4bj2tj5h9lsimop0b0c R
program_workflow_participant.company_id FK_pxic3r88936136qqla6s1kup4 R
project_company.company_id FKA9FB055716D99B31 R
project_company_contact.company_id FKFDAE893816D99B31 R
punch_list_item.vendor_id FKDB8A30438A57A86 R
sitepack.builder_company_id FK284B45E0A407C255 R
sitepack.law_firm_id FK284B45E0EF708433 R
sys_company_users.company_id FK5B9741D416D99B31 R
vendor_task.company_id FK_ffm9ku4hyh3atqqar4aelhika R
workflow_participant.company_id FKB87D7EB316D99B31 R
name VARCHAR 100 null
active BIT 1 b'1'
principal_id INT 10 √ null
sys_users.user_id FKFD9A3EE967CE5F60 R
type_id INT 10 √ null
sys_company_types.type_id FKFD9A3EE973874CAE R
address VARCHAR 50 √ null
address2 VARCHAR 50 √ null
city VARCHAR 30 √ null
phone VARCHAR 10 √ null
state VARCHAR 2 √ null
zip VARCHAR 10 √ null
legal_name VARCHAR 256 √ null
contract_holder_id INT 10 √ null
site_contract_holder.contract_holder_id FK_kik7opfv991d3bl99cl2c8usd R
secondary_id INT 10 √ null
sys_users.user_id FK_1vqanfqlxucybv9714neuv3is R
website VARCHAR 200 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc company_id
FK_1vqanfqlxucybv9714neuv3is Performance Asc secondary_id
FK_kik7opfv991d3bl99cl2c8usd Performance Asc contract_holder_id
FKFD9A3EE967CE5F60 Performance Asc principal_id
FKFD9A3EE973874CAE Performance Asc type_id
sys_comp_idx Performance Asc/Asc company_id + name

Relationships

Close relationships within degrees of separation