| id |
int(11)
|
|
|
|
| order_id |
int(11)
|
|
|
|
| invoice_number |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| company_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| company_address |
text
|
utf8mb4_unicode_ci
|
|
|
| company_ein |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| company_email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| company_phone |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| company_website |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| customer_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| customer_email |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| customer_country |
varchar(5)
|
utf8mb4_unicode_ci
|
|
|
| customer_state |
varchar(5)
|
utf8mb4_unicode_ci
|
|
|
| customer_zip |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| subtotal |
decimal(10,2)
|
|
|
|
| tax_rate |
decimal(5,4)
|
|
|
|
| tax_amount |
decimal(10,2)
|
|
|
|
| discount |
decimal(10,2)
|
|
|
|
| total |
decimal(10,2)
|
|
|
|
| currency |
varchar(3)
|
utf8mb4_unicode_ci
|
|
|
| tax_jurisdiction |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| is_tax_exempt |
tinyint(1)
|
|
|
|
| invoice_date |
date
|
|
|
|
| status |
enum('created', 'sent', 'void')
|
utf8mb4_unicode_ci
|
|
|
| pdf_path |
varchar(500)
|
utf8mb4_unicode_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
