Likelion_Community

Tables (7)

comments

  • id — uuid — Primary key — NOT NULL
  • user_id — varchar — NOT NULL
  • visible — bool — NOT NULL
  • body — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp — NOT NULL
  • postIdId — uuid

dislike_table

  • id — uuid — Primary key — NOT NULL
  • user_id — varchar — NOT NULL
  • postIdId — uuid

like_table

  • id — uuid — Primary key — NOT NULL
  • user_id — varchar — NOT NULL
  • postIdId — uuid

postTags

  • id — uuid — Primary key — NOT NULL
  • postIdId — uuid
  • tagIdId — uuid

posts

  • id — uuid — Primary key — NOT NULL
  • parent_id — varchar
  • title — varchar — NOT NULL
  • body — text — NOT NULL
  • owner_user_id — varchar — NOT NULL
  • owner_user_dp_name — varchar — NOT NULL
  • view_count — int4 — NOT NULL
  • comment_count — int4 — NOT NULL
  • like_count — int4 — NOT NULL
  • dislike_count — int4 — NOT NULL
  • visible — bool — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

tag

  • id — uuid — Primary key — NOT NULL
  • tag_type — varchar — NOT NULL
  • name — varchar — NOT NULL

views

  • id — uuid — Primary key — NOT NULL
  • user_id — varchar — NOT NULL
  • postIdId — uuid