TIP-ZIP
Tables (8)
Attachment (첨부 파일)
- attachment_id (첨부파일 id) — int — Primary key — NOT NULL
- photo_url (사진 url) — varchar
- video_url (동영상 url) — varchar
- link_url (링크 url) — varchar
- post_id (게시물 id) — int — Foreign key → Post.post_id — NOT NULL
Follow (팔로우)
- follow_id (id) — int — Primary key — NOT NULL
- follower_id (팔로워 id) — int — Foreign key → User.user_id — NOT NULL
- followee_id (팔로잉 id) — int — Foreign key → User.user_id — NOT NULL
MainCategory (메인 카테고리)
- main_category_id (메인 카테고리 id) — int — Primary key — NOT NULL
- main_category_name (메인 카테고리명) — varchar
Post (게시물)
- post_id (게시물 id) — int — Primary key — NOT NULL
- title (제목) — varchar
- content (내용) — text
- created_at (생성일) — timestamp
- updated_at (수정일) — timestamp
- user_id (사용자 id) — int — Foreign key → User.user_id — NOT NULL
PostCategory (게시물-태그)
- post_id (게시물 id) — int — Foreign key → Post.post_id — NOT NULL
- tag_id (태그 id) — int — Foreign key → Tag.tag_id — NOT NULL
Scrap (스크랩)
- scrap_id (스크랩 id) — int — Primary key — NOT NULL
- user_id (사용자 id) — int — Foreign key → User.user_id — NOT NULL
- post_id (게시물 id) — int — Foreign key → Post.post_id — NOT NULL
Tag (태그/서브 카테고리)
- tag_id (태그 id) — int — Primary key — NOT NULL
- tag_name (태그명) — varchar
- main_category_id (메인 카테고리 id) — int — Foreign key → MainCategory.main_category_id — NOT NULL
User (사용자)
- user_id (사용자 id) — int — Primary key — NOT NULL
- username (사용자명) — varchar
- profile_image (프로필 이미지 url) — varchar
- has_badge (뱃지 유무) — boolean