Sqlite.swift: create subUser table error: unknown column "user_id" in foreign key definition (code: 1)

[developerXiong]

My code looks like this :

static let shared = CYDatabaseManager()

private init() {
    let sqlFilePath = NSHomeDirectory() + "/Documents" + "/db.sqlite3"
    do {
        db = try Connection(sqlFilePath)
    } catch {
        print("connect db error: \(error)")
    }
    createdTableUser()
    createdTableSubUser()
}

func createdTableUser()  {
        do {
            try db.run(users.create(ifNotExists: true) { t in
                    t.column(id, primaryKey: true)
                    t.column(password)
                    t.column(email, unique: true)
                })
        } catch { print("create user table error: \(error)") }
    }

    func createdTableSubUser()  {
        do {
            let des = try db.run(subUsers.create(ifNotExists: true) { t in
                t.column(sid, primaryKey: true)
                t.column(name, unique: true)
                t.column(createTime)
                t.column(sex)
                t.column(age)
                t.column(height)
                t.column(weight)
                t.column(highBP)
                t.column(lowBP)
                t.foreignKey(user_id, references: users, id)
            }).description
            print(des)
        } catch { print("create subUser table error: \(error) \nEnd") }
        db.trace({ (statement) in
            print("---\(statement)")
        })
    }

The Xcode print create subUser table error: unknown column "user_id" in foreign key definition (code: 1) ,and the method trace nothing was returned.

Thanks!!! I have no idea, give me a chance.

[jberkel]

You need to create the column first:

t.column(user_id)
t.foreignKey(user_id, references: users, id)