| Table index | Symbol index | disc | DiscRack database schema |
A CD belonging to a music collection
| Column | Type | Nullable | Default | Description |
|---|---|---|---|---|
| isliked | bool (1) | no | None | Whether or not the owner likes the disc |
| objectid | int8 (8) | no | None | |
| owner | int8 (8) | no | None | The owner of the disc |
| objectversion | int4 (4) | no | None | |
| genre | varchar (36) | no | '' | The genre of the music, such as 'jazz' |
| artist | varchar (36) | no | '' | The performer or composer of the music on this disc |
| title | varchar (36) | no | '' | The title of the disc |
(primary key column name in bold)
None.
| Index name | Unique | Columns | Description |
|---|---|---|---|
| disc_pkey | no | objectid |