Describes an association in the database schema.
final class ForeignKeyDefinitionYou get instances of ForeignKeyDefinition when you create a database tables. For example:
try db.create(table: "player") { t in
t.belongsTo("team") // ForeignKeyDefinition
}See belongsTo(_:inTable:onDelete:onUpdate:deferred:indexed:).
import GRDBA toolkit for SQLite databases, with a focus on application development
@discardableResult func belongsTo(_ name: String, inTable table: String? = nil, onDelete deleteAction: Database.ForeignKeyAction? = nil, onUpdate updateAction: Database.ForeignKeyAction? = nil, deferred isDeferred: Bool = false, indexed: Bool = true) -> ForeignKeyDefinition Declares an association to another table.
func foreignKey(_ columns: [String], references table: String, columns destinationColumns: [String]? = nil, onDelete deleteAction: Database.ForeignKeyAction? = nil, onUpdate updateAction: Database.ForeignKeyAction? = nil, deferred isDeferred: Bool = false) Adds a foreign key.
@discardableResult func notNull(onConflict conflictResolution: Database.ConflictResolution? = nil) -> Self Adds a not null constraint.
@discardableResult func unique() -> Self Adds a unique constraint.