qwer

테이블 (7)

calendar 페이지 정보 (Untitled6)

  • teamName — NOT NULL — pk
  • date — NOT NULL
  • comment — NOT NULL

notice 페이지 정보 (Untitled5)

  • teamName — NOT NULL — pk
  • notice — NOT NULL
  • noticeDate — NOT NULL

게시판 정보 (Untitled2)

  • boardNo — int — NOT NULL — pk
  • writer — varchar — NOT NULL — 작성자 정보 userid
  • teamName — varchar — NOT NULL
  • boardTitle — varchar — NOT NULL
  • projectSubject — varchar — NOT NULL
  • projectIntroduce — varchar — NOT NULL
  • recruitDeadline — varchar — NOT NULL
  • projectDate — varchar — NOT NULL
  • region — varchar — NOT NULL
  • recruitPosition — varchar — NOT NULL
  • projectProcess — varchar — NOT NULL
  • skills — varchar — NOT NULL
  • comment — varchar
  • commentWriter — varchar

사용자 (Untitled)

  • userId — varchar — NOT NULL — pk
  • userPw — varchar — NOT NULL
  • userName — varchar — NOT NULL
  • email — varchar
  • phoneNumber — int
  • introduce — varchar
  • skills — varchar

팀원 정보 (Untitled7)

  • teamName — NOT NULL — pk
  • teamLeader — boolean — NOT NULL — 팀장은 true
  • teamMember — NOT NULL

활동 팀 정보? (미정)

  • teamName — pk

활동 팀 테이블 (Untitled4)

  • userId — NOT NULL
  • teamName — NOT NULL