TBL_CUSTOMER_FOOD_ORDER_HEADER
Tables (4)
TBL_CUSTOMER_FOOD_ORDER_HEADER (주문내역)
- ORDER_ID — VARCHAR — Foreign key → TBL_CUSTOMER_FOOD_ORDER_ITEM.ORDER_ID — NOT NULL
- CUST_ID (Field) — VARCHAR(20)
- REG_DATE — VARCHAR(20)
- REG_TIME — VARCHAR(8)
- UPT_DATE — VARCHAR(20)
- UPT_TIME — VARCHAR(8)
TBL_CUSTOMER_FOOD_ORDER_ITEM (주문)
- ORDER_ID — VARCHAR — Primary key — NOT NULL
- FOOD_ID — VARCHAR — Foreign key → TBL_FOOD_INFO.FOOD_ID — NOT NULL
- REG_DATE — VARCHAR(20)
- REG_TIME — VARCHAR(8)
- UPT_DATE — VARCHAR(20)
- UPT_TIME — VARCHAR(8)
- FOOD_CNT — int
- PRICE — int
TBL_FOOD_INFO (음식메뉴)
- FOOD_ID — VARCHAR — Primary key — NOT NULL
- STORE_ID — VARCHAR — Foreign key → TBL_STORE_INFO.STORE_ID — NOT NULL
- FOOD_NAME — VARCHAR(255)
- REG_DATE — VARCHAR(20)
- REG_TIME — VARCHAR(8)
- UPT_DATE — VARCHAR(20)
- UPT_TIME — VARCHAR(8)
TBL_STORE_INFO (음식코너)
- STORE_ID — VARCHAR — Primary key — NOT NULL
- STORE_NAME — VARCHAR(255)
- REG_DATE — VARCHAR(20)
- REG_TIME — VARCHAR(8)
- UPT_DATE — VARCHAR(20)
- UPT_TIME — VARCHAR(8)