IntegrityError at /station/Add/ (1048, "Column 'user_type_id' cannot be null")
Я пытаюсь создать новую станцию, используя общие представления когда я пытаюсь создать новую станцию без ключа пользователя я получаю эту ошибку IntegrityError at /station/Add/ (1048, "Column 'user_type_id' cannot be null")
если я попробую без user_type и кнопки submit, форма автоматически обновится и будет такой же чистой. Вот мой код: station/views.py
class StationCreateView(LoginRequiredMixin, CreateView):
model = Station
fields = ('station_name', 'station_address','connectors','status', 'start_time','end_time','open_day',
'state', 'city', 'area', 'user')
template_name = 'owner/add_station.html'
def form_valid(self, form):
form.instance.user = self.request.user
return super().form_valid(form)
class Station(models.Model):
STAUTUS_CHOICE = (
("ACTIVE", "ACTIVE"),
("INACTIVE", "INACTIVE")
)
DAY_CHOICE = (
("MONDAY", "MONDAY"),
("Tuesday", "TUESDAY"),
("WEDNESDAY", "WEDNESDAY"),
("THURSDAY", "THURSDAY"),
("FRIDAY", "FRIDAY"),
("SATURDAY", "SATURDAY"),
("SUNDAY", "SUNDAY"),
("ALL DAY", "ALL DAY")
)
station_id = models.AutoField(primary_key=True)
state = models.ForeignKey(State, on_delete=models.CASCADE)
city = models.ForeignKey(City, on_delete=models.CASCADE)
area = models.ForeignKey(Area, on_delete=models.CASCADE)
user = models.ForeignKey(User, on_delete=models.CASCADE)
station_name = models.CharField(max_length=50)
station_address = models.CharField(max_length=255)
connectors = models.CharField(max_length=50)
status = models.CharField(max_length=20, choices=STAUTUS_CHOICE, default="ACTIVE")
start_time = models.TimeField(null=True)
end_time = models.TimeField(null=True)
open_day = models.CharField(max_length=20, choices=DAY_CHOICE, default="ALL DAY")
# give_feedback = models.CharField(max_length=255, null=True)
deleted = models.IntegerField(default=0, unique=False)
here is my code: add_station.html