Inventory level
| Type | Length | PK | FK | Mode | Mandatory | Remarks | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Table | Field | Read | Write | Delete | Create | Update | |||||
| max inventory | REAL | X | |||||||||
| min inventory | REAL | X | |||||||||
| model name | STRING | 80 | X | product | model name | X | |||||
| product | STRING | 80 | product | code | X | ||||||
| quantity | REAL | X | |||||||||
| reference date | DATE | X | |||||||||
| std inventory | REAL | X | |||||||||
| unique key | STRING | 100 | X | X | [product]code (padded with spaces to 80 characters) + reference date (padded with spaces to 20 characters) | ||||||