estimations

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT UNSIGNED 20 √ null
estimation_action_logs.estimation_id estimation_action_logs_estimation_id_foreignR
estimation_approvals.estimation_id estimation_approvals_estimation_id_foreignR
estimation_jsb_costs.estimation_id estimation_jsb_costs_estimation_id_foreignR
estimation_jsb_details.estimation_id estimation_jsb_details_estimation_id_foreignR
no BIGINT UNSIGNED 20 √ null

見積もりno
template_code VARCHAR 255 null
company_estimation_templates.template_code estimations_template_code_foreignR

見積書の書式コード
store_id BIGINT UNSIGNED 20 null
stores.id estimations_store_id_foreignR

店舗ID
author_id BIGINT UNSIGNED 20 null
staffs.id estimations_author_id_foreignR

作成者ID (担当者ID)
name VARCHAR 200 null

見積名
rent_type enum('housing', 'parking', 'business') 8 null

物件種別
rent_id BIGINT UNSIGNED 20 √ null

キマRoom!物件ID
rent_name VARCHAR 50 null

物件名
room_name VARCHAR 20

部屋名称
rent_number VARCHAR 20

物件部屋番号
rent_managed_code VARCHAR 20

自社管理番号
contractor_id BIGINT UNSIGNED 20 null
customers.id estimations_contractor_id_foreignR

契約者ID (顧客ID)
contractor_name VARCHAR 255 null

契約者名
contract_start_date DATE 10 null

契約期間 開始日
contract_end_date DATE 10 null

契約期間 満了日
renew_period_year INT UNSIGNED 10 null

更新期間 年
renew_period_month INT UNSIGNED 10 null

更新期間 月
amount INT UNSIGNED 10 null

契約金
deposit INT UNSIGNED 10 null

契約手数料
total_amount INT UNSIGNED 10 null

契約金総額(契約金+手数料)
amount_limit_date DATE 10 √ null

契約金締切日
deposit_limit_date DATE 10 √ null

契約手数料締切日
last_applied_at TIMESTAMP 26 √ null

最終申請日時
last_rejected_at TIMESTAMP 26 √ null

最終否認日時
approver_id BIGINT UNSIGNED 20 √ null
staffs.id estimations_approver_id_foreignR

承認者ID (担当者ID)
approved_at TIMESTAMP 26 √ null

承認日時
sent_at TIMESTAMP 26 √ null

送信日時
status enum('draft', 'review', 'approved', 'sent') 8 null

状態
memo TEXT 65535 null

メモ
pdf_path VARCHAR 255 √ null

ファイルパス
pdf_generating_progress enum('waiting', 'creating', 'complete', 'error') 8 null

PDF生成進行状況
pdf_generate_requested_at TIMESTAMP 26 null

PDF生成リクエスト日時
is_exists TINYINT 3 √ 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
estimations_approver_id_foreign Performance Asc approver_id
estimations_author_id_foreign Performance Asc author_id
estimations_contractor_id_foreign Performance Asc contractor_id
estimations_no_is_exists_unique Must be unique Asc/Asc no + is_exists
estimations_store_id_foreign Performance Asc store_id
estimations_template_code_foreign Performance Asc template_code

Relationships

Close relationships within degrees of separation