| Column | Type | Actions |
|---|---|---|
| id | int(11) | |
| company_name | varchar(191) | |
| company_tagline | varchar(255) | |
| company_address | varchar(500) | |
| company_phone | varchar(100) | |
| company_email | varchar(191) | |
| company_website | varchar(191) | |
| company_tax_number | varchar(100) | |
| company_registration_number | varchar(100) | |
| logo_path | varchar(255) | |
| default_prefix | varchar(30) | |
| default_number_padding | tinyint(3) unsigned | |
| default_currency | varchar(10) | |
| default_currency_symbol | varchar(10) | |
| default_payment_terms | varchar(255) | |
| default_notes | text | |
| default_terms | text | |
| default_footer | text | |
| default_tax_label | varchar(50) | |
| default_tax_type | enum('none','percentage','fixed') | |
| default_tax_value | decimal(12,2) | |
| default_discount_type | enum('none','percentage','fixed') | |
| default_discount_value | decimal(12,2) | |
| default_primary_color | varchar(20) | |
| default_secondary_color | varchar(20) | |
| default_font_family | varchar(50) | |
| default_template_id | int(11) | |
| payment_heading | varchar(191) | |
| payment_instructions | text | |
| bank_details | text | |
| created_at | timestamp | |
| updated_at | timestamp |