게시판 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