ㅎㅇㄴㄹ

Tables (9)

block_relations

  • id — bigint
  • blocker_id — bigint
  • blocked_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL

follow_relations

  • id — bigint
  • follower_id — bigint — NOT NULL
  • following_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL

permissions

  • id — bigint
  • name — varchar(100) — NOT NULL
  • created_at — timestamp — NOT NULL

posts

  • id — bigint
  • user_id — bigint — NOT NULL
  • content — text
  • created_at — timestamp — NOT NULL

privacy_policies

  • id — bigint
  • post_id — bigint — NOT NULL
  • visibility — varchar(20) — NOT NULL
  • created_at — timestamp — NOT NULL

role_permissions

  • id — bigint
  • role_id — bigint — NOT NULL
  • permission_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL

roles

  • id — bigint
  • name — varchar(50) — NOT NULL
  • created_at — timestamp — NOT NULL

user_roles

  • id — bigint
  • user_id — bigint — NOT NULL
  • role_id — bigint — NOT NULL
  • created_at — timestamp — NOT NULL

users

  • id (Key) — Primary key — NOT NULL
  • id — bigint
  • username — varchar(50) — NOT NULL
  • created_at — timestamp — NOT NULL