CafeShop
Tables (5)
CATEGORY (Untitled)
- ID (Key) — Primary key — NOT NULL
- NAME (Field2)
- CREATE_DATE (Field3)
- UPDATE_DATE (Field4)
DINNING_TABLE (Untitled3)
- ID (Key) — Primary key — NOT NULL
- DINNING_TABLE_NO (Field)
- IS_MERGE_TABLE (Field2)
- TABLE_IDS (TABLE.ID)
ITEM (Untitled2)
- ID (Key) — Primary key — NOT NULL
- CATEGORY_ID (CATEGORY.ID)
- NAME (Field2)
- CREATE_DATE (Field3)
- UPDATE_DATE (Field4)
- PRICE (Field)
ORDER (Untitled4)
- ID (Key) — Primary key — NOT NULL
- Field
TABLE (Untitled5)
- ID (Key) — Primary key — NOT NULL
- TABLE_NO (Field)
- DESCRIPTION (Field2)
- STATUS (0: avaliable; 1: not avaliable)
- Field4
- Field5