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