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