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)