|
id
|
int(11)
|
|
|
|
|
date
|
timestamp
|
|
|
current_timestamp()
|
|
sale_id
|
int(11)
|
|
|
|
|
do_reference_no
|
varchar(50)
|
|
|
|
|
sale_reference_no
|
varchar(50)
|
|
|
|
|
customer
|
varchar(55)
|
|
|
|
|
address
|
varchar(1000)
|
|
|
|
|
note
|
varchar(1000)
|
|
|
|
|
status
|
varchar(15)
|
|
|
|
|
attachment
|
varchar(50)
|
|
|
|
|
delivered_by
|
varchar(50)
|
|
|
|
|
received_by
|
varchar(50)
|
|
|
|
|
created_by
|
int(11)
|
|
|
|
|
updated_by
|
int(11)
|
|
|
|
|
updated_at
|
timestamp
|
|
|
|