fig_cafe

Tables (7)

home_content

  • content_id — BIGINT — Primary key — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

menu

  • menu_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • category — VARCHAR(50)
  • image_url — VARCHAR(255)
  • description — TEXT
  • stock_quantity — INT — NOT NULL — 0이면 품절 처리
  • is_new — BOOLEAN
  • is_best — BOOLEAN
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

order_config

  • config_id — BIGINT — Primary key — NOT NULL
  • is_order_enabled — BOOLEAN
  • max_orders_per_10min — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

order_item

  • order_item_id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
  • menu_id — BIGINT — Foreign key → menu.menu_id — NOT NULL
  • quantity — INT — NOT NULL
  • selected_options — VARCHAR(255) — 선택 옵션 텍스트 합계
  • option_extra_price — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

orders

  • order_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • total_price — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING, ACCEPTED, READY, COMPLETED, REJECTED
  • ordered_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

payment

  • payment_id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → orders.order_id — NOT NULL
  • amount — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — READY, COMPLETED, CANCELLED, REFUNDED
  • refund_bank — VARCHAR(50)
  • refund_account_num — VARCHAR(100)
  • refund_owner — VARCHAR(50)
  • payment_time — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • real_name — VARCHAR(50) — NOT NULL — 입금자 대조용 실명
  • email — VARCHAR(100)
  • role — VARCHAR(20) — NOT NULL — USER, ADMIN
  • fcm_token — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL