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