animesquad
Tables (7)
activity
- id — BIGSERIAL — Primary key — NOT NULL
- squad_id — BIGINT — Foreign key → squad.id — NOT NULL
- actor_id — BIGINT — Foreign key → users.id — NOT NULL
- type — VARCHAR(32) — NOT NULL
- anime_id — BIGINT — Foreign key → anime.id
- payload — JSONB — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
anime
- id — BIGSERIAL — Primary key — NOT NULL
- anilist_id — INT
- title_romaji — VARCHAR(255) — NOT NULL
- title_native — VARCHAR(255) — NOT NULL
- title_english — VARCHAR(255)
- title_korean — VARCHAR(255)
- search_keywords — TEXT
- cover_image_url — VARCHAR(512)
- episodes — INT
- status — VARCHAR(32) — NOT NULL
- format — VARCHAR(32) — NOT NULL
- season_year — INT
- season — VARCHAR(10)
- start_date — DATE
- cached_at — TIMESTAMPTZ — NOT NULL
episode_rating
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- anime_id — BIGINT — Foreign key → anime.id — NOT NULL
- episode_number — INT — NOT NULL
- score — INT
- comment — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
membership
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- squad_id — BIGINT — Foreign key → squad.id — NOT NULL
- role — VARCHAR(16) — NOT NULL
- joined_at — TIMESTAMPTZ — NOT NULL
squad
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(80) — NOT NULL
- owner_id — BIGINT — Foreign key → users.id — NOT NULL
- invite_code — VARCHAR(16) — NOT NULL
- announcement — TEXT
- avatar_url — TEXT
- banner_url — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
users
- id — BIGSERIAL — Primary key — NOT NULL
- google_sub — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(255) — NOT NULL
- avatar_url — VARCHAR(1024)
- profile_visibility — VARCHAR(20) — NOT NULL
- terms_agreed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
watch_entry
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- anime_id — BIGINT — Foreign key → anime.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- progress — INT — NOT NULL
- score — INT
- comment — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL