UMC_밋픽_코리_v2
테이블 (13)
categories
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- description — TEXT
- is_active — BOOLEAN — NOT NULL
colleges
- id — BIGINT — 기본 키 — NOT NULL
- school_id — BIGINT — 외래 키 → schools.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
departments
- id — BIGINT — 기본 키 — NOT NULL
- college_id — BIGINT — 외래 키 → colleges.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
hobbies
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- category — VARCHAR(30)
- is_active — BOOLEAN — NOT NULL
matching
- id — BIGINT — 기본 키 — NOT NULL
- requester_id — BIGINT — 외래 키 → users.id — NOT NULL
- receiver_id — BIGINT — 외래 키 → users.id — NOT NULL
- category_id — BIGINT — 외래 키 → categories.id — NOT NULL
- status — ENUM('PENDING','ACCEPTED','REJECTED','COMPLETED') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
menus
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- category — VARCHAR(30) — NOT NULL
- is_active — BOOLEAN — NOT NULL
reviews
- id — BIGINT — 기본 키 — NOT NULL
- writer_id — BIGINT — 외래 키 → users.id — NOT NULL
- matching_id — BIGINT — 외래 키 → matching.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
schools
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email_domain — VARCHAR(100) — NOT NULL
user_agreements
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- agreement_type — VARCHAR(50) — NOT NULL
- version — VARCHAR(20) — NOT NULL
- agreed_at — TIMESTAMP — NOT NULL
user_departments
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- department_id — BIGINT — 외래 키 → departments.id — NOT NULL
- major_type — ENUM('MAIN','SECOND') — NOT NULL
user_hobbies
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- hobby_id — BIGINT — 외래 키 → hobbies.id — NOT NULL
user_preferences
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- preferred_gender — ENUM('M','F','ANY') — NOT NULL
- preferred_major — VARCHAR(100)
- preferred_year — ENUM('SAME','SENIOR','JUNIOR','ANY') — NOT NULL
- min_age — INT
- max_age — INT
- mbti_preference — VARCHAR(4)
- day_of_week — ENUM('MON','TUE','WED','THU','FRI') — NOT NULL
- meal_time — ENUM('LUNCH','DINNER') — NOT NULL
users
- id — BIGINT — 기본 키 — NOT NULL
- kakao_id — BIGINT — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(255)
- email — VARCHAR(100)
- gender — ENUM('M','F') — NOT NULL
- birth_date — DATE — NOT NULL
- student_id — VARCHAR(20) — NOT NULL
- mbti — VARCHAR(4)
- contact_kakao — VARCHAR(50)
- contact_openchat — VARCHAR(255)
- contact_phone — VARCHAR(20)
- created_at — TIMESTAMP — NOT NULL