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