Interface: CreateTableBuilder#
Hierarchy#
↳ CreateTableBuilder
Methods#
bigIncrements#
â–¸ bigIncrements(columnName?: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName? | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1723
bigInteger#
â–¸ bigInteger(columnName: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1728
binary#
â–¸ binary(columnName: string, length?: number): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
length? | number |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1757
boolean#
â–¸ boolean(columnName: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1746
charset#
â–¸ charset(val: string): CreateTableBuilder
Parameters:#
| Name | Type |
|---|---|
val | string |
Returns: CreateTableBuilder
Defined in: node_modules/knex/types/index.d.ts:1795
collate#
â–¸ collate(val: string): CreateTableBuilder
Parameters:#
| Name | Type |
|---|---|
val | string |
Returns: CreateTableBuilder
Defined in: node_modules/knex/types/index.d.ts:1796
comment#
â–¸ comment(val: string): TableBuilder
Parameters:#
| Name | Type |
|---|---|
val | string |
Returns: TableBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1771
date#
â–¸ date(columnName: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1747
dateTime#
â–¸ dateTime(columnName: string, options?: Readonly<{ precision?: number ; useTz?: boolean }>): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
options? | Readonly<{ precision?: number ; useTz?: boolean }> |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1748
decimal#
â–¸ decimal(columnName: string, precision?: null | number, scale?: number): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
precision? | null | number |
scale? | number |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1741
double#
â–¸ double(columnName: string, precision?: number, scale?: number): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
precision? | number |
scale? | number |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1736
dropColumn#
â–¸ dropColumn(columnName: string): TableBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
Returns: TableBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1724
dropColumns#
â–¸ dropColumns(...columnNames: string[]): TableBuilder
Parameters:#
| Name | Type |
|---|---|
...columnNames | string[] |
Returns: TableBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1725
dropForeign#
â–¸ dropForeign(columnNames: readonly string[], foreignKeyName?: string): TableBuilder
Parameters:#
| Name | Type |
|---|---|
columnNames | readonly string[] |
foreignKeyName? | string |
Returns: TableBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1785
dropIndex#
â–¸ dropIndex(columnNames: string | readonly (string | Raw<any>)[], indexName?: string): TableBuilder
Parameters:#
| Name | Type |
|---|---|
columnNames | string | readonly (string | Raw<any>)[] |
indexName? | string |
Returns: TableBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1788
dropPrimary#
â–¸ dropPrimary(constraintName?: string): TableBuilder
Parameters:#
| Name | Type |
|---|---|
constraintName? | string |
Returns: TableBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1787
dropTimestamps#
â–¸ dropTimestamps(): ColumnBuilder
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1789
dropUnique#
â–¸ dropUnique(columnNames: readonly (string | Raw<any>)[], indexName?: string): TableBuilder
Parameters:#
| Name | Type |
|---|---|
columnNames | readonly (string | Raw<any>)[] |
indexName? | string |
Returns: TableBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1786
engine#
â–¸ engine(val: string): CreateTableBuilder
Parameters:#
| Name | Type |
|---|---|
val | string |
Returns: CreateTableBuilder
Defined in: node_modules/knex/types/index.d.ts:1794
enu#
â–¸ enu(columnName: string, values: readonly Value[], options?: EnumOptions): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
values | readonly Value[] |
options? | EnumOptions |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1763
enum#
â–¸ enum(columnName: string, values: readonly Value[], options?: EnumOptions): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
values | readonly Value[] |
options? | EnumOptions |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1758
float#
â–¸ float(columnName: string, precision?: number, scale?: number): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
precision? | number |
scale? | number |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1731
foreign#
â–¸ foreign(column: string, foreignKeyName?: string): ForeignConstraintBuilder
Parameters:#
| Name | Type |
|---|---|
column | string |
foreignKeyName? | string |
Returns: ForeignConstraintBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1780
â–¸ foreign(columns: readonly string[], foreignKeyName?: string): MultikeyForeignConstraintBuilder
Parameters:#
| Name | Type |
|---|---|
columns | readonly string[] |
foreignKeyName? | string |
Returns: MultikeyForeignConstraintBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1781
increments#
â–¸ increments(columnName?: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName? | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1722
index#
â–¸ index(columnNames: string | readonly (string | Raw<any>)[], indexName?: string, indexType?: string): TableBuilder
Parameters:#
| Name | Type |
|---|---|
columnNames | string | readonly (string | Raw<any>)[] |
indexName? | string |
indexType? | string |
Returns: TableBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1774
inherits#
â–¸ inherits(val: string): CreateTableBuilder
Parameters:#
| Name | Type |
|---|---|
val | string |
Returns: CreateTableBuilder
Defined in: node_modules/knex/types/index.d.ts:1797
integer#
â–¸ integer(columnName: string, length?: number): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
length? | number |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1727
json#
â–¸ json(columnName: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1768
jsonb#
â–¸ jsonb(columnName: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1769
primary#
â–¸ primary(columnNames: readonly string[], constraintName?: string): TableBuilder
Parameters:#
| Name | Type |
|---|---|
columnNames | readonly string[] |
constraintName? | string |
Returns: TableBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1773
queryContext#
â–¸ queryContext(context: any): TableBuilder
Parameters:#
| Name | Type |
|---|---|
context | any |
Returns: TableBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1790
renameColumn#
â–¸ renameColumn(from: string, to: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
from | string |
to | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1726
specificType#
â–¸ specificType(columnName: string, type: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
type | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1772
string#
â–¸ string(columnName: string, length?: number): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
length? | number |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1730
text#
â–¸ text(columnName: string, textType?: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
textType? | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1729
time#
â–¸ time(columnName: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1749
timestamp#
â–¸ timestamp(columnName: string, options?: Readonly<{ precision?: number ; useTz?: boolean }>): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
options? | Readonly<{ precision?: number ; useTz?: boolean }> |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1750
â–¸ timestamp(columnName: string, withoutTz?: boolean, precision?: number): ColumnBuilder
deprecated
Parameters:#
| Name | Type |
|---|---|
columnName | string |
withoutTz? | boolean |
precision? | number |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1752
timestamps#
â–¸ timestamps(useTimestampType?: boolean, makeDefaultNow?: boolean): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
useTimestampType? | boolean |
makeDefaultNow? | boolean |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1753
unique#
â–¸ unique(columnNames: readonly (string | Raw<any>)[], indexName?: string): TableBuilder
Parameters:#
| Name | Type |
|---|---|
columnNames | readonly (string | Raw<any>)[] |
indexName? | string |
Returns: TableBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1779
uuid#
â–¸ uuid(columnName: string): ColumnBuilder
Parameters:#
| Name | Type |
|---|---|
columnName | string |
Returns: ColumnBuilder
Inherited from: TableBuilder
Defined in: node_modules/knex/types/index.d.ts:1770