aurora_standard.orders
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| order_num | bigint(20) unsigned | NO | PRI | auto_increment | ||
| order_date | date | YES | ||||
| customer_num | int(11) | YES | ||||
| ship_instruct | varchar(40) | YES | ||||
| backlog | varchar(1) | YES | ||||
| po_num | varchar(10) | YES | ||||
| ship_date | date | YES | ||||
| ship_weight | decimal(8,2) | YES | ||||
| ship_charge | decimal(16,2) | YES | ||||
| paid_date | date | YES |
References
| Local Column | References | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| ship_date |
| ||||||||
| order_date |
|