|
id
|
int(10) unsigned
|
|
|
|
|
customer_id
|
int(10) unsigned
|
|
|
استعرض القيم الغريبة
|
|
quote_code
|
varchar(50)
|
|
|
|
|
issue_date
|
date
|
|
|
|
|
subtotal
|
decimal(10,2)
|
|
|
0.00
|
|
vat_amount
|
decimal(10,2)
|
|
|
0.00
|
|
total
|
decimal(10,2)
|
|
|
0.00
|
|
vat_enabled
|
tinyint(1)
|
|
|
1
|
|
status
|
enum
|
-- |
|
draft
|
|
notes
|
text
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
|
customer_name
|
varchar(255)
|
|
|
|
|
customer_phone
|
varchar(255)
|
|
|
|
|
vehicle_id
|
int(11)
|
|
|
|
|
converted_sale_id
|
int(10) unsigned
|
|
|
|
|
document_type
|
varchar(20)
|
|
|
quote
|
|
customer_email
|
varchar(191)
|
|
|
|
|
customer_address
|
varchar(255)
|
|
|
|
|
customer_tax_no
|
varchar(80)
|
|
|
|
|
vat_rate
|
decimal(5,2)
|
|
|
15.00
|
|
grand_total
|
decimal(12,2)
|
|
|
0.00
|
|
template_key
|
varchar(40)
|
|
|
classic
|
|
invoice_template
|
varchar(120)
|
|
|
|