게시판 erd

테이블 (3)

comments

  • commentId (Key) — long — 기본 키 — NOT NULL
  • commentContent (Field) — varchar
  • commentRecommend (Field2) — int
  • commentCreateAt (Field3) — timestamp
  • comentUpdateAt (Field4) — timestamp
  • developer (Field5) — varchar
  • userId (PK) — long — 외래 키 → users.userId — NOT NULL
  • postingId (Key2) — long — 외래 키 → postings.postingId — NOT NULL

postings (writings)

  • postingId (Key) — long — 기본 키 — NOT NULL
  • postingTitle (Field) — varchar
  • postingContent (Field2) — varchar
  • postingRecommend (Field3) — int
  • boardName (Field5) — varchar
  • postingCreateAt (Field4) — timestamp
  • postingUpdateAt (Field6) — timestamp
  • developer (Field7) — varchar
  • userId (PK) — long — 외래 키 → users.userId — NOT NULL

users

  • userId (PK) — long — 기본 키 — NOT NULL
  • userPassword (Field) — varchar
  • userNickName (Field3) — varchar
  • userPhoneNum (Field4) — varchar
  • userCreateAt (Field5) — Timestamp
  • userUpdateAt (Field6) — TimeStamp
  • developer (Field2) — varchar
  • userEmail (Field7) — varchar