Interface TableSchema

Table schema information.

interface TableSchema {
    name: string;
    columns: ColumnInfo[];
    primaryKeys?: string[];
    indexes?: IndexInfo[];
    view?: boolean;
    sequence?: string;
    sql?: string;
}

Properties

name: string
columns: ColumnInfo[]
primaryKeys?: string[]

The primary key's columns, in key order.

indexes?: IndexInfo[]
view?: boolean

A selected view is exported as a row snapshot, not recreated as a view.

sequence?: string

SQLite AUTOINCREMENT high-water mark, including ids whose rows were deleted.

sql?: string

SQLite: the CREATE TABLE statement SQLite keeps for the table, which a SQLite import runs.