DbSchema/com.wisecoders.dbs.schema/Table

Table

class Table(_schema: Schema, name: String) : AbstractTable, DbUnit

A database table.

Constructors

constructor(_schema: Schema, name: String)

Types

object Companion

enum TableType : Enum<Table.TableType>

The type of the table in database

Properties

open override val attributes: Folder<Column>

open override val children: List<TreeUnit>

val columns: Folder<Column>

open override var comment: String?

val commentNotNull: String

open override var commentTags: Map<String, String>

val constraints: Folder<Constraint>

defaultSyncPriority

open override val defaultSyncPriority: Int

val foreignKeys: Folder<ForeignKey>

var generatorOrder: Int

generatorRowsCount

var generatorRowsCount: Int

importedRelations

open override val importedRelations: List<ForeignKey>

incomingRelations

val incomingRelations: MutableList<ForeignKey>

val indexes: Folder<Index>

isMarkedForDeletion

open override val isMarkedForDeletion: Boolean

open override val isView: Boolean

open override var isVirtual: Boolean

open var key: String

open override var mutatedAt: Long

open override var name: String

nameWithSchemaName

open override val nameWithSchemaName: String

var options: String?

open override val parent: TreeUnit

var postScript: String?

var preScript: String?

val primaryKey: Index?

primaryKeyOrUniqueIndex

val primaryKeyOrUniqueIndex: Index?

var priorName: String?

open override val relations: Folder<ForeignKey>

var rowCount: Long

specificationOptions

var specificationOptions: String?

var superTable: Table?

superTableDiscriminator

var superTableDiscriminator: String?

open override val symbolicName: String

Returns the name of the node.

open var syncFolders: List<List<AbstractUnit>>

open override var syncPriority: Int

val tableGenerator: GeneratorTable

val triggers: Folder<Trigger>

var type: Table.TableType

Functions

fun columnIsPk(column: Column?): Boolean

open operator override fun compareTo(other: AbstractUnit): Int

open override fun createColumn(name: String, type: DataType): Column

fun createColumn(columnName: String, dataTypeName: String): Column

fun createColumn(name: String, type: DataType, spec: AttributeSpec): Column

fun createColumn(name: String, type: DataType, length: Int): Column

createConstraint

fun createConstraint(name: String): Constraint

fun createIndex(name: String): Index

createPrimaryKey

fun createPrimaryKey(name: String): Index

open override fun createRelation(name: String, targetEntity: AbstractTable): ForeignKey

open override fun getByName(name: String): TreeUnit?

getColumnByNameOrPath

fun getColumnByNameOrPath(path: String?): Column?

open override fun getDbId(): String

open override fun getDisplayName(diagram: Diagram): String

open override fun getIcon(): ERROR CLASS: Symbol not found for Icon

fun getIndexByType(type: IndexType): Index?

getIndexFittingColumns

fun getIndexFittingColumns(onColumns: List<Column?>): Index?

getPkOrUniqueIndexContaining

fun getPkOrUniqueIndexContaining(attributes: List<Column?>, exactMatch: Boolean): Index?

getPropertyAddOnFolder

fun getPropertyAddOnFolder(name: String?): PropertyAddOnFolder?

open override fun getSchema(): Schema

fun hasFkOrRef(): Boolean

open override fun hasOneColumnPk(): Boolean

markForDeletion

open override fun markForDeletion()

Call this method to mark a unit (table, column) to be deleted. It can be called from any thread. The effective deletion is done by calling project.refresh() or schema.refresh() on JavaFX GUI thread.

fun matches(unit: AbstractUnit?): Boolean

fun merge(target: Table)

presetColumnOrder

fun presetColumnOrder()

open override fun ref(): String

open override fun refresh()

removeDuplicateIndexes

fun removeDuplicateIndexes()

fun rename(newName: String): Boolean

fun sameAs(unit: AbstractUnit): Boolean

open fun sameAs(unit: AbstractUnit, considerRenaming: Boolean): Boolean

open override fun setCommentTag(key: String, value: String?)

fun setOptions(options: String?): Boolean

fun setPostScript(preScript: String?): Boolean

fun setPreScript(preScript: String?): Boolean

setSpecificationOptions

fun setSpecificationOptions(options: String?): Boolean

open override fun toString(): String