.

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