Sidaeting

Tables (11)

Compatibility

  • compatibility_id — INT — Primary key
  • team_male_id (male_team_id) — INT — Foreign key → Meeting_Teams.team_id — NOT NULL
  • team_female_id (female_team_id) — INT — Foreign key → Meeting_Teams.team_id — NOT NULL
  • compatibility_score — INT

Compatibility_Priority

  • priority_id — INT — Primary key
  • compatibility_name — VARCHAR(255)
  • compatibility_weight — INT

Departsments (Departments)

  • department_id — INT — Primary key — NOT NULL
  • department_name — VARCHAR(255)
  • department_number — INT

Informations

  • infomation_id (information_id) — INT — Primary key — NOT NULL
  • team_id — INT — Foreign key → Meeting_Teams.team_id — NOT NULL
  • meeting_location — VARCHAR(255)
  • meeting_time — DATE
  • filter_info — VARCHAR(255)
  • distance_info — VARCHAR(255)
  • about_me — VARCHAR

Match

  • match_id — INT — Primary key
  • match_date — DATE
  • team_ male_id (male_team_id) — INT — Foreign key → Meeting_Teams.team_id — NOT NULL
  • team_female_id (female_team_id) — INT — Foreign key → Meeting_Teams.team_id — NOT NULL

Meeting_Teams

  • team_id — INT — Primary key — NOT NULL
  • season — INT
  • code — VARCHAR(255)

No_prefer_departments

  • user_id — INT — Foreign key → User.user_id
  • department_id — INT — Foreign key → Departsments.department_id — NOT NULL

Preferences

  • preference_id — INT — Primary key
  • team_id — INT — Foreign key → Meeting_Teams.team_id — NOT NULL
  • age_range_preference — VARCHAR
  • height_range_preference — VARCHAR
  • filter_condition — VARCHAR(255)
  • distance_condition — VARCHAR(255)

Report

  • report_id — INT — Primary key
  • user_id — INT — Foreign key → User.user_id
  • report_category (category) — VARCHAR(255)
  • report_text (text) — TEXT
  • admin_response — TEXT

User

  • user_id — INT — Primary key — NOT NULL
  • department_id — INT — Foreign key → Departsments.department_id — NOT NULL
  • 출생년 (birthYear) — INT
  • gender — VARCHAR(255)
  • phone_number — VARCHAR(255)
  • profile_picture — VARCHAR(255)
  • created_at — DATE
  • updated_at — DATE
  • 별명 (nickname) — VARCHAR
  • 이름 (name) — VARCHAR(255)

User_Teams

  • team_id — INT — Foreign key → Meeting_Teams.team_id — NOT NULL
  • user_id — INT — Foreign key → User.user_id
  • is_leader — BOOLEAN
  • type — VARCHAR