chain

Tables (5)

Comment (댓글)

  • Key (회원 ID) — BIGINT — Foreign key → User.Key — NOT NULL
  • Key (게시물 ID) — BIGINT — Foreign key → Post.Key — NOT NULL
  • Field (내용) — VARCHAR(300) — NOT NULL
  • Field (시각) — DATETIME — NOT NULL

Favorite (즐겨찾기)

  • Key (회원 ID) — BIGINT — Foreign key → User.Key — NOT NULL
  • Key (게시물 ID) — BIGINT — Foreign key → Post.Key — NOT NULL

Like (좋아요)

  • Key (회원 ID) — BIGINT — Foreign key → User.Key — NOT NULL
  • Key (게시물 ID) — BIGINT — Foreign key → Post.Key — NOT NULL
  • Field (시각) — DATETIME — NOT NULL

Post (게시물)

  • Key (게시물 ID) — BIGINT — Primary key — NOT NULL
  • Key (회원 ID) — BIGINT — Foreign key → User.Key — NOT NULL
  • Field (카테고리) — VARCHAR(20)
  • Field (태그) — VARCHAR(20)
  • Field (제목) — VARCHAR(255) — NOT NULL
  • Field (내용) — VARCHAR(3000) — NOT NULL
  • Field (시각) — DATETIME — NOT NULL

User (사용자)

  • Key (회원 ID) — BIGINT — Primary key — NOT NULL
  • Field (사용자 이름) — VARCHAR(20) — NOT NULL
  • Field (이메일) — VARCHAR(320) — NOT NULL
  • Field (비밀번호) — VARCHAR(50) — NOT NULL