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