CampusCrew
Tables (8)
Comment (Untitled)
- comment_id — Primary key — NOT NULL
- project_id (Key) — Foreign key → Project.project_id — NOT NULL
- users_id (Key2) — Foreign key → Users.users_id — NOT NULL
- comment
- SUB_CommentCount (Field3)
Participated_users (Untitled2)
- participated_users_id (Key) — Primary key — NOT NULL
- users_id (Key2) — Foreign key → Users.users_id — NOT NULL
- project_id (Key3) — Foreign key → Project.project_id — NOT NULL
- recruit_id (Key4) — Foreign key → recruit.recruit_id — NOT NULL
- status (Field)
Project (Untitled3)
- project_id (Key) — Primary key — NOT NULL
- projectStatus (Field5)
- createdDateTime (Field)
- description (Field2)
- endDate (Field3)
- openChatURl (Field4)
- recruitmentDate (Field6)
- startWithDate (Field7)
- title (Field8)
Users (Untitled7)
- users_id (Key) — Primary key — NOT NULL
- age (Field)
- createDate (Field2)
- email (Field3)
- name (Field4)
- nickname (Field5)
- password (Field6)
- refreshtoken (Field7)
- role (Field8)
- selfintroduction (Field9)
- shortIntroduction (Field10)
mangePage (Untitled8)
- participated_users_id (Key) — Foreign key → Participated_users.participated_users_id — NOT NULL
- users_id (Key2) — Foreign key → Participated_users.users_id — NOT NULL
- project_id (Key3) — Foreign key → Participated_users.project_id — NOT NULL
- id (Key4) — Foreign key → Participated_users.recruit_id — NOT NULL
recruit (Untitled4)
- recruit_id (Key) — Primary key — NOT NULL
- project_id (Key2) — Foreign key → Project.project_id — NOT NULL
- currentRecruit (Field)
- detailField (Field2)
- maxRecruit (Field3)
reference (Untitled5)
- reference_id (Key) — Primary key — NOT NULL
- project_id (Key2) — Foreign key → Project.project_id — NOT NULL
- URL (Field)
subcomment (Untitled6)
- sub_comment_id (Key) — Primary key — NOT NULL
- comment_id — Foreign key → Comment.comment_id — NOT NULL
- project_id (Key2) — Foreign key → Comment.project_id — NOT NULL
- users_id (Key22) — Foreign key → Comment.users_id — NOT NULL
- users_id (Key3) — Foreign key → Users.users_id — NOT NULL
- subComment (Field)
- createTime (Field4)