public final Column<R> array<E extends Any, R extends List<Any>>(Table $self, String name, ColumnType<E> columnType, List<Integer> maximumCardinality, Integer dimensions)

array

public final Column<R> array<T extends Any, R extends List<Any>>(String name, List<Int> maximumCardinality, Int dimensions)

public final Column<R> array<E extends Any, R extends List<Any>>(String name, ColumnType<E> columnType, List<Int> maximumCardinality, Int dimensions)

autoGenerate

public final Column<UUID> autoGenerate(Column<UUID> $self)

autoinc

public final Column<EntityID<N>> ~~autoinc~~<N extends Any>(Column<EntityID<N>> $self, String idSeqName)

autoIncrement

public final Column<N> autoIncrement<N extends Any>(Column<N> $self, String idSeqName)

public final Column<N> autoIncrement<N extends Any>(Column<N> $self, Sequence sequence)

binary

public final Column<ByteArray> binary(String name)

public final Column<ByteArray> binary(String name, Integer length)

blob

public final Column<ExposedBlob> blob(String name, Boolean useObjectIdentifier)

bool

public final Column<Boolean> bool(String name)

byte

public final Column<Byte> byte(String name)

char

public final Column<Character> char(String name)

public final Column<String> char(String name, Integer length, String collate)

check

public final Unit check(String name, Function1<SqlExpressionBuilder, Op<Boolean>> op)

public final Column<T> check<T extends Any>(Column<T> $self, String name, Function2<SqlExpressionBuilder, Column<T>, Op<Boolean>> op)

clientDefault

public final Column<T> clientDefault<T extends Any>(Column<T> $self, Function0<T> defaultValue)

createStatement

public List<String> createStatement()

crossJoin

public Join crossJoin(ColumnSet otherTable)

customEnumeration

public final Column<T> customEnumeration<T extends Enum<T>>(String name, String sql, Function1<Object, T> fromDb, Function1<T, Object> toDb)

databaseGenerated

public final Column<T> databaseGenerated<T extends Any>(Column<T> $self)

decimal

public final Column<BigDecimal> decimal(String name, Integer precision, Integer scale)

default

public final Column<T> default<T extends Any>(Column<T> $self, T defaultValue)

public final CompositeColumn<T> default<T extends Any>(CompositeColumn<T> $self, T defaultValue)

defaultExpression

public final Column<T> defaultExpression<T extends Any>(Column<T> $self, Expression<T> defaultValue)

describe

public Unit describe(Transaction s, QueryBuilder queryBuilder)

double

public final Column<Double> double(String name)

dropStatement

public List<String> dropStatement()

entityId

public final Column<EntityID<T>> entityId<T extends Any>(Column<T> $self)

public final Column<EntityID<ID>> entityId<ID extends Any>(String name, IdTable<ID> table)

public final Column<EntityID<ID>> entityId<ID extends Any>(String name, Column<ID> originalColumn)

enumeration

public final Column<T> enumeration<T extends Enum<T>>(String name)

public final Column<T> enumeration<T extends Enum<T>>(String name, KClass<T> klass)

enumerationByName

public final Column<T> enumerationByName<T extends Enum<T>>(String name, Integer length)

public final Column<T> enumerationByName<T extends Enum<T>>(String name, Integer length, KClass<T> klass)

equals

public Boolean equals(Object other)

float

public final Column<Float> float(String name)

foreignKey

public final Unit foreignKey(Pair<Column<?>, Column<?>> references, ReferenceOption onUpdate, ReferenceOption onDelete, String name)

public final Unit foreignKey(Column<?> from, Table.PrimaryKey target, ReferenceOption onUpdate, ReferenceOption onDelete, String name)

fullJoin

public Join fullJoin(ColumnSet otherTable)

getAutoIncColumn

public final Column<?> getAutoIncColumn()

getColumns

public List<Column<?>> getColumns()

getDdl

public List<String> getDdl()

getFields

public List<Expression<?>> getFields()

getForeignKeys

public final List<ForeignKeyConstraint> getForeignKeys()

getId

public final Column<EntityID<Integer>> getId()

getIdColumns

public final Set<Column<? extends Object>> getIdColumns()

getIndices

public final List<Index> getIndices()

getItem

public final Column<ExposedBlob> getItem()

getPrimaryKey

public final Table.PrimaryKey getPrimaryKey()

getRealFields

public List<Expression<?>> getRealFields()

getSchemaName

public final String getSchemaName()

getSequences

public final List<Sequence> getSequences()

getSource

public ColumnSet getSource()

getTableName

public String getTableName()

getUuid

public final Column<UUID> getUuid()

hashCode

public Integer hashCode()

index

public final Unit index(Boolean isUnique, Column<?> columns)

public final Column<T> index<T extends Any>(Column<T> $self, String customIndexName, Boolean isUnique)

public final Unit index(String customIndexName, Boolean isUnique, Column<?> columns, List<ExpressionWithColumnType<?>> functions, String indexType, Function1<SqlExpressionBuilder, Op<Boolean>> filterCondition)

innerJoin

public Join innerJoin(ColumnSet otherTable)

integer

public final Column<Integer> integer(String name)

join

public Join join(ColumnSet otherTable, JoinType joinType, Expression<?> onColumn, Expression<?> otherColumn, Boolean lateral, Function1<SqlExpressionBuilder, Op<Boolean>> additionalConstraint)

largeText

