Interface DatabaseForeignKeyInfo

Foreign key information read from the database.

interface DatabaseForeignKeyInfo {
    columnName: string;
    constraintName: string;
    deleteRule: string;
    foreignColumn: string;
    foreignTable: string;
    updateRule: string;
}

Properties

columnName: string

Referencing SQL column on the inspected table.

constraintName: string

Physical foreign-key constraint name.

deleteRule: string

Database ON DELETE action, such as CASCADE or NO ACTION.

foreignColumn: string

Referenced SQL column name.

foreignTable: string

Referenced table name.

updateRule: string

Database ON UPDATE action for referenced-key changes.