HUFS TeamFit ERD
Tables (7)
APPLICATION
- application_id — INT
- post_id — INT — Foreign key → TEAM_POST.post_id — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- message — TEXT
- status — VARCHAR(20)
- applied_at — DATETIME
PROFILE
- profile_id — INT
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- mbti — VARCHAR(10)
- interest — VARCHAR(100)
- preferred_role — VARCHAR(50)
- available_time — VARCHAR(100)
REVIEW
- review_id — INT
- team_id — INT — Foreign key → TEAM.team_id — NOT NULL
- reviewer_id — INT — Foreign key → USER.user_id — NOT NULL
- reviewee_id — INT — Foreign key → USER.user_id — NOT NULL
- score — INT
- comment — TEXT — EX
- created_at — DATETIME
TEAM
- team_id — INT
- post_id — INT — Foreign key → TEAM_POST.post_id — NOT NULL
- team_name — VARCHAR(100)
- created_at — DATETIME
TEAM_MEMBER
- team_member_id — INT
- team_id — INT — Foreign key → TEAM.team_id — NOT NULL
- user_id — INT — Foreign key → USER.user_id — NOT NULL
- role — VARCHAR(50)
- joined_at — DATETIME
TEAM_POST
- post_id — INT
- writer_id — INT — Foreign key → USER.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- subject_name — VARCHAR(100)
- description — TEXT
- required_role — VARCHAR(50)
- max_member — INT
- created_at — DATETIME
USER
- user_id — INT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- department — VARCHAR(100)
- student_no — VARCHAR(20)
- created_at — DATETIME