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