cafe
Tables (4)
ITEM
- ITEM_ID — number — Primary key — NOT NULL
- NAME — varchar — NOT NULL
- PRICE — number
- TYPE — varchar
ORDER
- ORDER_ID — number — Primary key — NOT NULL
- USER_ID — varchar — Foreign key → USER.USER_ID — NOT NULL
- ORDERED_DATE — date
ORDER_DESCRIPTION
- ORDER_ID — number — Foreign key → ORDER.ORDER_ID — NOT NULL
- ITEM_ID — number — Foreign key → ITEM.ITEM_ID — NOT NULL
- COUNT — number
USER
- USER_ID — varchar — Primary key — NOT NULL
- NAME — varchar
- ROLE — varchar
- PASSWORD — varchar