ta2
Tables (7)
CATEGORI_TB
- CATEGORI_ID — INT(20) — Primary key — NOT NULL
- USER_ID — VARCHAR(20) — Foreign key → USERS_TB.USER_ID — NOT NULL
- CATEGORI_NAME — VARCHAR(20) — NOT NULL
- CATEGORI_STATE — INT(1) — NOT NULL
ODERDETAIL_TB
- ORDER_NO — INT(4) — Foreign key → ORDER_TB.ORDER_NO — NOT NULL
- TB_NO — INT(3) — Foreign key → ORDER_TB.TB_NO — NOT NULL
- ORDER_DATE — DATE — Foreign key → ORDER_TB.ORDER_DATE — NOT NULL
- PRODUCT_ID — INT(4) — Foreign key → PRODUCT_TB.PRODUCT_ID — NOT NULL
- USER_ID — VARCHAR(20) — Foreign key → PRODUCT_TB.USER_ID — NOT NULL
- CATEGORI_ID — INT(20) — Foreign key → PRODUCT_TB.CATEGORI_ID — NOT NULL
- MENU_PRICE — DECIMAL(18,2) — NOT NULL
ORDER_TB
- ORDER_DATE — DATE — Primary key — NOT NULL
- ORDER_NO — INT(4) — Primary key — NOT NULL
- USER_ID — VARCHAR(20) — Foreign key → USERS_TB.USER_ID — NOT NULL
- TB_NO — INT(3) — Foreign key → TB_TB.TB_NO — NOT NULL
- ORDER_TIME — DATETIME — NOT NULL
- ORDER_TYPE — VARCHAR(2) — NOT NULL
- ORDER_TOTALPRICE — DECIMAL(18,2) — NOT NULL
PRODUCT_TB
- PRODUCT_ID — INT(4) — Primary key — NOT NULL
- USER_ID — VARCHAR(20) — Foreign key → USERS_TB.USER_ID — NOT NULL
- CATEGORI_ID — INT(20) — Foreign key → CATEGORI_TB.CATEGORI_ID — NOT NULL
- MENU_ID — VARCHAR(20) — NOT NULL
- MENU_DESCRIPTION — VARCHAR(1000) — NOT NULL
- MENU_PRICE — INT(18) — NOT NULL
- MENU_IMAGE — BLOB — NOT NULL
- MENU_STATE — INT(1) — NOT NULL
QR_TB
- QR_SEQUENCE — INT(4) — Primary key — NOT NULL
- QR_SERIALNUMBER — INT(10) — Primary key — NOT NULL
- TB_NO — INT(3) — Foreign key → TB_TB.TB_NO — NOT NULL
- USER_ID2 — VARCHAR(20) — Foreign key — NOT NULL
- QR_TIME — DATETIME — NOT NULL
TB_TB
- TB_NO — INT(3) — Primary key — NOT NULL
- USER_ID — VARCHAR(20) — NOT NULL
- TB_STATE — INT(1) — NOT NULL
USERS_TB
- USER_ID — VARCHAR(20) — Primary key — NOT NULL
- USER_PASSWORD — VARCHAR(20) — NOT NULL
- USER_NAME — VARCHAR(20) — NOT NULL
- USER_TELLNUMBER — VARCHAR(20) — NOT NULL
- USER_ADDRESS — VARCHAR(100) — NOT NULL