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