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