letty

Tables (9)

category

  • id — UUID
  • name — VARCHAR(100) — NOT NULL

comment

  • id — UUID
  • user_id — UUID
  • post_id — UUID
  • body — TEXT
  • likes — INTEGER
  • created_at — TIMESTAMP

comment_like

  • user_id — UUID
  • comment_id — UUID

follow

  • follower_id — UUID
  • following_id — UUID

post

  • id — UUID
  • serial_id — SERIAL
  • title — VARCHAR(255) — NOT NULL
  • body — TEXT
  • views — INTEGER
  • created_at — TIMESTAMP
  • user_id — UUID

post_bookmark

  • user_id — UUID
  • post_id — UUID
  • bookmarked_at — TIMESTAMP

post_category

  • post_id — UUID
  • category_id — UUID

post_like

  • user_id — UUID
  • post_id — UUID
  • liked_at — TIMESTAMP

user

  • id — UUID
  • username — VARCHAR(255) — NOT NULL
  • profile_image — VARCHAR(255)
  • introduce — VARCHAR(500)
  • created_at — TIMESTAMP
  • auth_method — VARCHAR(50)
  • phone_number — VARCHAR(20)
  • kakao_id — VARCHAR(255)
  • google_id — VARCHAR(255)
  • apple_id — VARCHAR(255)