| id |
int(11)
|
|
|
|
| forecast_no |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| owner_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| owner_employee_id |
int(11)
|
|
|
|
| customer_id |
int(11)
|
|
|
|
| company_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| contact_name |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| contact_phone |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| contact_email |
varchar(180)
|
utf8mb4_unicode_ci
|
|
|
| project_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| product_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| source |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| stage |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| status |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| probability |
decimal(5,2)
|
|
|
|
| currency |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| cost_amount |
decimal(15,2)
|
|
|
|
| sales_amount |
decimal(15,2)
|
|
|
|
| gross_profit |
decimal(15,2)
|
|
|
|
| gross_margin |
decimal(8,2)
|
|
|
|
| weighted_amount |
decimal(15,2)
|
|
|
|
| expected_order_date |
date
|
|
|
|
| expected_start_date |
date
|
|
|
|
| expected_finish_date |
date
|
|
|
|
| next_followup_date |
date
|
|
|
|
| quotation_id |
int(11)
|
|
|
|
| order_id |
int(11)
|
|
|
|
| project_id |
int(11)
|
|
|
|
| description |
text
|
utf8mb4_unicode_ci
|
|
|
| last_followup_note |
text
|
utf8mb4_unicode_ci
|
|
|
| created_by |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| updated_by |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
