storage_availability
Table comments: store the avaibility of rack space
for
each warehouse
| Column | Type | Null | Default | Links to |
Comments |
MIME |
|---|
| warehouse_id (Primary) | int(11) | No | | |
|
|
| availability_before | int(11) | No | | |
how many rack places are available until
date_move |
|
| date_move | date | No | | |
|
|
| availability_after | int(11) | No | | |
how many rack places are available after
date_move |
|
Indexes
No index defined!
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|
| PRIMARY | BTREE | Yes | No | warehouse_id | 8 | A | No | |
| date_move | BTREE | No | No | date_move | 8 | A | No | |
warehouse_info
| Column | Type | Null | Default | Links to |
Comments |
MIME |
|---|
| warehouse_id (Primary) | int(11) | No | | |
|
|
| w_name | varchar(40) | No | | |
|
|
| w_region | varchar(20) | No | | |
|
|
Indexes
No index defined!
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|
| PRIMARY | BTREE | Yes | No | warehouse_id | 8 | A | No | |
| w_name | BTREE | No | No | w_name | 8 | A | No | |
| w_region | 8 | A | No |