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)