루덴스
테이블 (10)
common_recommendations
- post_id — int8 — 기본 키 — NOT NULL
- calculated_at — timestamptz(6) — NOT NULL
- rank — int4 — NOT NULL
hearts
- user_id — int8 — 기본 키 — NOT NULL
- post_id — int8 — 기본 키 — NOT NULL
post_heart_counts
- post_id — int8 — 기본 키 — NOT NULL
- count — int8 — NOT NULL
post_view_counts
- post_id — int8 — 기본 키 — NOT NULL
- count — int8 — NOT NULL
posts
- id — int8 — 기본 키 — NOT NULL
- author_id — int8
- created_at — timestamptz(6) — NOT NULL
- deleted_at — timestamptz(6)
- description — varchar(2000)
- edited_at — timestamptz(6) — NOT NULL
- title — varchar(100) — NOT NULL
- image_key — varchar(40) — NOT NULL
recommendation_states
- user_id — int8 — 기본 키 — NOT NULL
- calculated_version — int8 — NOT NULL
- requested_version — int8 — NOT NULL
- last_calculated_at — timestamptz(6)
user_post_views
- user_id — int8 — 기본 키 — NOT NULL
- post_id — int8 — 기본 키 — NOT NULL
- last_viewed_at — timestamptz(6) — NOT NULL
- view_count — int8 — NOT NULL
user_recommendations
- user_id — int8 — 기본 키 — NOT NULL
- post_id — int8 — 기본 키 — NOT NULL
- calculated_at — timestamptz(6) — NOT NULL
- rank — int4 — NOT NULL
user_search_keywords
- user_id — int8 — 기본 키 — NOT NULL
- keyword — varchar(100) — 기본 키 — NOT NULL
- last_searched_at — timestamptz(6) — NOT NULL
- search_count — int8 — NOT NULL
users
- id — int8 — 기본 키 — NOT NULL
- created_at — timestamptz(6) — NOT NULL
- deleted_at — timestamptz(6)
- password — varchar(100)
- username — varchar(30) — NOT NULL