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