In what there can be a problem with a DB? Didn't create additional tables?

Question

Django

The database contains the following models:

class Musician(models.Model):
    id_musician = models.AutoField(primary_key=True)
    pseudonym = models.CharField(max_length=30)

class Genre(models.Model):
    id_genre = models.AutoField(primary_key=True)
    name_genre = models.CharField("genre's name", max_length=30)

class Song(models.Model):
    id_song = models.AutoField(primary_key=True)
    name_song = models.CharField("song's name", max_length=30)
    album = models.CharField(max_length=30)
    release_date = models.DateField
    text = models.TextField
    musician = models.ManyToManyField(Musician)
    genre = models.ManyToManyField(Genre)

I'm working on the Django administration page. Filled in some data for artists and genres. When I try to add a song, I get an error.

Probably a stupid mistake due to the disgusting knowledge of the database, but nevertheless, tell me, what is my trouble?

Answer 1

Let me sum up a few answers and add a little of my own.
- release_date = models.DateField()- brackets are missing, and also in some similar fields. I also suspect that it should blank=True, null=True.
- Explicit setting of primary keys is not necessary. id_song, id_genre, ...- superfluous. Django itself creates a named primary key idfor each table.
- It seems to me that many of your fields should have blank=True, otherwise they are all mandatory.
- Albumas it seems to me, it should be a separate table linked by foreign key.
After fixing this, makemigrations and migrate should be done as mentioned above.

Answer 2

To create the necessary tables from models, migrations are used, which can be created and applied with the following commands:

manage.py makemigrations
manage.py migrate

Answer 3

Directly: there is no such table "JustLyrics_song_musician"