wevi(new)
Tables (22)
Untitled
audio_analysis
- record_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → customers.user_id — NOT NULL
- schedule_id — INT — Foreign key → consultations.schedule_id — NOT NULL
- original_file_url — VARCHAR(255) — NOT NULL
- converted_file_url — VARCHAR(255)
- analysis_result — VARCHAR(255)
categories
- category_id — Int — Primary key — NOT NULL — AUTO_INCREMENT UNIQUE NOTNULL
- name — VARCHAR(20) — NOT NULL
consultations
- schedule_id — INT — Foreign key → schedules.schedule_id — NOT NULL
- request — VARCHAR(255)
contracts
- schedule_id — INT — Foreign key → schedules.schedule_id — NOT NULL
- price — INT — NOT NULL
- contract_date — DATETIME
- detail — VARCHAR(255)
coupleRequests
- couple_request_id — INT — Primary key — NOT NULL
- sender_id — Integer — Foreign key → customers.user_id — NOT NULL
- receiver_id — Integer — Foreign key → customers.user_id — NOT NULL
- status — 'ACCEPTED'
- REJECTED — NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
customers
- user_id — INT — Foreign key → users.user_id — NOT NULL
- nickname — VARCHAR(255) — NOT NULL — UNIQUE
- name — VARCHAR(255)
- phone — VARCHAR(255) — NOT NULL
- zoncode — VARCHAR(255)
- auto_road_address — VARCHAR(255)
- address_detail — VARCHAR(255)
- spouse_id — Integer — Foreign key → customers.user_id — NOT NULL
do
- do_id — INT — Primary key — NOT NULL
- do_name — VARCHAR(45)
hashtags
- hashtag_id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
images
- image_id — INT — Primary key — NOT NULL
- vendor_id — Integer — Foreign key → vendors.user_id — NOT NULL
- review_id — INT — Foreign key → reviews.review_id — NOT NULL
- image_type — ENUM('DETAIL', 'PANORAMA', 'MAGAZINE', 'REVIEW')
- image_url — VARCHAR(255)
- order_index — Integer
- created_at — TIMESTAMP
middle_process_steps
- middle_process_step_id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- category_id — INT — Foreign key → categories.category_id — NOT NULL — AUTO_INCREMENT UNIQUE NOTNULL
- is_visit — Boolean
middle_processes
- schedule_id — INT — Foreign key → schedules.schedule_id — NOT NULL
- status — ENUM('PENDING', 'IN_PROGRESS', 'COMPLETED') — NOT NULL
- detail — VARCHAR(255)
- middle_process_step_id — INT — Foreign key → middle_process_steps.middle_process_step_id — NOT NULL
- contract_id — INT — Foreign key → contracts.schedule_id — NOT NULL
- complete_date_time — TIMESTAMP
notifications
- notification_id — INT — Primary key — NOT NULL
- user_id — Integer — Foreign key → users.user_id — NOT NULL
- message — TEXT — NOT NULL
- is_read — BOOLEAN
- type — 'ENUM( "COUPLE_REQUEST_SENT", "COUPLE_REQUEST_RESPONSE", "CONSULTATION_REGISTERED", "CONTRACT_REGISTERED", " SCHEDULE_REMINDER") — NOT NULL
other_schedules
- schedule_id — INT — Foreign key → schedules.schedule_id — NOT NULL
- detail — VARCHAR(255)
recommend
- recommend_id — INT — Primary key — NOT NULL
- customer_id — INT — Foreign key → customers.user_id — NOT NULL
- wedding_hall_vendor_id — Integer — Foreign key → vendors.user_id — NOT NULL
- studio_vendor — Integer — Foreign key → vendors.user_id — NOT NULL
- dress_vendor_id — Integer — Foreign key → vendors.user_id — NOT NULL
- makeup_vendor_id — Integer — Foreign key → vendors.user_id — NOT NULL
reviews
- review_id — INT — Primary key — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- customer_id — INT — Foreign key → customers.user_id — NOT NULL
- vendor_id — INT — Foreign key → vendors.user_id — NOT NULL
schedules
- schedule_id — INT — Primary key — NOT NULL
- start_date_time — TIMESTAMP
- end_date_time — TIMESTAMP
- title — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- vendor_id — Integer — Foreign key → vendors.user_id — NOT NULL
- customer_id — Integer — Foreign key → customers.user_id — NOT NULL
- category_id — Int — Foreign key → categories.category_id — NOT NULL — AUTO_INCREMENT UNIQUE NOTNULL
search_histories
- search_history_id — INT — Primary key — NOT NULL
- customer_id — Integer — Foreign key → customers.user_id — NOT NULL
- keyword — VARCHAR(255) — NOT NULL
- searched_at — TIMESTAMP — NOT NULL
sigungus
- sigungu_id — INT — Primary key — NOT NULL
- sigungu_name — VARCHAR(45)
- do_region_id — INT — Foreign key → do.do_id — NOT NULL
users
- user_id — Integer — Primary key — NOT NULL
- email — VARCHAR(255)
- password — VARCHAR(255)
- auth_id — VARCHAR(255)
- auth_provider — ENUM('KAKAO')
- status — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- dtype — "customer"
- fcmToken — VARCHAR(255)
vendor_hashtag
- vendor_hashtag_id — INT — Primary key — NOT NULL
- hashtag_id — INT — Foreign key → hashtags.hashtag_id — NOT NULL
- vendor_id — Integer — Foreign key → vendors.user_id — NOT NULL
vendors
- user_id — Integer — Foreign key → users.user_id — NOT NULL
- owner_name — VARCHAR(255)
- owner_phone — VARCHAR(255)
- name — VARCHAR(255)
- zonecode — VARCHAR(255)
- do_code — INT — Foreign key → do.do_id — NOT NULL
- sigungu_code — INT — Foreign key → sigungus.sigungu_id — NOT NULL
- auto_road_address — VARCHAR(255)
- address_detail — VARCHAR(255) — NOT NULL
- phone — VARCHAR(255) — NOT NULL
- registration_number — VARCHAR(255) — NOT NULL
- category_id — INT — Foreign key → categories.category_id — NOT NULL — AUTO_INCREMENT UNIQUE NOTNULL
- businesshour — TIMESTAMP
- homepage — VARCHAR(255)
- price — VARCHAR(500)
- details — VARCHAR(500)
- is_indoor — Boolean
- min_price — INT
- subway — VARCHAR(255)
- parkinglot — VARCHAR(255)