루덴스

테이블 (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