|
id
|
int(11)
|
|
|
|
|
business_name
|
varchar(255)
|
|
|
|
|
website
|
varchar(255)
|
|
|
|
|
cr_number
|
varchar(255)
|
|
|
|
|
vat_number
|
varchar(255)
|
|
|
|
|
phone
|
varchar(255)
|
|
|
|
|
email
|
varchar(255)
|
|
|
|
|
address
|
text
|
|
|
|
|
vat_enabled
|
tinyint(1)
|
|
|
1
|
|
show_vat_line
|
tinyint(1)
|
|
|
1
|
|
show_discount_line
|
tinyint(1)
|
|
|
1
|
|
show_terms
|
tinyint(1)
|
|
|
1
|
|
show_notes
|
tinyint(1)
|
|
|
1
|
|
show_bank_info
|
tinyint(1)
|
|
|
0
|
|
show_stamp_place
|
tinyint(1)
|
|
|
1
|
|
show_watermark
|
tinyint(1)
|
|
|
0
|
|
show_qr
|
tinyint(1)
|
|
|
0
|
|
logo_path
|
varchar(255)
|
|
|
|
|
currency_symbol
|
varchar(20)
|
|
|
|
|
document_type
|
varchar(30)
|
|
|
|
|
invoice_title_ar
|
varchar(255)
|
|
|
|
|
invoice_title_en
|
varchar(255)
|
|
|
|
|
primary_color
|
varchar(20)
|
|
|
|
|
secondary_color
|
varchar(20)
|
|
|
|
|
surface_color
|
varchar(20)
|
|
|
|
|
text_color
|
varchar(20)
|
|
|
|
|
muted_text_color
|
varchar(20)
|
|
|
|
|
border_color
|
varchar(20)
|
|
|
|
|
accent_color
|
varchar(20)
|
|
|
|
|
table_header_bg
|
varchar(20)
|
|
|
|
|
table_header_text
|
varchar(20)
|
|
|
|
|
table_alt_row_bg
|
varchar(20)
|
|
|
|
|
footer_bg
|
varchar(20)
|
|
|
|
|
footer_text_color
|
varchar(20)
|
|
|
|
|
footer_note
|
text
|
|
|
|
|
terms_text
|
text
|
|
|
|
|
notes_text
|
text
|
|
|
|
|
bank_name
|
varchar(255)
|
|
|
|
|
iban
|
varchar(255)
|
|
|
|
|
swift_code
|
varchar(255)
|
|
|
|
|
watermark_text
|
varchar(255)
|
|
|
|
|
document_number_label
|
varchar(255)
|
|
|
|
|
date_label
|
varchar(255)
|
|
|
|
|
customer_label
|
varchar(255)
|
|
|
|
|
vehicle_label
|
varchar(255)
|
|
|
|
|
invoice_template
|
varchar(50)
|
|
|
|
|
paper_size
|
varchar(20)
|
|
|
|
|
competitor_label_agency
|
varchar(255)
|
|
|
|
|
competitor_label_1
|
varchar(255)
|
|
|
|
|
competitor_label_2
|
varchar(255)
|
|
|
|
|
font_heading
|
varchar(100)
|
|
|
|
|
font_body
|
varchar(100)
|
|
|
|
|
font_size_body
|
smallint(5) unsigned
|
|
|
|
|
font_size_heading
|
smallint(5) unsigned
|
|
|
|
|
font_size_small
|
smallint(5) unsigned
|
|
|
|
|
line_height
|
decimal(4,2)
|
|
|
|
|
row_style
|
varchar(30)
|
|
|
|
|
radius
|
smallint(5) unsigned
|
|
|
|
|
shadow_strength
|
smallint(5) unsigned
|
|
|
|
|
document_width
|
smallint(5) unsigned
|
|
|
|
|
header_layout
|
varchar(30)
|
|
|
|
|
totals_layout
|
varchar(30)
|
|
|
|
|
density
|
varchar(30)
|
|
|
|
|
show_logo
|
tinyint(1)
|
|
|
1
|
|
show_company_meta
|
tinyint(1)
|
|
|
1
|
|
show_customer_block
|
tinyint(1)
|
|
|
1
|
|
show_vehicle_block
|
tinyint(1)
|
|
|
1
|
|
font_size
|
tinyint(3) unsigned
|
|
|
|
|
created_at
|
datetime
|
|
|
current_timestamp()
|
|
updated_at
|
datetime
|
|
|
current_timestamp()
|