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