tet

Tables (7)

CATEGORI_TB

  • CATEGORI_ID — VARCHAR(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 — VARCHAR(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
  • USER_ID (USER_ID2) — VARCHAR(20) — Primary key — NOT NULL
  • TB_NO — INT(3) — Foreign key → TB_TB.TB_NO — NOT NULL
  • QR_TIME — DATETIME — NOT NULL

TB_TB

  • TB_NO — INT(3) — Primary key — NOT NULL
  • USER_ID — VARCHAR(20) — Foreign key → USERS_TB.USER_ID — 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