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