RecruitingMembers

Tables (3)

Recruit Post_detail (recruit_post_detail)

  • Recruit_d_id (recruit_d_id) — INT — Primary key — NOT NULL
  • Title (title) — VARCHAR
  • Date (date) — VARCHAR
  • Views (views) — VARCHAR
  • Content (content) — VARCHAR
  • Max_Applicants (max_applicants) — INT
  • Num_Applicants (num_applicants) — INT
  • Recruitment_End (recruitment_end) — BOOLEAN
  • Author (author) — VARCHAR

Recruit Post_simple (recruit_post_simple)

  • Recruit_s_id (recruit_s_id) — int — Primary key — NOT NULL
  • Recruit_d_id (recruit_d_id) — INT — Foreign key → Recruit Post_detail.Recruit_d_id — NOT NULL
  • Title (title) — VARCHAR
  • Views (views) — INT
  • Author (author) — VARCHAR

Team Participation (team_participation)

  • Parti_Id (parti_Id) — INT — Primary key — NOT NULL
  • Status (status) — BOOLEAN