newnew_erd
Tables (36)
audit_log
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36)
- action — VARCHAR(255) — NOT NULL
- ip — VARCHAR(50)
- user_agent — VARCHAR(255)
- created_at — DATETIME — NOT NULL
billing_event_log
- id — CHAR(36) — Primary key — NOT NULL
- monthly_charge_id — CHAR(36) — NOT NULL
- booking_id — CHAR(36)
- amount — INT — NOT NULL
- event_type — ENUM('RESERVATION_FEE','REFUND','AD_CHARGE') — NOT NULL
- created_at — DATETIME — NOT NULL
booking
- id — CHAR(36) — Primary key — NOT NULL
- restaurant_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — NOT NULL
- booking_type — ENUM('RESERVATION','WAITING') — NOT NULL
- date — DATE
- start_time — TIME
- end_time — TIME
- persons — INT — NOT NULL
- state — ENUM( 'RESERVED','CONFIRMED','CANCELED','NOSHOW', 'WAITING','CALLED','SEATED','EXPIRED' ) — NOT NULL
- coupon_id — CHAR(36)
- discount_price — INT — NOT NULL
- created_at — DATETIME — NOT NULL
booking_event_log
- id — CHAR(36) — Primary key — NOT NULL
- booking_id — CHAR(36)
- actor_user_id — CHAR(36)
- event_type — VARCHAR(50) — NOT NULL
- prev_state — VARCHAR(50)
- new_state — VARCHAR(50)
- description — VARCHAR(500)
- created_at — DATETIME — NOT NULL
booking_menu
- id — CHAR(36) — Primary key — NOT NULL
- booking_id — CHAR(36) — NOT NULL
- menu_id — CHAR(36) — NOT NULL
- quantity — INT — NOT NULL
- base_price — INT — NOT NULL
booking_menu_option
- id — CHAR(36) — Primary key — NOT NULL
- booking_menu_id — CHAR(36) — NOT NULL
- option_id — CHAR(36) — NOT NULL
- price — INT — NOT NULL
booking_room
- id — CHAR(36) — Primary key — NOT NULL
- booking_id — CHAR(36) — NOT NULL
- room_id — CHAR(36) — NOT NULL
- persons — INT — NOT NULL
city_code
- id — CHAR(36) — Primary key — NOT NULL
- city_name — VARCHAR(255) — NOT NULL
coupon
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — NOT NULL
- template_id — CHAR(36) — NOT NULL
- is_used — BOOLEAN — NOT NULL
- used_at — DATETIME
coupon_template
- id — CHAR(36) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- discount_type — ENUM('AMOUNT','PERCENT') — NOT NULL
- discount_value — INT — NOT NULL
- min_order_price — INT — NOT NULL
- max_discount — INT
- valid_from — DATE — NOT NULL
- valid_until — DATE — NOT NULL
district_code
- id — CHAR(36) — Primary key — NOT NULL
- city_id — CHAR(36) — NOT NULL
- district_name — VARCHAR(255) — NOT NULL
favorites
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — NOT NULL
- restaurant_id — CHAR(36) — NOT NULL
monthly_charge
- id — CHAR(36) — Primary key — NOT NULL
- restaurant_id — CHAR(36) — NOT NULL
- charge_month — CHAR(7) — NOT NULL
- total_usage_cnt — INT — NOT NULL
- total_ad_cnt — INT — NOT NULL
- total_charge — INT — NOT NULL
- charge_per_reservation — INT — NOT NULL
- status — ENUM('PENDING','PAID','CANCELED') — NOT NULL
notice
- id — CHAR(36) — Primary key — NOT NULL
- restaurant_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — NOT NULL
- content — VARCHAR(255)
- created_at — DATETIME — NOT NULL
notification
- id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(255)
- message — VARCHAR(500)
- status — ENUM('pending','sent','failed','read') — NOT NULL
- created_at — DATETIME — NOT NULL
- sent_at — DATETIME
- read_at — DATETIME
notification_booking
- notification_id — CHAR(36)
- booking_id — CHAR(36) — NOT NULL
notification_delivery_log
- id — CHAR(36) — Primary key — NOT NULL
- notification_id — CHAR(36) — NOT NULL
- channel — ENUM('PUSH','SMS','EMAIL') — NOT NULL
- status — ENUM('SUCCESS','FAILED') — NOT NULL
- fail_reason — VARCHAR(255)
- created_at — DATETIME — NOT NULL
notification_review
- notification_id — CHAR(36)
- review_id — CHAR(36) — NOT NULL
- id (id2) — CHAR(36) — Foreign key → user.id — NOT NULL
reservation_detail
- booking_id — CHAR(36) — Primary key — NOT NULL
- timeslot_instance_id — CHAR(36) — NOT NULL
- usage_minutes — INT
restaurant
- id — CHAR(36) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- city_id — CHAR(36) — NOT NULL
- district_id — CHAR(36)
- address — VARCHAR(255)
- phone — VARCHAR(20)
- supports_reservation — BOOLEAN — NOT NULL
- supports_waiting — BOOLEAN — NOT NULL
- avg_rating — DECIMAL(3,2) — NOT NULL
- review_count — INT — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- deleted_at — DATETIME
- created_at — DATETIME — NOT NULL
restaurant_keyword
- id — CHAR(36) — Primary key — NOT NULL
- keyword — VARCHAR(255) — NOT NULL
restaurant_keyword_map
- id — CHAR(36) — Primary key — NOT NULL
- restaurant_id — CHAR(36) — NOT NULL
- keyword_id — CHAR(36) — NOT NULL
restaurant_menu
- id — CHAR(36) — Primary key — NOT NULL
- restaurant_id — CHAR(36) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — INT — NOT NULL
- description — VARCHAR(255)
- image_url — VARCHAR(255)
- sort_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- deleted_at — DATETIME
restaurant_menu_option
- id — CHAR(36) — Primary key — NOT NULL
- option_group_id — CHAR(36) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — INT — NOT NULL
restaurant_menu_option_group
- id — CHAR(36) — Primary key — NOT NULL
- menu_id — CHAR(36) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- is_required — BOOLEAN — NOT NULL
- max_select — INT — NOT NULL
restaurant_picture
- id — CHAR(36) — Primary key — NOT NULL
- restaurant_id — CHAR(36) — NOT NULL
- picture_url — VARCHAR(255) — NOT NULL
restaurant_room
- id — CHAR(36) — Primary key — NOT NULL
- restaurant_id — CHAR(36) — NOT NULL
- name — VARCHAR(255)
- capacity — INT — NOT NULL
- room_type — VARCHAR(50)
- is_active — BOOLEAN — NOT NULL
- description — VARCHAR(255)
restaurant_timeslot_rule
- id — CHAR(36) — Primary key — NOT NULL
- restaurant_id — CHAR(36) — NOT NULL
- day_of_week — TINYINT — NOT NULL
- open_time — TIME — NOT NULL
- close_time — TIME — NOT NULL
- slot_interval — INT — NOT NULL
- usage_time — INT — NOT NULL
- team_capacity — INT — NOT NULL
- is_holiday — BOOLEAN — NOT NULL
- allow_waiting — BOOLEAN — NOT NULL
restaurant_user_role
- id — CHAR(36) — Primary key — NOT NULL
- restaurant_id — CHAR(36) — NOT NULL
- user_id — CHAR(36) — NOT NULL
- role — ENUM('OWNER','MANAGER','STAFF') — NOT NULL
- created_at — DATETIME — NOT NULL
review
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — NOT NULL
- booking_id — CHAR(36) — NOT NULL
- rating — TINYINT — NOT NULL
- content — VARCHAR(500)
- embedding_vector — VARCHAR(255)
- created_at — DATETIME — NOT NULL
review_like
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — NOT NULL
- review_id — CHAR(36) — NOT NULL
review_picture
- id — CHAR(36) — Primary key — NOT NULL
- review_id — CHAR(36) — NOT NULL
- picture_url — VARCHAR(255) — NOT NULL
timeslot_instance
- id — CHAR(36) — Primary key — NOT NULL
- rule_id — CHAR(36) — NOT NULL
- date — DATE — NOT NULL
- start_time — TIME — NOT NULL
- team_capacity — INT — NOT NULL
- reserved_team — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
user
- id — CHAR(36) — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100)
- phone — VARCHAR(20)
- role — ENUM('NORMAL','RESTAURANT_ADMIN','PLATFORM_ADMIN')
- is_deleted — BOOLEAN — NOT NULL
- deleted_at — DATETIME
- created_at — DATETIME — NOT NULL
user_restaurant_ban
- id — CHAR(36) — Primary key — NOT NULL
- user_id — CHAR(36) — NOT NULL
- restaurant_id — CHAR(36) — NOT NULL
waiting_detail
- booking_id — CHAR(36) — Primary key — NOT NULL
- waiting_start_time — DATETIME — NOT NULL
- expected_start_time — DATETIME
- expected_waiting_minute — INT
- queue_order — INT