Skip to main content

Column

@quik/database


@quik/database / Column

Variable: Column

Column: object

Defined in: database/src/decorators/Column.ts:583

Column decorators and utilities for database models

Type Declaration​

Boolean​

Boolean: (maybeOptions?) => (target, context) => void = BooleanColumn

Boolean column decorator that creates a boolean column.

Parameters​

maybeOptions?​

QBooleanColumnOptions

Boolean column configuration options

Returns​

(target, context) => void

Column​

Column: (options) => (target, context) => void = ColumnDefinition

Base column decorator factory that configures database column properties.

Parameters​

options​

QColumnOptions

Column configuration options

Returns​

(target, context) => void

Throws​

Error If the column options are invalid

CreatedAt​

CreatedAt: (maybeOptions?) => (target, context) => void = CreatedAtColumn

CreatedAt column decorator that creates a timestamp column with current timestamp as default.

Parameters​

maybeOptions?​

QDateTimeColumnOptions

DateTime column configuration options

Returns​

(target, context) => void

Date​

Date: (maybeOptions?) => (target, context) => void = DateColumn

Date column decorator that creates a date column.

Parameters​

maybeOptions?​

QDateColumnOptions

Date column configuration options

Returns​

(target, context) => void

DateTime​

DateTime: (maybeOptions?) => (target, context) => void = DateTimeColumn

DateTime column decorator that creates a datetime column.

Parameters​

maybeOptions?​

QDateTimeColumnOptions

DateTime column configuration options

Returns​

(target, context) => void

Decimal​

Decimal: (maybeOptions?) => (target, context) => void = DecimalColumn

Decimal column decorator that creates a decimal column with precision and scale.

Parameters​

maybeOptions?​

QDecimalColumnOptions

Decimal column configuration options

Returns​

(target, context) => void

DeletedAt​

DeletedAt: (maybeOptions?) => (target, context) => void = DeletedAtColumn

DeletedAt column decorator that creates a nullable timestamp column for soft delete functionality.

Parameters​

maybeOptions?​

QDateTimeColumnOptions

DateTime column configuration options

Returns​

(target, context) => void

Enum​

Enum: <T>(maybeOptions) => (target, context) => void = EnumColumn

Enum column decorator that creates an enum column with specific values.

Type Parameters​

T​

T

Parameters​

maybeOptions​

QEnumColumnOptions<T>

Enum column configuration options including the enum values

Returns​

(target, context) => void

Float​

Float: (maybeOptions?) => (target, context) => void = FloatColumn

Float column decorator that creates a floating-point number column.

Parameters​

maybeOptions?​

QFloatColumnOptions

Float column configuration options

Returns​

(target, context) => void

Integer​

Integer: (maybeOptions?) => (target, context) => void = IntegerColumn

Integer column decorator that creates an integer column.

Parameters​

maybeOptions?​

QIntegerColumnOptions

Integer column configuration options

Returns​

(target, context) => void

Json​

Json: (maybeOptions?) => (target, context) => void = JsonColumn

JSON column decorator that creates a json column.

Parameters​

maybeOptions?​

QJsonColumnOptions

JSON column configuration options

Returns​

(target, context) => void

Jsonb​

Jsonb: (maybeOptions?) => (target, context) => void = JsonbColumn

JSONB column decorator that creates a jsonb column.

Parameters​

maybeOptions?​

QJsonColumnOptions

JSONB column configuration options

Returns​

(target, context) => void

Password​

Password: (lengthOrOptions?, maybeOptions?) => (target, context) => void = PasswordColumn

Password column decorator that creates a column suitable for storing hashed passwords.

Parameters​

lengthOrOptions?​

number | QStringColumnOptions

Column length or configuration options

maybeOptions?​

QStringColumnOptions

Additional options when the first parameter is a length

Returns​

(target, context) => void

PrimaryGenerated​

PrimaryGenerated: (strategyOrOptions?, maybeOptions?) => (target, context) => void = PrimaryGeneratedColumn

Primary generated column decorator that creates an auto-generated primary key column.

Parameters​

strategyOrOptions?​

"uuid" | "increment" | QPrimaryGeneratedColumnNumericOptions

Generation strategy ('increment' or 'uuid') or column options

maybeOptions?​

QPrimaryGeneratedColumnNumericOptions & object

Additional options when the first parameter is a strategy

Returns​

(target, context) => void

PrimaryKey​

PrimaryKey: (options) => (target, context) => void = PrimaryKeyColumn

Primary key column decorator that creates a primary key column.

Parameters​

options​

QColumnOptions

Column configuration options

Returns​

(target, context) => void

String​

String: (lengthOrOptions?, maybeOptions?) => (target, context) => void = StringColumn

String column decorator that creates a varchar column.

Parameters​

lengthOrOptions?​

number | QStringColumnOptions

Column length or configuration options

maybeOptions?​

QStringColumnOptions

Additional options when the first parameter is a length

Returns​

(target, context) => void

Text​

Text: (lengthOrOptions?, maybeOptions?) => (target, context) => void = TextColumn

Text column decorator that creates a text column for storing longer strings.

Parameters​

lengthOrOptions?​

"short" | "long" | "medium" | QTextColumnOptions

Text size or configuration options

maybeOptions?​

QTextColumnOptions

Additional options when the first parameter is a size

Returns​

(target, context) => void

Timestamp​

Timestamp: (maybeOptions?) => (target, context) => void = TimestampColumn

Timestamp column decorator that creates a timestamp column.

Parameters​

maybeOptions?​

QTimestampColumnOptions

Timestamp column configuration options

Returns​

(target, context) => void

UpdatedAt​

UpdatedAt: (maybeOptions?) => (target, context) => void = UpdatedAtColumn

UpdatedAt column decorator that creates a timestamp column with auto-update on record modification.

Parameters​

maybeOptions?​

QDateTimeColumnOptions

DateTime column configuration options

Returns​

(target, context) => void

UUID​

UUID: (maybeOptions?) => (target, context) => void = UUIDColumn

UUID column decorator that creates a uuid column.

Parameters​

maybeOptions?​

QStringColumnOptions

UUID Column configuration options

Returns​

(target, context) => void