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