kiosk

Tables (14)

discount_policy

  • id — SERIAL
  • discount_type — VARCHAR(20)
  • discount_name — VARCHAR(50) — NOT NULL
  • discount_value — INT — NOT NULL
  • is_percentage — BOOLEAN — NOT NULL
  • start_date — TIMESTAMP
  • end_date — TIMESTAMP

kiosk

  • id — SERIAL
  • kiosk_code — VARCHAR(50) — NOT NULL
  • store_id — INT
  • last_updated_at — TIMESTAMP

kiosk_order_items

  • id — SERIAL
  • orders_id — INT
  • quantity — INT — NOT NULL
  • amount — INT — NOT NULL
  • menu_info — TEXT

kiosk_orders

  • id — SERIAL
  • kiosk_id — INT
  • order_number — VARCHAR(50) — NOT NULL
  • credit_card_amount — INT
  • cash_amount — INT
  • other_payment — BOOLEAN
  • is_takeout — BOOLEAN
  • created_at — TIMESTAMP

menu

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • image_url — TEXT
  • category — VARCHAR(50)
  • 스무디 — 프라페'))
  • subcategory — VARCHAR(50)
  • additional_options — TEXT

menu_tag

  • id — SERIAL
  • tag_name — VARCHAR(50) — NOT NULL
  • menu_id — INT

mobile_coupon

  • id — SERIAL
  • menu_id — INT
  • coupon_name — VARCHAR(50) — NOT NULL
  • coupon_value — UUID — NOT NULL
  • coupon_status — VARCHAR(10)
  • issued_at — TIMESTAMP
  • used_at — TIMESTAMP
  • expired_at — TIMESTAMP

order_menu

  • id — SERIAL
  • order_id — INT
  • menu_id — INT
  • quantity — INT — NOT NULL

orders

  • id — SERIAL
  • user_id — INT
  • kiosk_id — INT
  • store_id — INT
  • total_price — INT — NOT NULL
  • order_type — VARCHAR(20)
  • order_source — VARCHAR(20)
  • created_at — TIMESTAMP

payment

  • id — SERIAL
  • order_id — INT
  • payment_method — VARCHAR(20)
  • 카카오 — 페이'
  • payment_amount — INT — NOT NULL
  • payment_status — VARCHAR(10)
  • payment_message — TEXT
  • created_at — TIMESTAMP

payment_logs

  • id — SERIAL
  • transaction_id — VARCHAR(50) — NOT NULL
  • card_company — VARCHAR(50)
  • card_number — VARCHAR(20)
  • approval_number — VARCHAR(50)
  • amount — INT — NOT NULL
  • requested_at — TIMESTAMP

refund_logs

  • id — SERIAL
  • order_id — INT
  • refund_reason — TEXT
  • refund_amount — INT — NOT NULL
  • refunded_at — TIMESTAMP

store

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL

users

  • id — SERIAL
  • coupon_id — INT
  • membership_info — TEXT
  • reward_points — INT
  • created_at — TIMESTAMP