kbt

Tables (6)

comments

  • id — BIGINT UNSIGNED — Primary key — NOT NULL
  • external_id — CHAR(36) — NOT NULL
  • post_id — BIGINT UNSIGNED — Foreign key → posts.id — NOT NULL
  • user_id — BIGINT UNSIGNED — Foreign key → users.id — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • deleted_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME

post_images

  • image_id — BIGINT UNSIGNED — Primary key — NOT NULL
  • image_url — VARCHAR(2048) — NOT NULL
  • sequence — SMALLINT UNSIGNED — NOT NULL
  • created_at — DATETIME — NOT NULL
  • thumbail_image_url (thumbnail_image_url) — VARCHAR(2048) — NOT NULL

post_likes

  • id — BIGINT UNSIGNED — Primary key — NOT NULL
  • user_id — BIGINT UNSIGNED — Foreign key → users.id — NOT NULL
  • post_id — BIGINT UNSIGNED — Foreign key → posts.id — NOT NULL
  • id (id2) — BIGINT UNSIGNED — Foreign key → posts.user_id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

post_stat

  • post_id — BIGINT UNSIGNED — Foreign key → posts.id — NOT NULL
  • id (id2) — BIGINT UNSIGNED — Foreign key → posts.user_id — NOT NULL
  • view_count — INT UNSIGNED — NOT NULL
  • comment_count — INT UNSIGNED — NOT NULL
  • like_count — INT UNSIGNED — NOT NULL

posts

  • id — BIGINT UNSIGNED — Primary key — NOT NULL
  • user_id — BIGINT UNSIGNED — Foreign key → users.id — NOT NULL
  • external_id — CHAR(36) — NOT NULL
  • title — VARCHAR(26) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME
  • deleted_at — DATETIME

users

  • id — BIGINT UNSIGNED — Primary key — NOT NULL
  • external_id — CHAR(36) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • profile_image_url — VARCHAR(1024) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME
  • deleted_at — DATETIME