KTB5_Gianna_Week5

Tables (4)

Comment (comments)

  • commentId (id) — BIGINT — Primary key — NOT NULL — UNSIGNED, AUTO_INCREMENT
  • 게시글 ID (postId) — BIGINT — Foreign key → Post.postId — NOT NULL — UNSIGNED
  • 사용자 ID (userId) — INT — Foreign key → User.사용자 ID — NOT NULL — UNSIGNED
  • content — VARCHAR(200) — NOT NULL
  • created_at (createdAt) — DATETIME — NOT NULL
  • Field (updatedAt) — DATETIME — DEFAULT CURRENT_TIMESTAMP, default null
  • Field (deletedAt) — DATETIME — default - null

Post (posts)

  • postId (id) — BIGINT — Primary key — NOT NULL — UNSIGNED, AUTO_INCREMENT
  • userId — INT — Foreign key → User.사용자 ID — NOT NULL — UNSIGNED
  • created_at (createdAt) — DATETIME — NOT NULL — DEFAULT CURRENT_TIMESTAMP
  • title — VARCHAR(20) — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • file (postFile) — VARCHAR(255)
  • Field (updatedAt) — DATETIME — DEFAULT CURRENT_TIMESTAMP, default null
  • Field (deletedAt) — DATETIME — default.- null

Untitled (deletedUsers)

  • 사용자 ID (id) — INT — Foreign key → User.사용자 ID — NOT NULL — UNSIGNED, AUTO_INCREMENT
  • Field (email) — VARCHAR(255) — NOT NULL — UNIQUE
  • Field (nickname) — VARCHAR(10) — NOT NULL — UNIQUE

User (users)

  • 사용자 ID (id) — INT — Primary key — NOT NULL — UNSIGNED, AUTO_INCREMENT
  • nickname — VARCHAR(10) — NOT NULL — UNIQUE
  • email — VARCHAR(255) — NOT NULL — UNIQUE
  • password — VARCHAR(255) — NOT NULL
  • profilePicture — VARCHAR(255) — NOT NULL
  • deletedAt — DATETIME — default - null