If you want to keep the line:

id = models.BigAutoField(primary_key=True)

You should had auto_created = True :

id = models.BigAutoField(primary_key=True, auto_created = True)

Else it is null as you get in your error message.

But you needn't really this line. Django do it by itself.