PeoPool

Tables (5)

Enrollment (enrollment)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • team_id — bigint — Foreign key → Team.id — NOT NULL
  • enrollment_status — enum('PENDING', 'APPROVED', 'REJECTED')

Team (team)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255)
  • owner_id — bigint — Foreign key → member.id — NOT NULL

member

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • user_customid — varchar(255) — NOT NULL
  • user_email — varchar(255) — NOT NULL
  • user_name — varchar(255) — NOT NULL
  • user_password — varchar(255) — NOT NULL
  • user_profile_img — varchar(255)
  • user_role — enum('ROLE_ADMIN','ROLE_USER') — NOT NULL
  • user_nickname — varchar(255) — NOT NULL

post

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • content — varchar(255) — NOT NULL
  • maximum_people — int
  • recruitment_end_date — datetime(6)
  • post_status — enum('RECRUITED','RECRUITING','STOPPED','UNDER_REVIEW') — NOT NULL
  • title — varchar(255) — NOT NULL
  • team_id — bigint — Foreign key → Team.id — NOT NULL

refresh_token

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • refresh_token — varchar(255)
  • member_id — bigint — Foreign key → member.id — NOT NULL