| Column | Type | Actions |
|---|---|---|
| id | int(11) | |
| invoice_number | varchar(50) | |
| invoice_date | date | |
| due_date | date | |
| status | enum('draft','sent','partially_paid','paid','overdue','cancelled') | |
| currency | varchar(10) | |
| currency_symbol | varchar(10) | |
| client_name | varchar(191) | |
| client_company | varchar(191) | |
| client_email | varchar(191) | |
| client_phone | varchar(100) | |
| client_address | varchar(500) | |
| client_tax_number | varchar(100) | |
| project_source | enum('none','design','dev') | |
| project_id | int(11) | |
| project_number | varchar(100) | |
| project_title | varchar(255) | |
| project_description | text | |
| subtotal | decimal(14,2) | |
| discount_type | enum('none','percentage','fixed') | |
| discount_value | decimal(12,2) | |
| discount_amount | decimal(14,2) | |
| tax_label | varchar(50) | |
| tax_type | enum('none','percentage','fixed') | |
| tax_value | decimal(12,2) | |
| tax_amount | decimal(14,2) | |
| shipping_amount | decimal(14,2) | |
| extra_charges_total | decimal(14,2) | |
| total_amount | decimal(14,2) | |
| amount_paid | decimal(14,2) | |
| amount_due | decimal(14,2) | |
| notes | text | |
| terms_conditions | text | |
| header_text | text | |
| footer_text | text | |
| logo_path | varchar(255) | |
| signature_path | varchar(255) | |
| signature_label | varchar(191) | |
| signature_name | varchar(191) | |
| signature_designation | varchar(191) | |
| stamp_path | varchar(255) | |
| stamp_width | int(11) | |
| stamp_position | enum('left','center','right') | |
| stamp_opacity | tinyint(3) unsigned | |
| template_id | int(11) | |
| primary_color | varchar(20) | |
| secondary_color | varchar(20) | |
| text_color | varchar(20) | |
| background_color | varchar(20) | |
| border_color | varchar(20) | |
| font_family | varchar(50) | |
| font_size | enum('small','normal','large') | |
| border_style | enum('none','solid','dashed','rounded') | |
| table_style | enum('minimal','classic','modern','bordered') | |
| header_style | enum('classic','modern','minimal','corporate') | |
| logo_width | int(11) | |
| logo_height | int(11) | |
| logo_alignment | enum('left','center','right') | |
| header_layout | enum('left','center','right') | |
| footer_alignment | enum('left','center','right') | |
| show_header | tinyint(1) | |
| show_logo | tinyint(1) | |
| show_client | tinyint(1) | |
| show_project | tinyint(1) | |
| show_due_date | tinyint(1) | |
| show_payment_info | tinyint(1) | |
| show_notes | tinyint(1) | |
| show_terms | tinyint(1) | |
| show_signature | tinyint(1) | |
| show_stamp | tinyint(1) | |
| show_footer | tinyint(1) | |
| payment_heading | varchar(191) | |
| payment_instructions | text | |
| bank_details | text | |
| created_by | int(11) | |
| created_at | timestamp | |
| updated_at | timestamp |