jmeeuynz_digitalso
Tables invoices
| Field | Type | Default | Key | Action |
|---|---|---|---|---|
| id | int | NULL | PRI | |
| order_id | bigint | NULL | MUL | |
| order_number | bigint | NULL | ||
| client_username | varchar(255) | NULL | ||
| client_first_name | varchar(100) | NULL | ||
| client_last_name | varchar(100) | NULL | ||
| client_email | varchar(255) | NULL | ||
| client_phone_number | varchar(100) | NULL | ||
| client_tax_number | varchar(255) | NULL | ||
| client_address | varchar(500) | NULL | ||
| client_country | varchar(100) | NULL | ||
| client_state | varchar(100) | NULL | ||
| client_city | varchar(100) | NULL | ||
| invoice_items | text | NULL | ||
| created_at | timestamp | CURRENT_TIMESTAMP |