LogoLogo
English
English
  • Welcome
  • About
    • About the CVSA Project
    • Scope of Inclusion
  • Architecture
    • Overview
    • Crawler
    • Database Structure
      • Type of a Song
    • Artificial Intelligence
  • API Doc
    • Catalog
    • Songs
Powered by GitBook

Contents are licensed under CC BY 4.0 if not specified.

On this page

Was this helpful?

Edit on GitHub
  1. Architecture

Database Structure

PreviousCrawlerNextType of a Song

Last updated 1 month ago

Was this helpful?

CVSA uses as our database.

All public data of CVSA (excluding users' personal data) is stored in a database named cvsa_main, which contains the following tables:

  • songs: stores the main information of songs

  • bilibili_user: stores snapshots of Bilibili user information

  • bilibili_metadata: metadata of all videos we collected from bilibili.

  • labelling_result: Contains label of videos in bilibili_metadatatagged by our .

  • video_snapshot: Statistical data of videos that are fetched regularly (e.g., number of views, etc.), we call this fetch process as "snapshot".

  • snapshot_schedule: The scheduling information for video snapshots.

PostgreSQL
AI system