Weddie

Tables (9)

dress_shop

  • location_id — INT — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • address — VARCHAR(255)
  • city — VARCHAR(255)
  • description — VARCHAR(255)
  • district — VARCHAR(255)
  • dress_shop_image — VARCHAR(255)
  • dress_shop_name — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(255)

makeup_studio

  • location_id — INT — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • address — VARCHAR(255)
  • city — VARCHAR(255)
  • district — VARCHAR(255)
  • makeup_studio_name — VARCHAR(255)

options

  • id — INT — Primary key — NOT NULL
  • dress_shop_id — INT — Foreign key → dress_shop.location_id
  • makeup_studio_id — INT — Foreign key → makeup_studio.location_id
  • price — INT
  • service_id — INT — NOT NULL
  • studio_id — INT — Foreign key → studio.location_id
  • wedding_hall_id — INT — Foreign key → wedding_hall.wedding_hall_id
  • description — VARCHAR(255)
  • option_name — VARCHAR(255)
  • service_type — ENUM('DRESS_SHOP', 'MAKEUP_STUDIO', 'SNAP', 'STUDIO', 'WEDDING_HALL') — NOT NULL
  • INDEX — `FKpyyji1miap2o6uq1dhs4cnmt1`
  • INDEX — `FKfuo7ejnqsqi77o1mjdk4u3atf`
  • INDEX — `FK3y1b67kt699vd7k6obebwl0r6`
  • INDEX — `FKmuh56deg4tdckv1uglly6hy2k`

reservation

  • reservation_id — INT — Primary key — NOT NULL
  • service_id — INT — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • created_at — DATETIME(6)
  • end_time — DATETIME(6) — NOT NULL
  • reservation_date — DATETIME(6) — NOT NULL
  • start_time — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6)
  • service_type — ENUM('DRESS_SHOP', 'MAKEUP_STUDIO', 'SNAP', 'STUDIO', 'WEDDING_HALL') — NOT NULL
  • status — ENUM('AVAILABLE', 'CONFIRMED', 'IN_PROGRESS') — NOT NULL
  • INDEX — `FKm4oimk0l1757o9pwavorj6ljg`

studio

  • location_id — INT — Primary key — NOT NULL
  • helper_cost — INT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • address — VARCHAR(255)
  • city — VARCHAR(255)
  • description — VARCHAR(255)
  • district — VARCHAR(255)
  • phone — VARCHAR(255)
  • studio_image — VARCHAR(255)
  • studio_name — VARCHAR(255) — NOT NULL

user

  • user_id — INT — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • department — VARCHAR(255)
  • login_id — VARCHAR(255)
  • name — VARCHAR(255)
  • password — VARCHAR(255)
  • position — VARCHAR(255)
  • token — VARCHAR(255)

user_detail

  • location_id — INT — Primary key — NOT NULL
  • age — INT
  • fiance_id — INT — Foreign key → user.user_id
  • total_spent — INT
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • created_at — DATETIME(6)
  • marriage_date — DATETIME(6)
  • updated_at — DATETIME(6)
  • address — VARCHAR(255)
  • city — VARCHAR(255)
  • district — VARCHAR(255)
  • gender — VARCHAR(255)
  • grade — VARCHAR(255)
  • mbti — VARCHAR(255)
  • phone — VARCHAR(255)
  • profile_image — VARCHAR(255)
  • INDEX — `FK7w3tc4s660cbfajrew08rjj08`

wedding_hall

  • wedding_hall_id — INT — Primary key — NOT NULL
  • adult_meal_price — INT
  • child_meal_price — INT
  • max_capacity — INT
  • max_seating — INT
  • min_guarantee — INT
  • production_fee — INT
  • student_meal_price — INT
  • wedding_duration — INT
  • wedding_hall_fee — INT
  • wedding_interval — INT
  • wedding_venue_id — INT — Foreign key → wedding_venue.location_id — NOT NULL
  • meal_genre — VARCHAR(255)
  • wedding_hall_name — VARCHAR(255)
  • hall_type — ENUM('CHAPEL', 'GENERAL', 'HOTEL', 'HOUSE', 'OUTDOOR') — NOT NULL
  • meal_type — ENUM('BUFFET', 'COURSE')
  • wedding_type — ENUM('SEPARATE', 'SIMULTANEOUS')
  • INDEX — `FKrpbvhfhmjdem7w818y5tgmf0r`

wedding_venue

  • location_id — INT — Primary key — NOT NULL
  • has_parking — BIT(1)
  • parking_capacity — INT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • address — VARCHAR(255)
  • city — VARCHAR(255)
  • district — VARCHAR(255)
  • phone — VARCHAR(255)
  • wedding_venue_name — VARCHAR(255) — NOT NULL