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