Study Recruitment Bulletin Board
Tables (3)
Application (Untitled3)
- application_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
- study_id (Key3) — int — Foreign key → Study.study_id — NOT NULL
- user_id (Key22) — int — Foreign key → Study.user_id — NOT NULL
- user_id (Field2) — int
- status (Field3) — varchar
- message (Field4) — string
Study (Untitled2)
- study_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — int — Foreign key → User.user_id — NOT NULL
- title (Field) — string
- description (Field2) — string
- category (Field3) — string
- region (Field4) — string
- maxMembers (Field5) — int
- membersCount (Field6) — int
- deadline (Field7) — string
- leader_id (Field8) — int
User (Untitled)
- user_id (Key) — int — Primary key — NOT NULL
- user_email (Field) — string
- user_password (Field2) — JWT
- user_name (Field3) — string