gg

Tables (4)

menus

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • price — BIGINT — NOT NULL
  • order_count — BIGINT — NOT NULL
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • INDEX — idx_menu_name

orders

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • menu_id — BIGINT — NOT NULL
  • total_price — BIGINT — NOT NULL
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)

payments

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • imp_uid — VARCHAR(255) — NOT NULL
  • amount — BIGINT — NOT NULL
  • status — ENUM('READY', 'PAID', 'FAILED', 'CANCELLED') — NOT NULL
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)

users

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • point — BIGINT — NOT NULL
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)