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