ktb - community

Tables (7)

Comment (댓글)

  • id (댓글 id) — BIGINT — Primary key — NOT NULL
  • content (내용) — TEXT
  • created_at (생성시각) — DATETIME
  • updated_at (수정시각) — DATETIME
  • user_id (사용자 id) — BIGINT — Foreign key → User.id — NOT NULL
  • post_id (게시글 id) — BIGINT — Foreign key → Post.id — NOT NULL

Image (사진)

  • id (사진 id) — BIGINT — Primary key — NOT NULL
  • name (파일명) — varchar(255)
  • type (타입) — ENUM
  • jpg_path (jpg 경로) — varchr(255)
  • webp_path (webp 경로) — varchar(255)
  • post_id (게시글 id) — BIGINT — Foreign key → Post.id — NOT NULL
  • user_id (사용자 id) — BIGINT — Foreign key → User.id — NOT NULL

Post (게시글)

  • id (게시글 id) — BIGINT — Primary key — NOT NULL
  • title (제목) — varchar(26)
  • content (내용) — TEXT
  • post_image (게시글 사진 url) — varchar(255)
  • created_at (생성시각) — DATETIME
  • updated_at (수정시각) — DATETIME
  • user_id (사용자 id) — BIGINT — Foreign key → User.id — NOT NULL

PostLike (게시글 좋아요)

  • user_id (사용자 id) — BIGINT — Foreign key → User.id — NOT NULL
  • post_id (게시글 id) — BIGINT — Foreign key → Post.id — NOT NULL

PostStatus (게시글상태)

  • post_id (게시글 id) — BIGINT — Foreign key → Post.id — NOT NULL
  • view_count (조회수) — INT
  • like_count (좋아요 수) — INT
  • comment_count (댓글 수) — INT

User (회원)

  • id (사용자 id) — BIGINT — Primary key — NOT NULL
  • email (이메일) — varchar(100)
  • password (비밀번호) — varchar(20)
  • nickname (닉네임) — varchar(10)
  • profile_image (프로필사진 url) — varchar(255)
  • created_at (생성시각) — DATETIME
  • updated_at (수정시각) — DATETIME

UserToken (회원 토큰)

  • user_id (사용자 id) — BIGINT — Primary key — NOT NULL
  • token (리프레시 토큰) — TEXT
  • expires_at (만료 시간) — DATETIME