Database Structure

CVSA uses PostgreSQL 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 AI system.

• 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.