DB프로젝트
테이블 (7)
Board
- boardId (Key) — Number — 기본 키 — NOT NULL
- userId — Number — 외래 키 → User.userId — NOT NULL
- title (Field) — varchar(40) — NOT NULL
- content (Field3) — varchar(1000) — NOT NULL
- link (Field6) — varchar(1000)
- boardWriter (Field2) — varchar(10) — NOT NULL
- viewCount (Field4) — Number — NOT NULL
- boardCreateTime (Field5) — Date — NOT NULL
Favorite
- favoriteId (Key) — Number — 기본 키 — NOT NULL
- userId — Number — 외래 키 → User.userId — NOT NULL
- boardId (Key2) — Number — 외래 키 → Board.boardId — NOT NULL
Follow
- userId — Number — 외래 키 → User.userId — NOT NULL
- followId (Field2) — Number — NOT NULL
Like
- LikeId (Key) — Number — 기본 키 — NOT NULL
- boardId (Key2) — Number — 외래 키 → Board.boardId — NOT NULL
- userId — Number — 외래 키 → User.userId — NOT NULL
Reply
- ReplyId (Key2) — Number — 기본 키 — NOT NULL
- reviewId (Key) — Number — 외래 키 → Review.reviewId — NOT NULL
- replyContent (Field) — varchar(1000) — NOT NULL
- replyWriter (Field2) — varchar(10) — NOT NULL
- replyCreateTime (Field3) — Date — NOT NULL
Review
- reviewId (Key) — Number — 기본 키 — NOT NULL
- boardId (Key2) — Number — 외래 키 → Board.boardId — NOT NULL
- reviewContent (Field) — varchar(1000) — NOT NULL
- reviewWriter (Field2) — varchar(10) — NOT NULL
- reviewCreateTime (Field3) — Date — NOT NULL
User
- userId — Number — 기본 키 — NOT NULL
- userEmail (Field) — varchar(40) — NOT NULL
- userPass (Field2) — varchar(40) — NOT NULL
- userName (Field3) — varchar(10) — NOT NULL