pinstargram

Tables (5)

comments (댓글)

  • id (댓글아이디) — long — Primary key — NOT NULL
  • parent_id (답글아이디) — long — Primary key — NOT NULL
  • order_no (순번) — long
  • created_at (생성날짜시간) — timestamp
  • updated_at (수정날짜시간) — timestamp
  • type (유형) — varchar(200)

hash_tag (태그)

  • id (Key) — long — Primary key — NOT NULL
  • name (Field2) — varchar(200)

media (게시물 이미지)

  • id (Key) — long — Primary key — NOT NULL
  • post_id (Key2) — long — Primary key — NOT NULL
  • post_url (Field) — varchar(200)
  • size (Field2) — long
  • type (Field3)

post (게시물)

  • id (post_id) — long — Primary key — NOT NULL
  • caption (본문) — varchar(2000)
  • is_reply_enabled (Field) — char(1)
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp
  • reply_count (게시물 댓글 수) — long

post_hashtag (포스트_해시태그 매핑 테이블)

  • post_id (Key) — long — Primary key — NOT NULL
  • hashtag_id (Key2) — long — Primary key — NOT NULL