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