Database Schema Reference

This document provides an automatically generated reference for the database schema.

Track Model

Table Name: tracks

Columns

Column Name	Type	Primary Key	Nullable	Default
id	INTEGER	Yes	No
title	VARCHAR	No	No
producer	VARCHAR	No	No
voicebank	VARCHAR	No	No
published_date	DATETIME	No	No
link	VARCHAR	No	No
title_jp	VARCHAR	No	Yes
producer_jp	VARCHAR	No	Yes
voicebank_jp	VARCHAR	No	Yes
image_url	VARCHAR	No	Yes
rank	INTEGER	No	Yes

Relationships

Relationship Name	Related Model	Type	Back Populates
ratings	Rating	One-to-Many	track
lyrics	Lyric	One-to-Many	track
producers	Producer	One-to-Many	tracks
voicebanks	Voicebank	One-to-Many	tracks

---

Rating Model

Table Name: ratings

Columns

Column Name	Type	Primary Key	Nullable	Default
id	INTEGER	Yes	No
track_id	INTEGER	No	No
user_id	INTEGER	No	No
rating	FLOAT	No	No
created_at	DATETIME	No	No	2026-06-10 13:54:42.789474+00:00
updated_at	DATETIME	No	No	2026-06-10 13:54:42.789583+00:00
notes	VARCHAR	No	Yes

Relationships

Relationship Name	Related Model	Type	Back Populates
track	Track	Many-to-One	ratings
user	User	Many-to-One	``

---

UpdateLog Model

Table Name: update_logs

Columns

Column Name	Type	Primary Key	Nullable	Default
id	INTEGER	Yes	No
updated_at	DATETIME	No	No	2026-06-10 13:54:42.791400+00:00

---

PlaylistTrack Model

Table Name: playlist_track_association

Columns

Column Name	Type	Primary Key	Nullable	Default
playlist_id	INTEGER	Yes	No
track_id	INTEGER	Yes	No
position	INTEGER	No	No

Relationships

Relationship Name	Related Model	Type	Back Populates
track	Track	Many-to-One	``

---

Playlist Model

Table Name: playlists

Columns

Column Name	Type	Primary Key	Nullable	Default
id	INTEGER	Yes	No
user_id	INTEGER	No	No
name	VARCHAR(100)	No	No
description	VARCHAR(500)	No	Yes
is_public	BOOLEAN	No	No	True
created_at	DATETIME	No	No	2026-06-10 13:54:42.794849+00:00

Relationships

Relationship Name	Related Model	Type	Back Populates
playlist_tracks	PlaylistTrack	One-to-Many	``
user	User	Many-to-One	``

---