UserRoles

object UserRoles : Table

Functions

autoGenerate

fun Column<UUID>.autoGenerate(): Column<UUID>

autoinc

fun <N : Comparable<N>> Column<EntityID<N>>.autoinc(idSeqName: String?): Column<EntityID<N>>

autoIncrement

fun <N : Any> Column<N>.autoIncrement(idSeqName: String?): Column<N>

binary

fun binary(name: String): Column<ByteArray>

fun binary(name: String, length: Int): Column<ByteArray>

blob

fun blob(name: String): Column<ExposedBlob>

bool

fun bool(name: String): Column<Boolean>

byte

fun byte(name: String): Column<Byte>

char

fun char(name: String): Column<Char>

fun char(name: String, length: Int, collate: String?): Column<String>

check

fun check(name: String, op: SqlExpressionBuilder.() -> Op<Boolean>)

fun <T> Column<T>.check(name: String, op: SqlExpressionBuilder.(Column<T>) -> Op<Boolean>): Column<T>

clientDefault

fun <T : Any> Column<T>.clientDefault(defaultValue: () -> T): Column<T>

createStatement

open override fun createStatement(): List<String>

crossJoin

open infix override fun crossJoin(otherTable: ColumnSet): Join

customEnumeration

fun <T : Enum<T>> customEnumeration(name: String, sql: String?, fromDb: (Any) -> T, toDb: (T) -> Any): Column<T>

decimal

fun decimal(name: String, precision: Int, scale: Int): Column<BigDecimal>

default

fun <T : Any> Column<T>.default(defaultValue: T): Column<T>

defaultExpression

fun <T : Any> Column<T>.defaultExpression(defaultValue: Expression<T>): Column<T>

describe

open override fun describe(s: Transaction, queryBuilder: QueryBuilder)

double

fun double(name: String): Column<Double>

dropStatement

open override fun dropStatement(): List<String>

entityId

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

fun <T : Enum<T>> enumeration(name: String, klass: KClass<T>): Column<T>

enumerationByName

fun <T : Enum<T>> enumerationByName(name: String, length: Int, klass: KClass<T>): Column<T>

equals

open operator override fun equals(other: Any?): Boolean

float

fun float(name: String): Column<Float>

fullJoin

open infix override fun fullJoin(otherTable: ColumnSet): Join

hashCode

open override fun hashCode(): Int

index

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

open infix override fun innerJoin(otherTable: ColumnSet): Join

integer

fun integer(name: String): Column<Int>

join

open override fun join(otherTable: ColumnSet, joinType: JoinType, onColumn: Expression<*>?, otherColumn: Expression<*>?, additionalConstraint: SqlExpressionBuilder.() -> Op<Boolean>?): Join

leftJoin

open infix override fun leftJoin(otherTable: ColumnSet): Join

long

fun long(name: String): Column<Long>

modifyStatement

open override fun modifyStatement(): List<String>

nameInDatabaseCase

fun nameInDatabaseCase(): String

nullable

fun <T : Any> Column<T>.nullable(): Column<T?>

optReference

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

fun <T> Column<T>.primaryKey(indx: Int?): Column<T>

reference

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

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

fun <T> registerColumn(name: String, type: IColumnType): Column<T>

replaceColumn

fun <TColumn : Column<*>> replaceColumn(oldColumn: Column<*>, newColumn: TColumn): TColumn

rightJoin

open infix override fun rightJoin(otherTable: ColumnSet): Join

short

fun short(name: String): Column<Short>

slice

fun slice(vararg columns: Expression<*>): FieldSet

fun slice(columns: List<Expression<*>>): FieldSet

text

fun text(name: String, collate: String?, eagerLoading: Boolean): Column<String>

toString

open fun toString(): String

ulong

@ExperimentalUnsignedTypes()

fun ulong(name: String): Column<ULong>

uniqueIndex

fun uniqueIndex(vararg columns: Column<*>)

fun <T> Column<T>.uniqueIndex(customIndexName: String?): Column<T>

fun uniqueIndex(customIndexName: String?, vararg columns: Column<*>)

uuid

fun uuid(name: String): Column<UUID>

varchar

fun varchar(name: String, length: Int, collate: String?): Column<String>

Properties

autoIncColumn

val autoIncColumn: Column<*>?

columns

open override val columns: List<Column<*>>

ddl

val ddl: List<String>

fields

open override val fields: List<Expression<*>>

val id: Column<Long>

indices

val indices: List<Index>

primaryKey

open override val primaryKey: Table.PrimaryKey

roleId

val roleId: Column<Int>

source

open override val source: ColumnSet

tableName

open val tableName: String

userId

val userId: Column<Long>