ktb_community
Tables (8)
Comment (댓글)
- id (Key) — BIGINT — Primary key — NOT NULL
- content (Field3) — VARCHAR(500) — NOT NULL
- like_count (Field4) — INT — NOT NULL
- created_at (Field5) — TIMESTAMP — NOT NULL
- updated_at (Field6) — TIMESTAMP — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
- post_id (Key3) — BIGINT — Foreign key → Post.id — NOT NULL
- is_deleted (Field) — TINYINT — NOT NULL
- deleted_at (Field2) — TIMESTAMP — NOT NULL
CommentLike (댓글 좋아요)
- like_id (Key2) — BIGiNT — Foreign key → Like.id — NOT NULL
- comment_id (Key) — BIGINT — Foreign key → Comment.id — NOT NULL
Credential (Untitled)
- user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
- password (Field) — VARCHAR(255) — NOT NULL
- hash_type (Field2) — VARCHAR(20) — NOT NULL
- updated_at (Field3) — TIMESTAMP — NOT NULL
Like (좋아요)
- id (Key) — BIGiNT — Primary key — NOT NULL
- created_at (Field2) — TIMESTAMP — NOT NULL
- updated_at (Field3) — TIMESTAMP — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
- is_deleted (Field) — TINYINT — NOT NULL
- deleted_at (Field4) — TIMESTAMP — NOT NULL
Post (게시글)
- id (Key) — BIGINT — Primary key — NOT NULL
- title (Field2) — VARCHAR(100) — NOT NULL
- content (Field3) — TEXT — NOT NULL
- like_count (Field5) — INT — NOT NULL
- comment_count (Field6) — INT — NOT NULL
- view_count (Field7) — INT — NOT NULL
- post_type (Field8) — VARCHAR — NOT NULL
- created_at (Field9) — TIMESTAMP — NOT NULL
- updated_at (Field10) — TIMESTAMP — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
- is_deleted (Field) — TINYINT — NOT NULL
- deleted_at (Field4) — TIMESTAMP — NOT NULL
PostImage (게시글 이미지)
- id (Key2) — BIGINT — Primary key — NOT NULL
- post_id (Key) — BIGINT — Foreign key → Post.id — NOT NULL
- post_image_key (Field) — VARCHAR(255) — NOT NULL
- created_at (Field2) — TIMESTAMP — NOT NULL
- order_index (Field3) — INT — NOT NULL
- is_deleted (Field4) — TINYINT — NOT NULL
- deleted_at (Field5) — TIMESTAMP — NOT NULL
PostLike (게시글 좋아요)
- like_id (Key) — BIGiNT — Foreign key → Like.id — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → Post.id — NOT NULL
User (사용자)
- id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(255) — NOT NULL
- nickname (Field2) — VARCHAR(50) — NOT NULL
- profile_image_key (Field4) — VARCHAR(255)
- role (Field5) — VARCHAR(20) — NOT NULL
- created_at (Field6) — TIMESTAMP — NOT NULL
- updated_at (Field7) — TIMESTAMP — NOT NULL
- is_deleted (Field3) — TINYINT — NOT NULL
- deleted_at (Field8) — TIMESTAMP — NOT NULL