ssafy_SubPJT01

Tables (10)

AlertInfo (Untitled5)

  • AlertNo (알림번호) — PRIMARY — Primary key — NOT NULL
  • BoardNo (게시글번호) — NOT NULL — Foreign key → Board.BoardNo — NOT NULL
  • CommentNo (댓글번호) — NOT NULL — Foreign key → Comment.CommentNo — NOT NULL
  • Check (읽음,안읽음) — NOT NULL

Board (Untitled2)

  • BoardNo (게시글번호) — AutoIncremented — Primary key — NOT NULL
  • Nickname (작성자닉네임) — NOT NULL — Foreign key → UserInfo.Nickname
  • Title (제목) — NOT NULL
  • Content (내용) — NOT NULL
  • LikeCount (좋아요) — INT
  • ViewCount (조회수) — INT
  • CreatedTime (작성시간) — DATE
  • IsOpen (전체공개,기수공개여부) — NOT NULL
  • UseYn (삭제여부) — NOT NULL

Board_HashTag (Untitled10)

  • BoardNo (게시글번호) — NOT NULL — Foreign key → Board.BoardNo — NOT NULL
  • Nickname (작성자닉네임) — NOT NULL — Foreign key → Board.Nickname
  • TagNo (태그번호) — NOT NULL — Foreign key → HashTag.TagNo — NOT NULL

Chat (Untitled9)

  • ChatNo (채팅번호) — PRIMARY — Primary key — NOT NULL
  • Nickname (닉네임) — NOT NULL — Foreign key → UserInfo.Nickname
  • email (이메일) — NOT NULL — Foreign key → UserInfo.email
  • CreatedTime (작성시간) — DATE
  • Content (내용) — NOT NULL

Comment (Untitled4)

  • CommentNo (댓글번호) — AutoIncremented — Primary key — NOT NULL
  • BoardNo (게시글번호) — NOT NULL — Foreign key → Board.BoardNo — NOT NULL
  • Nickname (작성자닉네임) — NOT NULL — Foreign key → Board.Nickname
  • Content (내용) — NOT NULL
  • CreatedTime (작성시간) — DATE
  • UseYn (삭제여부) — NOT NULL

Favorites (Untitled6)

  • BoardNo (게시글번호) — NOT NULL — Foreign key → Board.BoardNo — NOT NULL
  • Nickname (닉네임) — NOT NULL — Foreign key → UserInfo.Nickname

HashTag (Untitled7)

  • TagNo (태그번호) — AutoIncrementd — Primary key — NOT NULL
  • HashTagName (해시태그명) — NOT NULL
  • UseYn (사용여부) — NOT NULL

Message (Untitled8)

  • MessageNo (메시지번호) — PRIMARY — Primary key — NOT NULL
  • Nickname (닉네임) — NOT NULL — Foreign key → UserInfo.Nickname
  • Date (발신시간) — DATE
  • Send (받는사람) — NOT NULL
  • Content (내용) — NOT NULL

UserInfo (Untitled3)

  • Nickname (닉네임) — PRIMARY — Primary key
  • email (이메일) — NOT NULL — Foreign key → UserLogin.email
  • JoinDate (가입일자) — Date
  • Generation (기수) — NOT NULL
  • CertiImage (합격증이미지) — longblob
  • CertiYn (인증여부) — NOT NULL
  • ProfileImage (프로필이미지) — longblob
  • UseYn (삭제여부) — NOT NULL

UserLogin (Untitled)

  • email (이메일) — PRIMARY — Primary key
  • password (패스워드) — NOT NULL