| bill_id |
int(11)
|
|
|
|
| bill_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| load_id |
int(11)
|
|
|
Browse foreign values
|
| client_id |
int(11)
|
|
|
|
| destination_warehouse_id |
int(11)
|
|
|
|
| sender_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| sender_phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| receiver_name |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| receiver_phone |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| delivery_address |
text
|
utf8mb4_unicode_ci
|
|
|
| item_description |
text
|
utf8mb4_unicode_ci
|
|
|
| quantity |
int(11)
|
|
|
|
| weight |
decimal(10,2)
|
|
|
|
| amount |
decimal(10,2)
|
|
|
|
| status |
enum('pending', 'assigned', 'in_transit', 'delivered', 'cancelled')
|
utf8mb4_unicode_ci
|
|
|
| priority |
enum('normal', 'high', 'urgent')
|
utf8mb4_unicode_ci
|
|
|
| created_by |
int(11)
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| delivered_at |
timestamp
|
|
|
|
| delivery_notes |
text
|
utf8mb4_unicode_ci
|
|
|