사전스터디(1)

테이블 (5)

Comment

  • commentID — BIGINT — 기본 키 — NOT NULL
  • MemberID — VARCHAR(255) — NOT NULL
  • postID — BIGINT — NOT NULL
  • content — TEXT
  • createdAt — DATETIME — NOT NULL
  • deleted — BOOLEAN — NOT NULL

Image

  • ImageID — BIGINT — 기본 키 — NOT NULL
  • postID — BIGINT — NOT NULL
  • imageURL — VARCHAR(255) — NOT NULL

Like

  • LikeID — BIGINT — 기본 키 — NOT NULL
  • MemberID — VARCHAR(255) — NOT NULL
  • postID — BIGINT — NOT NULL

Member

  • MemberID — VARCHAR(255) — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME
  • is_deleted — BOOLEAN — NOT NULL

Post

  • postID — BIGINT — 기본 키 — NOT NULL
  • MemberID — VARCHAR(255) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • createdAt — DATETIME — NOT NULL
  • updatedAt — DATETIME
  • count_likes — INT — NOT NULL
  • count_comments — INT — NOT NULL