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