Users

object Users : Table

Functions

autoGenerate
Link copied to clipboard
fun Column<UUID>.autoGenerate(): Column<UUID>
autoinc
Link copied to clipboard
fun <N : Comparable<N>> Column<EntityID<N>>.autoinc(idSeqName: String?): Column<EntityID<N>>
autoIncrement
Link copied to clipboard
fun <N : Any> Column<N>.autoIncrement(idSeqName: String?): Column<N>
binary
Link copied to clipboard
fun binary(name: String): Column<ByteArray>
fun binary(name: String, length: Int): Column<ByteArray>
blob
Link copied to clipboard
fun blob(name: String): Column<ExposedBlob>
bool
Link copied to clipboard
fun bool(name: String): Column<Boolean>
byte
Link copied to clipboard
fun byte(name: String): Column<Byte>
char
Link copied to clipboard
fun char(name: String): Column<Char>
fun char(name: String, length: Int, collate: String?): Column<String>
check
Link copied to clipboard
fun check(name: String, op: SqlExpressionBuilder.() -> Op<Boolean>)
fun <T> Column<T>.check(name: String, op: SqlExpressionBuilder.(Column<T>) -> Op<Boolean>): Column<T>
clientDefault
Link copied to clipboard
fun <T : Any> Column<T>.clientDefault(defaultValue: () -> T): Column<T>
createStatement
Link copied to clipboard
open override fun createStatement(): List<String>
crossJoin
Link copied to clipboard
open infix override fun crossJoin(otherTable: ColumnSet): Join
customEnumeration
Link copied to clipboard
fun <T : Enum<T>> customEnumeration(name: String, sql: String?, fromDb: (Any) -> T, toDb: (T) -> Any): Column<T>
decimal
Link copied to clipboard
fun decimal(name: String, precision: Int, scale: Int): Column<BigDecimal>
default
Link copied to clipboard
fun <T : Any> Column<T>.default(defaultValue: T): Column<T>
defaultExpression
Link copied to clipboard
fun <T : Any> Column<T>.defaultExpression(defaultValue: Expression<T>): Column<T>
describe
Link copied to clipboard
open override fun describe(s: Transaction, queryBuilder: QueryBuilder)
double
Link copied to clipboard
fun double(name: String): Column<Double>
dropStatement
Link copied to clipboard
open override fun dropStatement(): List<String>
entityId
Link copied to clipboard
fun <T : Comparable<T>> Column<T>.entityId(): Column<EntityID<T>>
fun <ID : Comparable<ID>> entityId(name: String, table: IdTable<ID>): Column<EntityID<ID>>
fun <ID : Comparable<ID>> entityId(name: String, originalColumn: Column<ID>): Column<EntityID<ID>>
enumeration
Link copied to clipboard
fun <T : Enum<T>> enumeration(name: String, klass: KClass<T>): Column<T>
enumerationByName
Link copied to clipboard
fun <T : Enum<T>> enumerationByName(name: String, length: Int, klass: KClass<T>): Column<T>
equals
Link copied to clipboard
open operator override fun equals(other: Any?): Boolean
float
Link copied to clipboard
fun float(name: String): Column<Float>
fullJoin
Link copied to clipboard
open infix override fun fullJoin(otherTable: ColumnSet): Join
hashCode
Link copied to clipboard
open override fun hashCode(): Int
index
Link copied to clipboard
fun index(isUnique: Boolean, vararg columns: Column<*>)
fun <T> Column<T>.index(customIndexName: String?, isUnique: Boolean): Column<T>
fun index(customIndexName: String?, isUnique: Boolean, vararg columns: Column<*>)
innerJoin
Link copied to clipboard
open infix override fun innerJoin(otherTable: ColumnSet): Join
integer
Link copied to clipboard
fun integer(name: String): Column<Int>
join
Link copied to clipboard
open override fun join(otherTable: ColumnSet, joinType: JoinType, onColumn: Expression<*>?, otherColumn: Expression<*>?, additionalConstraint: SqlExpressionBuilder.() -> Op<Boolean>?): Join
leftJoin
Link copied to clipboard
open infix override fun leftJoin(otherTable: ColumnSet): Join
long
Link copied to clipboard
fun long(name: String): Column<Long>
modifyStatement
Link copied to clipboard
open override fun modifyStatement(): List<String>
nameInDatabaseCase
Link copied to clipboard
fun nameInDatabaseCase(): String
nullable
Link copied to clipboard
fun <T : Any> Column<T>.nullable(): Column<T?>
optReference
Link copied to clipboard
fun <T : Comparable<T>> optReference(name: String, foreign: IdTable<T>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<EntityID<T>?>
fun <T : Comparable<T>> optReference(name: String, refColumn: Column<T>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<T?>
@JvmName(name = "optReferenceByIdColumn")
fun <T : Comparable<T>, E : EntityID<T>> optReference(name: String, refColumn: Column<E>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<E?>
primaryKey
Link copied to clipboard
fun <T> Column<T>.primaryKey(indx: Int?): Column<T>
reference
Link copied to clipboard
fun <T : Comparable<T>> reference(name: String, foreign: IdTable<T>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<EntityID<T>>
fun <T : Comparable<T>> reference(name: String, refColumn: Column<T>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<T>
@JvmName(name = "referenceByIdColumn")
fun <T : Comparable<T>, E : EntityID<T>> reference(name: String, refColumn: Column<E>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): Column<E>
references
Link copied to clipboard
infix fun <T : Comparable<T>, S : T, C : Column<S>> C.references(ref: Column<T>): C
fun <T : Comparable<T>, S : T, C : Column<S>> C.references(ref: Column<T>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): C
@JvmName(name = "referencesById")
fun <T : Comparable<T>, S : T, C : Column<S>> C.references(ref: Column<EntityID<T>>, onDelete: ReferenceOption?, onUpdate: ReferenceOption?, fkName: String?): C
registerColumn
Link copied to clipboard
fun <T> registerColumn(name: String, type: IColumnType): Column<T>
replaceColumn
Link copied to clipboard
fun <TColumn : Column<*>> replaceColumn(oldColumn: Column<*>, newColumn: TColumn): TColumn
rightJoin
Link copied to clipboard
open infix override fun rightJoin(otherTable: ColumnSet): Join
short
Link copied to clipboard
fun short(name: String): Column<Short>
slice
Link copied to clipboard
fun slice(vararg columns: Expression<*>): FieldSet
fun slice(columns: List<Expression<*>>): FieldSet
text
Link copied to clipboard
fun text(name: String, collate: String?, eagerLoading: Boolean): Column<String>
toString
Link copied to clipboard
open fun toString(): String
ulong
Link copied to clipboard
fun ulong(name: String): Column<ULong>
uniqueIndex
Link copied to clipboard
fun uniqueIndex(vararg columns: Column<*>)
fun <T> Column<T>.uniqueIndex(customIndexName: String?): Column<T>
fun uniqueIndex(customIndexName: String?, vararg columns: Column<*>)
uuid
Link copied to clipboard
fun uuid(name: String): Column<UUID>
varchar
Link copied to clipboard
fun varchar(name: String, length: Int, collate: String?): Column<String>

Properties

aisEmail
Link copied to clipboard
val aisEmail: Column<String?>
aisId
Link copied to clipboard
val aisId: Column<Long>
autoIncColumn
Link copied to clipboard
val autoIncColumn: Column<*>?
columns
Link copied to clipboard
open override val columns: List<Column<*>>
createdAt
Link copied to clipboard
val createdAt: Column<LocalDateTime>
ddl
Link copied to clipboard
val ddl: List<String>
fields
Link copied to clipboard
open override val fields: List<Expression<*>>
firstName
Link copied to clipboard
val firstName: Column<String?>
fullName
Link copied to clipboard
val fullName: Column<String?>
id
Link copied to clipboard
val id: Column<Long>
indices
Link copied to clipboard
val indices: List<Index>
lastName
Link copied to clipboard
val lastName: Column<String?>
login
Link copied to clipboard
val login: Column<String?>
primaryKey
Link copied to clipboard
open override val primaryKey: Table.PrimaryKey
source
Link copied to clipboard
open override val source: ColumnSet
tableName
Link copied to clipboard
open val tableName: String