| id |
tinyint(3)
|
|
|
|
| company_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| cr_number |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| vat_number |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| contact_phone |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| logo_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| vat_enabled |
tinyint(1)
|
|
|
|
| show_vat_line |
tinyint(1)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| invoice_template |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| competitor_label_agency |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| competitor_label_1 |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| competitor_label_2 |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| business_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| website |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| phone |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| invoice_title_ar |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| invoice_title_en |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| primary_color |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| secondary_color |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| footer_note |
text
|
utf8mb4_general_ci
|
|
|
| font_heading |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| font_body |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| font_size |
tinyint(3)
|
|
|
|
| competitor_extra_labels |
text
|
utf8mb4_general_ci
|
|
|
| email |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| address |
text
|
utf8mb4_general_ci
|
|
|
| currency_symbol |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| document_type |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| paper_size |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| surface_color |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| text_color |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| muted_text_color |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| border_color |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| accent_color |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| table_header_bg |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| table_header_text |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| table_alt_row_bg |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| footer_bg |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| footer_text_color |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| font_size_body |
tinyint(3)
|
|
|
|
| font_size_heading |
tinyint(3)
|
|
|
|
| font_size_small |
smallint(5)
|
|
|
|
| line_height |
decimal(4,2)
|
|
|
|
| row_style |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| radius |
smallint(5)
|
|
|
|
| shadow_strength |
smallint(5)
|
|
|
|
| document_width |
smallint(5)
|
|
|
|
| header_layout |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| totals_layout |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| density |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| show_logo |
tinyint(1)
|
|
|
|
| show_company_meta |
tinyint(1)
|
|
|
|
| show_customer_block |
tinyint(1)
|
|
|
|
| show_discount_line |
tinyint(1)
|
|
|
|
| show_terms |
tinyint(1)
|
|
|
|
| show_notes |
tinyint(1)
|
|
|
|
| show_bank_info |
tinyint(1)
|
|
|
|
| show_stamp_place |
tinyint(1)
|
|
|
|
| terms_text |
text
|
utf8mb4_general_ci
|
|
|
| notes_text |
text
|
utf8mb4_general_ci
|
|
|
| bank_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| iban |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| swift_code |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| watermark_text |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| document_number_label |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| date_label |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| customer_label |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| vehicle_label |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| show_vehicle_block |
tinyint(1)
|
|
|
|
| show_watermark |
tinyint(1)
|
|
|
|
| show_qr |
tinyint(1)
|
|
|
|
| stamp_text |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| paper_bg |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| muted_color |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| heading_size |
tinyint(3)
|
|
|
|
| bank_info |
text
|
utf8mb4_general_ci
|
|
|
| show_vehicle |
tinyint(1)
|
|
|
|
| show_customer_phone |
tinyint(1)
|
|
|
|
| show_stamp |
tinyint(1)
|
|
|
|
| show_bank |
tinyint(1)
|
|
|
|
| show_footer |
tinyint(1)
|
|
|
|
| stamp_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| terms |
text
|
utf8mb4_general_ci
|
|
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| bank_account |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| bank_iban |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| font_family |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| base_font_size |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| vat_rate |
decimal(5,2)
|
|
|
|
