companies

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
advertising_media.company_id advertising_media_company_id_foreignR
arrow_ip_addresses.company_id arrow_ip_addresses_company_id_foreignC
company_addition_items.company_id company_addition_items_company_id_foreignC
company_analysis_configs.company_id company_analysis_configs_company_id_foreignR
company_estimation_templates.company_id company_estimation_templates_company_id_foreignR
company_feature_permission.company_id company_feature_permission_company_id_foreignC
company_questionnaire_configs.company_id company_questionnaire_configs_company_id_foreignR
company_settings.company_id company_settings_company_id_foreignR
company_task_templates.company_id company_task_templates_company_id_foreignC
customer_statuses.company_id customer_statuses_company_id_foreignR
customers.company_id customers_company_id_foreignR
inquiry_definitions.company_id inquiry_definitions_company_id_foreignR
nested_groups.company_id nested_groups_company_id_foreignR
roles.company_id roles_company_id_foreignR
stores.company_id stores_company_id_foreignR
virtual_bank_accounts.company_id virtual_bank_accounts_company_id_foreignR

PK
kimaroom_id BIGINT UNSIGNED 20 null

キマRoom!会社ID
name VARCHAR 255 null

会社名
account_name VARCHAR 30 null

アカウント名
addition_limit INT 10 10

追加項目の上限値
api_token VARCHAR 64 null

アクセストークン
synced_at DATETIME 26 √ null

同期日時
created_at TIMESTAMP 26 √ null
updated_at TIMESTAMP 26 √ null
deleted_at TIMESTAMP 26 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
companies_account_name_unique Must be unique Asc account_name
companies_api_token_unique Must be unique Asc api_token
companies_kimaroom_id_unique Must be unique Asc kimaroom_id

Relationships

Close relationships within degrees of separation