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)