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