LetCode

Tables (4)

StudyGroup (Untitled2)

  • groupId (Key) — Integer — Primary key — NOT NULL
  • postId (Key2) — Integer — Foreign key → StudyPost.post_id — NOT NULL
  • userId (Key22) — Integer — Foreign key → StudyPost.user_id — NOT NULL

StudyGroupMember (Untitled4)

  • member_id (Key) — Integer — Primary key — NOT NULL
  • user_id (Key2) — Integer — Foreign key → User.user_id — NOT NULL
  • group_id (Key3) — Integer — Foreign key → StudyGroup.groupId — NOT NULL

StudyPost (Untitled)

  • post_id (Key) — Integer — Primary key — NOT NULL
  • user_id (Key2) — Integer — Foreign key → User.user_id — NOT NULL
  • title (Field) — varchar
  • stack (Field2) — varchar
  • userName (Field3) — varchar
  • description (Field4) — varchar
  • max_num (Field5)

User (Untitled3)

  • user_id (Key) — Integer — Primary key — NOT NULL
  • user_name (Field) — varchar
  • id (Field2) — varchar
  • password (Field3) — varchar
  • email (Field4) — varchar