trivia-server

Tables (6)

coin_wallets (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (Key2) — bigint — Foreign key → users.id — NOT NULL
  • coin_wallets_id (Key22) — bigint — Foreign key → users.coin_wallets_id — NOT NULL
  • crown_wallets_id (Key3) — bigint — Foreign key → users.crown_wallets_id — NOT NULL
  • gem_wallets_id (Key4) — bigint — Foreign key → users.gem_wallets_id — NOT NULL
  • profiles_id (Key5) — bigint — Foreign key → users.profiles_id — NOT NULL
  • updated_at (Field) — timestampz
  • coin_balance (Field2) — bigint
  • event_coin_balance (Field3) — bigint

crown_wallets (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • crown_balance (Field) — bigint
  • event_crown_balance (Field2) — bigint
  • updated_at (Field3) — timestampz

gem_wallets (CopyOfUntitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • gem_balance (Field) — bigint
  • event_gem_balance (Field2) — bigint
  • updated_at (Field3) — timestampz

profiles (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • profile_index (Field) — int

user_currency_usage_histories (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Field) — bigint
  • currency (Field2) — varchar
  • amount (Field3) — bigint
  • type (Field5) — varchar
  • metadata (Field4) — jsonb
  • id (Key2) — bigint — Foreign key → users.id — NOT NULL
  • coin_wallets_id (Key22) — bigint — Foreign key → users.coin_wallets_id — NOT NULL
  • crown_wallets_id (Key3) — bigint — Foreign key → users.crown_wallets_id — NOT NULL
  • gem_wallets_id (Key4) — bigint — Foreign key → users.gem_wallets_id — NOT NULL
  • profiles_id (Key5) — bigint — Foreign key → users.profiles_id — NOT NULL
  • id (Key222) — bigint — Foreign key → users.id — NOT NULL
  • coin_wallets_id (Key2222) — bigint — Foreign key → users.coin_wallets_id — NOT NULL
  • crown_wallets_id (Key32) — bigint — Foreign key → users.crown_wallets_id — NOT NULL
  • gem_wallets_id (Key42) — bigint — Foreign key → users.gem_wallets_id — NOT NULL
  • profiles_id (Key52) — bigint — Foreign key → users.profiles_id — NOT NULL

users (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • coin_wallets_id (Key2) — bigint — Foreign key → coin_wallets.id — NOT NULL
  • crown_wallets_id (Key3) — bigint — Foreign key → crown_wallets.id — NOT NULL
  • gem_wallets_id (Key4) — bigint — Foreign key → gem_wallets.id — NOT NULL
  • profiles_id (Key5) — bigint — Foreign key → profiles.id — NOT NULL
  • id (Key22) — bigint — Foreign key → coin_wallets.id — NOT NULL
  • coin_wallets_id (Key222) — bigint — Foreign key → coin_wallets.coin_wallets_id — NOT NULL
  • crown_wallets_id (Key32) — bigint — Foreign key → coin_wallets.crown_wallets_id — NOT NULL
  • gem_wallets_id (Key42) — bigint — Foreign key → coin_wallets.gem_wallets_id — NOT NULL
  • profiles_id (Key52) — bigint — Foreign key → coin_wallets.profiles_id — NOT NULL
  • nickname (Field5) — varchar
  • created_at (Field6) — timestampz
  • deleted_at (Field7) — timestampz
  • is_deleted (Field8) — boolean
  • Field9