PokeClip

Tables (6)

pairing_codes

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • code_hash — VARCHAR(64) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • used_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

pairing_exchange_attempts

  • id — BIGINT — Primary key — NOT NULL
  • client_ip_hash — VARCHAR(64) — NOT NULL
  • attempted_at — TIMESTAMP — NOT NULL

refresh_tokens

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • token_hash — VARCHAR(64) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • revoked_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

secrets

  • ref — VARCHAR(255) — Primary key — NOT NULL
  • ciphertext — BLOB — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

stream_keys

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • streamid_hash — VARCHAR(64) — NOT NULL
  • passphrase_ref — VARCHAR(255) — NOT NULL
  • revoked_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • google_sub — VARCHAR(255) — NOT NULL
  • email — VARCHAR(320) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • profile_image_url — VARCHAR(1024)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL