|
id
|
int(11)
|
|
|
|
|
forecast_no
|
varchar(60)
|
|
|
|
|
owner_name
|
varchar(100)
|
|
|
|
|
owner_employee_id
|
int(11)
|
|
|
|
|
customer_id
|
int(11)
|
|
|
|
|
company_name
|
varchar(255)
|
|
|
|
|
contact_name
|
varchar(120)
|
|
|
|
|
contact_phone
|
varchar(120)
|
|
|
|
|
contact_email
|
varchar(180)
|
|
|
|
|
project_name
|
varchar(255)
|
|
|
|
|
product_name
|
varchar(255)
|
|
|
|
|
source
|
varchar(100)
|
|
|
|
|
stage
|
varchar(50)
|
|
|
lead
|
|
status
|
varchar(30)
|
|
|
open
|
|
probability
|
decimal(5,2)
|
|
|
10.00
|
|
currency
|
varchar(10)
|
|
|
TWD
|
|
cost_amount
|
decimal(15,2)
|
|
|
0.00
|
|
sales_amount
|
decimal(15,2)
|
|
|
0.00
|
|
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
|
|
|
|
|
last_followup_note
|
text
|
|
|
|
|
created_by
|
varchar(100)
|
|
|
|
|
updated_by
|
varchar(100)
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|
