inssider - base

Tables (11)

accounts

  • id — bigint — Primary key — NOT NULL
  • email — varchar(255)
  • password — varchar(255)
  • provider_user_id — varchar(255)
  • account_type — varchar(255)
  • role — varchar(255)
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6)
  • deleted_at — timestamp(6)
  • is_deleted — boolean — NOT NULL

authorization_codes

  • id — varchar(36) — Primary key — NOT NULL
  • email — varchar(255)
  • created_at — timestamp(6)
  • expired_at — timestamp(6)

categories

  • id — bigint — Primary key — NOT NULL
  • type — varchar(255) — NOT NULL

comments

  • id — bigint — Primary key — NOT NULL
  • content — varchar(255)
  • post_id — bigint — NOT NULL
  • parent_comment_id — bigint
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • deleted_at — timestamp(6)
  • is_deleted — boolean — NOT NULL
  • id2 — bigint — Foreign key → accounts.id — NOT NULL

email_verification_codes

  • email — varchar(255) — Primary key — NOT NULL
  • code — varchar(255) — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • expired_at — timestamp(6)

likes

  • Key — bigint — Primary key — NOT NULL
  • target_id — bigint
  • target_type — varchar(255) — NOT NULL
  • created_at — timestamp(6)
  • id2 — bigint — Foreign key → accounts.id — NOT NULL

post_tags

  • id — bigint — Primary key — NOT NULL
  • id2 — bigint — Foreign key → posts.id — NOT NULL
  • id3 — bigint — Foreign key → tags.id — NOT NULL

posts

  • id — bigint — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — varchar(255)
  • media_url — TEXT — NOT NULL
  • media_upload_time — timestamp(6) — NOT NULL
  • created_at — timestamp(6)
  • updated_at — timestamp(6)
  • deleted_at — timestamp(6)
  • is_deleted — boolean — NOT NULL
  • id2 — bigint — Foreign key → accounts.id — NOT NULL
  • id3 — bigint — Foreign key → categories.id — NOT NULL

refresh_tokens

  • id1 — bigint — Foreign key → accounts.id — NOT NULL
  • token — varchar(1000)

tags

  • id — bigint — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • created_at — timestamp(6)

user_profiles

  • id2 — bigint — Foreign key → accounts.id — NOT NULL
  • nickname — varchar(255)
  • bio — varchar(255)
  • profile_url — varchar(255)
  • account_visible — boolean — NOT NULL
  • follower_visible — boolean — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6)
  • deleted_at — timestamp(6)
  • is_deleted — boolean — NOT NULL