project1
테이블 (4)
Comment (Untitled4)
- commentId (Key) — BIGINT — 기본 키 — NOT NULL
- commentContent (Field) — TEXT — NOT NULL
- createTime (Field2) — TIMESTAMP — NOT NULL
- updatedTime (Field3) — TIMESTAMP — NOT NULL
- postId (Key2) — BIGINT — 외래 키 → Post.postId — NOT NULL
- userId (Key3) — BIGINT — 외래 키 → User.userId — NOT NULL
Post (Untitled2)
- postId (Key) — BIGINT — 기본 키 — NOT NULL
- title (Field) — VARCHAR(255) — NOT NULL
- postContent (Field2) — TEXT — NOT NULL
- productBrand (Field3) — VARCHAR(100) — NOT NULL
- productName (Field4) — VARCHAR(100) — NOT NULL
- rating (Field5) — INT — NOT NULL
- createdAt (Field6) — TIMESTAMP — NOT NULL
- updatedAt (Field7) — TIMESTAMP — NOT NULL
- deletedAt (Field8) — TIMESTAMP
- userId (Key2) — BIGINT — 외래 키 → User.userId — NOT NULL
- boardId (Key3) — BIGINT — 외래 키 → 게시판.boardId — NOT NULL
User (Untitled)
- userId (Key) — BIGINT — 기본 키 — NOT NULL
- userName (Field) — VARCHAR(30) — NOT NULL
- nickName (Field2) — VARCHAR(30) — NOT NULL
- email (Field3) — VARCHAR(100) — NOT NULL
- age (Field4) — INT
- gender (Field5) — ENUM — NOT NULL
- skinType (Field6) — ENUM — NOT NULL
- userStatus (Field7) — ENUM — NOT NULL
- profileImage (Field8) — VARCHAR(255)
- password (Field9) — VARCHAR(255) — NOT NULL
- joinDate (Field10) — DATETIME — NOT NULL
- lastLoginDate (Field11) — DATETIME — NOT NULL
게시판 (Board)
- boardId (Key) — BIGINT — 기본 키 — NOT NULL
- boardName — VARCHAR(30) — NOT NULL
- orderNum — INT — NOT NULL