kakaopay_coffee

Tables (5)

TB_MENU

  • id — BIGINT — Primary key — NOT NULL
  • menu_code — BIGINT
  • name — VARCHAR(30)
  • inventory — INTEGER
  • price — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

TB_ORDER

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → TB_USER.id — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

TB_ORDER_MENU (TB_MENU_ORDER)

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → TB_ORDER.id — NOT NULL
  • user_id — BIGINT — Foreign key → TB_ORDER.user_id — NOT NULL
  • menu_id — BIGINT — Foreign key → TB_MENU.id — NOT NULL
  • menu_code — BIGINT
  • order_sequence — INTEGER
  • quantity — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

TB_USER

  • id — BIGINT — Primary key — NOT NULL
  • phone — VARCHAR(20)
  • name — VARCHAR(30)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • point — INTEGER

TB_USER_POINT_HISTORY

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → TB_USER.id — NOT NULL
  • point — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP