커뮤니티

테이블 (10)

Comment (Untitled4)

  • Key — 기본 키 — NOT NULL
  • Key2 — 기본 키 — NOT NULL
  • id (Field) — bigint
  • post_id (Field2) — bigint
  • author_id (Field3) — bigint
  • parent_id (Field4) — bigint
  • content (Field5) — text
  • is_deleted (Field6) — boolean
  • created_at (Field7) — DATETIME
  • updated_at (Field8) — DATETIME
  • Key (Key3) — 외래 키 → User.Key — NOT NULL

POST_IMAGE (Untitled3)

  • Key — 기본 키 — NOT NULL
  • id (Field) — bigint
  • post_id (Field2) — bigint
  • url (Field3) — varchar
  • sort_order (Field4) — bigint
  • uploaded_at (Field5) — DATETIME
  • Key (Key2) — 외래 키 → Post.Key — NOT NULL

POST_LIKE (Untitled5)

  • Key — 기본 키 — NOT NULL
  • post_id (Field) — bigint
  • user_id (Field2) — bigint
  • created_at (Field3) — DATETIME
  • Key (Key2) — 외래 키 → Post.Key — NOT NULL

Post (Untitled2)

  • Key — 기본 키 — NOT NULL
  • id (Field) — bigint
  • author_id (Field2) — bigint
  • title (Field3) — varchar
  • content (Field4) — longtext
  • views (Field5) — bigint
  • likes_count (Field6) — bigint
  • comments_count (Field7) — bigint
  • is_deleted (Field8) — boolean
  • created_at (Field9) — DATETIME
  • updated_at (Field10) — DATETIME
  • Key (Key2) — 외래 키 → User.Key — NOT NULL

User (Untitled)

  • Key — 기본 키 — NOT NULL
  • id (Field) — int
  • email (Field2) — varchar
  • password (Field3) — varchar
  • profile_image (Field4) — varchar
  • created_at (Field5) — DATETIME
  • updated_at (Field6) — DATETIME

comments

  • id — BIGINT — 기본 키 — NOT NULL
  • post_id — BIGINT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • parent_comment_id — BIGINT
  • content — TEXT — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • id (id2) — BIGINT — 외래 키 → users.id — NOT NULL

post_images

  • id — BIGINT — 기본 키 — NOT NULL
  • post_id — BIGINT — NOT NULL
  • url — VARCHAR(1024) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • id (id2) — BIGINT — 외래 키 → posts.id — NOT NULL
  • id (id22) — BIGINT — 외래 키 → posts.id — NOT NULL

post_likes

  • post_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 기본 키 — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • id (id2) — BIGINT — 외래 키 → posts.id — NOT NULL
  • id (id22) — BIGINT — 외래 키 → posts.id — NOT NULL

posts

  • id — BIGINT — 기본 키 — NOT NULL
  • id (id2) — BIGINT — 외래 키 → users.id — NOT NULL
  • author_id — BIGINT — NOT NULL
  • title — VARCHAR(26) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • views — INT — NOT NULL
  • likes_count — INT — NOT NULL
  • comments_count — INT — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(1024)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL