SQLite Forum

There is a GUI built with Pyqt5 Qt and there is no id field on this GUI.I am trying to create SQLite3 database for this GUI.9 columns on GUI and There are 10 columns on the database. so i have problem in insert field. I've been getting errors for days.Since I am a student, I am just learning and I am having difficulties in this regard.Database codes are as follows:

global cur

global con
        
con = sqlite3.connect('DataBase.db')

cur = con.cursor()

cur.execute ("CREATE TABLE IF NOT EXISTS Visitors (NAME TEXT NOT NULL, PHONE TEXT NOT NULL, COMPANY TEXT NOT NULL,  PERSON TEXT NOT NULL, EXPLANATION TEXT NOT NULL, CARD_NO TEXT NOT NULL, DATE STRING NOT NULL, IN TEXT NOT NULL, OUT TEXT NOT NULL, ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT)")

con.commit()

con.close()

def InsertVisitors():

   con = sqlite3.connect('DataBase.db')

   cur = con.cursor()

   VisitorsName = self.ui.line_VisitorsName.text()

   VisitorsPhone = self.ui.line_VisitorsPhone.text()

   VisitorsCompany = self.ui.line_VisitorsCompany.text()

   VisitorsPersonDepartment = self.ui.line_VisitorsPersonDepartment.text()

   VisitorsExplanation = self.ui.text_VisitorsExplanation.text()

   VisitorsCardNo = self.ui.line_VisitorsCardNo.text()

   VisitorsDate = self.ui.label_VisitorsDate.text()

   if self.ui.check_VisitorsIn.isChacked():

      VisitorsIn = self.ui.line_VisitorsIn.text()

   else:

      VisitorsIn = self.ui.label_VisitorsTime.text()

   if self.ui.check_VisitorsOut.isChacked():

      VisitorsOut = self.ui.line_VisitorsOut.text()

   else:

      VisitorsOut = self.ui.label_VisitorsTime.text()

   cur.execute("INSERT INTO Visitors (NAME, PHONE, COMPANY, PERSON, EXPLANATION, CARD_NO, DATE, IN, OUT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)", (VisitorsName, VisitorsPhone, VisitorsCompany, VisitorsPersonDepartment, VisitorsExplanation, VisitorsCardNo, VisitorsDate, VisitorsIn, VisitorsOut)) 
            
   con.commit()

   con.close()

I've been dealing with this problem for days, and I can't find a solution. Can you please give me an idea? Thank you so much in advance for your answers.