Skip to content

@142vip.nest typeorm.类.Table

mmdapl edited this page Oct 8, 2026 · 1 revision

API 参考 / @142vip/nest-typeorm / Table

类: Table

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:13

Table in the database represented in this class.

构造函数

构造函数

new Table(options?): Table

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:71

参数

options?

TableOptions

返回

Table

属性

@instanceof

readonly @instanceof: symbol

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:14


checks

checks: TableCheck[]

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:48

Table check constraints.


columns

columns: TableColumn[]

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:32

Table columns.


comment?

optional comment?: string

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:70

Table comment. Not supported by all database types.


database?

optional database?: string

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:18

Database name that this table resides in if it applies.


engine?

optional engine?: string

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:66

Table engine.


exclusions

exclusions: TableExclusion[]

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:52

Table exclusion constraints.


foreignKeys

foreignKeys: TableForeignKey[]

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:40

Table foreign keys.


indices

indices: TableIndex[]

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:36

Table indices.


justCreated

justCreated: boolean

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:58

Indicates if table was just created. This is needed, for example to check if we need to skip primary keys creation for new tables.


name

name: string

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:28

May contain database name, schema name and table name, unless they're the current database.

E.g. myDB.mySchema.myTable


schema?

optional schema?: string

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:22

Schema name that this table resides in if it applies.


uniques

uniques: TableUnique[]

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:44

Table unique constraints.


withoutRowid?

optional withoutRowid?: boolean

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:62

Enables Sqlite "WITHOUT ROWID" modifier for the "CREATE TABLE" statement

访问器

primaryColumns

Getter 签名

get primaryColumns(): TableColumn[]

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:72

返回

TableColumn[]

方法

addCheckConstraint()

addCheckConstraint(checkConstraint): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:96

Adds check constraint.

参数

checkConstraint

TableCheck

返回

void


addColumn()

addColumn(column): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:80

Add column and creates its constraints.

参数

column

TableColumn

返回

void


addExclusionConstraint()

addExclusionConstraint(exclusionConstraint): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:104

Adds exclusion constraint.

参数

exclusionConstraint

TableExclusion

返回

void


addForeignKey()

addForeignKey(foreignKey): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:112

Adds foreign keys.

参数

foreignKey

TableForeignKey

返回

void


addIndex()

addIndex(index, isMysql?): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:120

Adds index.

参数

index

TableIndex

isMysql?

boolean

返回

void


addUniqueConstraint()

addUniqueConstraint(uniqueConstraint): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:88

Adds unique constraint.

参数

uniqueConstraint

TableUnique

返回

void


clone()

clone(): Table

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:76

Clones this table to a new table with all properties cloned.

返回

Table


findColumnByName()

findColumnByName(name): TableColumn | undefined

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:125

参数

name

string

返回

TableColumn | undefined


findColumnChecks()

findColumnChecks(column): TableCheck[]

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:141

Returns all column checks.

参数

column

TableColumn

返回

TableCheck[]


findColumnForeignKeys()

findColumnForeignKeys(column): TableForeignKey[]

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:133

Returns all column foreign keys.

参数

column

TableColumn

返回

TableForeignKey[]


findColumnIndices()

findColumnIndices(column): TableIndex[]

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:129

Returns all column indices.

参数

column

TableColumn

返回

TableIndex[]


findColumnUniques()

findColumnUniques(column): TableUnique[]

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:137

Returns all column uniques.

参数

column

TableColumn

返回

TableUnique[]


removeCheckConstraint()

removeCheckConstraint(removedCheck): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:100

Removes check constraint.

参数

removedCheck

TableCheck

返回

void


removeColumn()

removeColumn(column): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:84

Remove column and its constraints.

参数

column

TableColumn

返回

void


removeExclusionConstraint()

removeExclusionConstraint(removedExclusion): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:108

Removes exclusion constraint.

参数

removedExclusion

TableExclusion

返回

void


removeForeignKey()

removeForeignKey(removedForeignKey): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:116

Removes foreign key.

参数

removedForeignKey

TableForeignKey

返回

void


removeIndex()

removeIndex(tableIndex, isMysql?): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:124

Removes index.

参数

tableIndex

TableIndex

isMysql?

boolean

返回

void


removeUniqueConstraint()

removeUniqueConstraint(removedUnique): void

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:92

Removes unique constraint.

参数

removedUnique

TableUnique

返回

void


create()

static create(entityMetadata, driver): Table

定义于: node_modules/.pnpm/typeorm@0.3.30_ioredis@5.6.0_mongodb@6.19.0_mssql@11.0.1_mysql2@3.15.1_pg@8.11.3_ts-node@10.9_6zvdq3z7xgsf663jy3j6oymho4/node_modules/typeorm/schema-builder/table/Table.d.ts:145

Creates table from a given entity metadata.

参数

entityMetadata

EntityMetadata

driver

Driver

返回

Table

Clone this wiki locally