public final Column<String> largeText(String name, String collate, Boolean eagerLoading)

leftJoin

public Join leftJoin(ColumnSet otherTable)

long

public final Column<Long> long(String name)

mediumText

public final Column<String> mediumText(String name, String collate, Boolean eagerLoading)

modifyStatement

public List<String> modifyStatement()

nameInDatabaseCase

public final String nameInDatabaseCase()

nameInDatabaseCaseUnquoted

public final String nameInDatabaseCaseUnquoted()

nullable

public final CompositeColumn<T> nullable<T extends Any, C extends CompositeColumn<T>>(C $self)

public final Column<T> nullable<T extends Any>(Column<T> $self)

nullTransform

public final Column<Wrapped> nullTransform<Unwrapped extends Any, Wrapped extends Any>(Column<Unwrapped> $self, ColumnTransformer<Unwrapped, Wrapped> transformer)

public final Column<Wrapped> nullTransform<Unwrapped extends Any, Wrapped extends Any>(Column<Unwrapped> $self, Function1<Unwrapped, Wrapped> wrap, Function1<Wrapped, Unwrapped> unwrap)

optReference

public final Column<EntityID<T>> optReference<T extends Any>(String name, IdTable<T> foreign, ReferenceOption onDelete, ReferenceOption onUpdate, String fkName)

public final Column<T> optReference<T extends Any>(String name, Column<T> refColumn, ReferenceOption onDelete, ReferenceOption onUpdate, String fkName)

optReferenceByIdColumn

public final Column<E> optReferenceByIdColumn<T extends Any, E extends EntityID<T>>(String name, Column<E> refColumn, ReferenceOption onDelete, ReferenceOption onUpdate, String fkName)

reference

public final Column<EntityID<T>> reference<T extends Any>(String name, IdTable<T> foreign, ReferenceOption onDelete, ReferenceOption onUpdate, String fkName)

public final Column<T> reference<T extends Any>(String name, Column<T> refColumn, ReferenceOption onDelete, ReferenceOption onUpdate, String fkName)

referenceByIdColumn

public final Column<E> referenceByIdColumn<T extends Any, E extends EntityID<T>>(String name, Column<E> refColumn, ReferenceOption onDelete, ReferenceOption onUpdate, String fkName)

references

public final C references<T extends Any, S extends T, C extends Column<S>>(C $self, Column<T> ref)

public final C references<T extends Any, S extends T, C extends Column<S>>(C $self, Column<T> ref, ReferenceOption onDelete, ReferenceOption onUpdate, String fkName)

referencesById

public final C referencesById<T extends Any, S extends T, C extends Column<S>>(C $self, Column<EntityID<T>> ref, ReferenceOption onDelete, ReferenceOption onUpdate, String fkName)

registerColumn

public final Column<T> registerColumn<T extends Any>(String name, IColumnType<T> type)

registerCompositeColumn

public final T registerCompositeColumn<R extends Any, T extends CompositeColumn<R>>(T column)

replaceColumn

public final TColumn replaceColumn<TColumn extends Column<?>>(Column<?> oldColumn, TColumn newColumn)

rightJoin

public Join rightJoin(ColumnSet otherTable)

select

public final Query select(List<Expression<?>> columns)

public final Query select(Expression<?> column, Expression<?> columns)

setItem

public final Unit setItem(Column<ExposedBlob> item)

setUuid

public final Unit setUuid(Column<UUID> uuid)

short

public final Column<Short> short(String name)

slice

public final FieldSet ~~slice~~(List<Expression<?>> columns)

public final FieldSet ~~slice~~(Expression<?> column, Expression<?> columns)

text

public final Column<String> text(String name, String collate, Boolean eagerLoading)

transform

public final Column<Wrapped> transform<Unwrapped extends Any, Wrapped extends Any>(Column<Unwrapped> $self, ColumnTransformer<Unwrapped, Wrapped> transformer)

public final Column<Wrapped> transform<Unwrapped extends Any, Wrapped extends Any>(Column<Unwrapped> $self, Function1<Unwrapped, Wrapped> wrap, Function1<Wrapped, Unwrapped> unwrap)

transformNullable

public final Column<Wrapped> transformNullable<Unwrapped extends Any, Wrapped extends Any>(Column<Unwrapped> $self, ColumnTransformer<Unwrapped, Wrapped> transformer)

public final Column<Wrapped> transformNullable<Unwrapped extends Any, Wrapped extends Any>(Column<Unwrapped> $self, Function1<Unwrapped, Wrapped> wrap, Function1<Wrapped, Unwrapped> unwrap)

ubyte

public final Column<UByte> ubyte(String name)

uinteger

public final Column<UInt> uinteger(String name)

ulong

public final Column<ULong> ulong(String name)

uniqueIndex

public final Column<T> uniqueIndex<T extends Any>(Column<T> $self, String customIndexName)

public final Unit uniqueIndex(Column<?> columns, Function1<SqlExpressionBuilder, Op<Boolean>> filterCondition)

public final Unit uniqueIndex(String customIndexName, Column<?> columns, List<ExpressionWithColumnType<?>> functions, Function1<SqlExpressionBuilder, Op<Boolean>> filterCondition)

ushort

public final Column<UShort> ushort(String name)

uuid

public final Column<UUID> uuid(String name)

varchar

public final Column<String> varchar(String name, Integer length, String collate)

withDefinition

public final Column<T> withDefinition<T extends Any>(Column<T> $self, Object definition)