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