API 参考
    正在准备搜索索引...

    接口 TableForeignKeyOptions

    Foreign key options.

    interface TableForeignKeyOptions {
        columnNames: string[];
        deferrable?: string;
        name?: string;
        onDelete?: string;
        onUpdate?: string;
        referencedColumnNames: string[];
        referencedDatabase?: string;
        referencedSchema?: string;
        referencedTableName: string;
    }
    索引

    属性

    columnNames: string[]

    Column names which included by this foreign key.

    deferrable?: string

    Set this foreign key constraint as "DEFERRABLE" e.g. check constraints at start or at the end of a transaction

    name?: string

    Name of the foreign key.

    onDelete?: string

    "ON DELETE" of this foreign key, e.g. what action database should perform when referenced stuff is being deleted.

    onUpdate?: string

    "ON UPDATE" of this foreign key, e.g. what action database should perform when referenced stuff is being updated.

    referencedColumnNames: string[]

    Column names which included by this foreign key.

    referencedDatabase?: string

    Database of the Table referenced in the foreign key.

    referencedSchema?: string

    Schema of the Table referenced in the foreign key.

    referencedTableName: string

    Table referenced in the foreign key.