.
Tables (8)
COMMENT
- id — UUID — Primary key — NOT NULL
- user_id — UUID — NOT NULL
- comment — varchar(1000) — NOT NULL
- 포스트id (post_id) — UUID — Foreign key → POST.id — NOT NULL
- id (id2) — UUID — Foreign key → USER.id — NOT NULL
FOLLOW
- Key — Primary key — NOT NULL
- Field
HASHTAG
- id — UUID — Primary key — NOT NULL
- 태그이름 (tag_name) — varchar(50) — NOT NULL
LIKES
- id — UUID — Primary key — NOT NULL
- 게시물id (post_id) — UUID — Foreign key → POST.id — NOT NULL
- 유저id (user_id) — UUID — Foreign key → USER.id — NOT NULL
PHOTO
- id — UUID — Primary key — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- 게시물id (post_id) — UUID — Foreign key → POST.id — NOT NULL
POST
- id — UUID — Primary key — NOT NULL
- content — VARCHAR(1000)
- 포스트id (post_id) — UUID — Foreign key → USER.id — NOT NULL
POST_HASHTAG
- id — Primary key — NOT NULL
- 포스트id (post_id) — UUID — Foreign key → POST.id — NOT NULL
- 해시태그id (hashtag_id) — UUID — Foreign key → HASHTAG.id — NOT NULL
USER
- id — UUID — Primary key — NOT NULL
- email — varchar(50) — NOT NULL
- password — varchar(50) — NOT NULL