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