Table

The definition of a table or view in the logical database schema.

Properties

alias : string

Physical name of the table. Overrides the name and the prefix. It should be properly quoted, if necessary. Allowed only in non-portable schemas for non-managed tables.

aspects : aspectList

List of names of aspect tables to include in or exclude from (if prefixed with !) this table. If an aspect table will be included in this table, the aspect tables's columns and indexes are appended to this table's items.

Valid values based on“token”.
(!?:?[\p{L}_][\p{L}\p{N}_]*(:[\p{L}_][\p{L}\p{N}_]*)*\s+)*(!?:?[\p{L}_][\p{L}\p{N}_]*(:[\p{L}_][\p{L}\p{N}_]*)*)?	Each element in the list must begin with a letter or underscore. Elements are space delimited. To exclude a token, prefix it with the character "!".

description : string

Table description.

hints : identifierList

List of hints to add to the table.

Valid values based on“token”.
(:?[\p{L}_][\p{L}\p{N}_]*(:[\p{L}_][\p{L}\p{N}_]*)*\s+)*(:?[\p{L}_][\p{L}\p{N}_]*(:[\p{L}_][\p{L}\p{N}_]*)*)?	Each element in the list must begin with a letter or underscore. Elements are space delimited.

indexspace : dbObjName

Index tablespace or file group name. Use "default" for the database default.

Valid values based on“string”.
[A-Za-z][_A-Za-z\d]*

longspace : dbObjName

Long column tablespace or file group name. Use "default" for the database default.

Valid values based on“string”.
[A-Za-z][_A-Za-z\d]*

name : tableName

Table name, may include the owner: [<owner>.]<table>

Valid values based on“string”.
[A-Za-z][_A-Za-z\d]*(\.[A-Za-z][_A-Za-z\d]*)?

pointcuts : string

List of table name patterns (with * and ?) where matches will include or exclude (if prefixed with !) this aspect.

primaryKey : indexName

Table primary key unique index. For query tables use a virtual index.

Valid values based on“string”.
[A-Za-z][_A-Za-z\d]*(\.[A-Za-z][_A-Za-z\d]*){0,2}

tablespace : dbObjName

Tablespace or file group name. Use "default" for the database default.

Valid values based on“string”.
[A-Za-z][_A-Za-z\d]*

type : tableType

Table type. External tables are excluded from DDL scripts generated by tools. Aspect table definition is appended to all matching pointcuts.

Valid values based on“string”.
managed	Managed tables are managed by the upgrade framework. They are included when generating upgrade, create, drop... DDL scripts. Prefixing is also applied to this type of table.
external	External tables are excluded when generating DDL scripts and Prefixing.
query	The table is a cached result, a.k.a. materialized query table, a.k.a. materialized view, a.k.a. indexed view.
view	The table is a view.
aspect	Aspect tables are table elements (columns, indexes, ...) that may be appended to other "managed" tables. They do not represent real tables in the generated schema. An Aspect Table is appended to all tables (or other Aspects) that either specify it by name in their "aspects" property or match the Aspect Table's "pointcut" property. If a table matches the aspect's "poincut" property but excludes the aspect by name in its "aspects" property, the aspect will not be applied to that table.

Content

• Sequence of:

  • Prerequisites [0..1] - For internal use only.

  • Columns [0..1] - The set of columns for the table.

  • Indexes [0..1] - The set of indexes for the table.

  • View [0..1] - A database view definition for the logical table.

Parents

• Tables - The set of tables in the logical database schema.