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