Oracle Schema

`data`

The data block defines seed/lookup data for a table.

data {
  table = table.countries
  rows = [
    { code = "US", name = "United States" },
    { code = "CA", name = "Canada" },
  ]
}

`data` attributes

Name	Required	Value
`rows`	`true`	Any value
`table`	`true`	Object reference to `table`

`database_link`

`database_link` attributes

Name	Required	Value
`host`	`true`	`string`
`schema`	`false`	Object reference to `schema`

`database_link` blocks

`database_link.authenticated_by`

`database_link.authenticated_by` attributes

Name	Required	Value
`password`	`false`	`string`
`user`	`true`	`string`

`database_link.connect`

`database_link.connect` attributes

Name	Required	Value
`credential`	`false`	`string`
`current_user`	`false`	`bool`
`password`	`false`	`string`
`user`	`false`	`string`

`database_link.connect` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Mutually exclusive sets	`[current_user, user, credential]`
One of required sets	`[current_user, user, credential]`

`database_link` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `database_link "name"` )	`true`
Allow Qualifier (e.g., `database_link "schema" "name"` )	`true`

`function`

The function block describes a function in a database schema.

function "positive" {
  schema = schema.public
  lang   = SQL
  arg "v" {
    type = integer
  }
  ...
}

`function` attributes

Name	Required	Value
`as`	`true`	`string`
`comment`	`false`	`string`
`deterministic`	`false`	`bool`
`return`	`true`	Function return type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference to `object_type` Object reference to `varray` Object reference to `nested_table`
`schema`	`true`	Object reference to `schema`

`function` blocks

`function.annotation`

`function.annotation` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Allow unknown blocks	`true`
Allow unknown attributes	`true`

`function.arg`

`function.arg` attributes

Name	Required	Value
`default`	`false`	Function argument default value can be one of: `bool` `string` `number` Raw expression defined with `sql("expr")`
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`
`type`	`true`	Function argument type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference to `object_type` Object reference to `varray` Object reference to `nested_table`

`function.arg` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `function.arg "name"` )	`true`
Repeatable	`true`

`function` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `function "name"` )	`true`
Allow Qualifier (e.g., `function "schema" "name"` )	`true`

`index_type`

`index_type` attributes

Name	Required	Value
`impl_type`	`true`	Object reference to `object_type`
`local_partition`	`false`	`bool`
`schema`	`true`	Object reference to `schema`
`system_managed`	`false`	`bool`

`index_type` blocks

`index_type.operator`

`index_type.operator` attributes

Name	Required	Value
`operator`	`true`	Object reference to `operator`
`param_types`	`false`	List of schema types

`index_type.operator` constraints

Constraint	Value
Required	`true`
Require Name	`false`
Repeatable	`true`

`index_type` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `index_type "name"` )	`true`
Allow Qualifier (e.g., `index_type "schema" "name"` )	`true`

`nested_table`

`nested_table` attributes

Name Required Value

schema

true

Object reference to schema

type

true

Element type can be one of:

Schema type
Raw expression defined with sql("expr")
Object reference to object_type
Object reference to varray
Object reference to nested_table

`nested_table` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `nested_table "name"` )	`true`
Allow Qualifier (e.g., `nested_table "schema" "name"` )	`true`

`object_type`

`object_type` attributes

Name	Required	Value
`final`	`false`	`bool`
`schema`	`true`	Object reference to `schema`
`under`	`false`	Object reference to `object_type`

`object_type` blocks

`object_type.attribute`

`object_type.attribute` attributes

Name Required Value

type

true

Attribute type can be one of:

Schema type
Raw expression defined with sql("expr")
Object reference to object_type
Object reference to varray
Object reference to nested_table

`object_type.attribute` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `object_type.attribute "name"` )	`true`

`object_type.constructor`

`object_type.constructor` attributes

Name	Required	Value
`as`	`false`	`string`

`object_type.constructor` blocks

`object_type.constructor.arg`

`object_type.constructor.arg` attributes

Name	Required	Value
`default`	`false`	Constructor argument default value can be one of: `bool` `string` `number` Raw expression defined with `sql("expr")`
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`
`type`	`false`	Argument type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference to `object_type` Object reference to `varray` Object reference to `nested_table`

`object_type.constructor.arg` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `object_type.constructor.arg "name"` )	`true`

`object_type.constructor.self`

`object_type.constructor.self` attributes

Name	Required	Value
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`

`object_type.function`

`object_type.function` attributes

Name	Required	Value
`as`	`false`	`string`
`final`	`false`	`bool`
`overriding`	`false`	`bool`
`return`	`false`	Return type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference
`static`	`false`	`bool`

`object_type.function` blocks

`object_type.function.annotation`

`object_type.function.annotation` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Allow unknown blocks	`true`
Allow unknown attributes	`true`

`object_type.function.arg`

`object_type.function.arg` attributes

Name	Required	Value
`default`	`false`	Function argument default value can be one of: `bool` `string` `number` Raw expression defined with `sql("expr")`
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`
`type`	`false`	Argument type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference to `object_type` Object reference to `varray` Object reference to `nested_table`

`object_type.function.arg` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `object_type.function.arg "name"` )	`true`

`object_type.function.self`

`object_type.function.self` attributes

Name	Required	Value
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`

`object_type.function` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `object_type.function "name"` )	`true`
Repeatable	`true`

`object_type.map`

`object_type.map` attributes

Name	Required	Value
`as`	`false`	`string`
`final`	`false`	`bool`
`overriding`	`false`	`bool`
`return`	`false`	Return type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference
`static`	`false`	`bool`

`object_type.map` blocks

`object_type.map.arg`

`object_type.map.arg` attributes

Name	Required	Value
`default`	`false`	Map argument default value can be one of: `bool` `string` `number` Raw expression defined with `sql("expr")`
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`
`type`	`false`	Argument type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference to `object_type` Object reference to `varray` Object reference to `nested_table`

`object_type.map.arg` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `object_type.map.arg "name"` )	`true`

`object_type.map.self`

`object_type.map.self` attributes

Name	Required	Value
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`

`object_type.map` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `object_type.map "name"` )	`true`

`object_type.order`

`object_type.order` attributes

Name	Required	Value
`as`	`false`	`string`
`final`	`false`	`bool`
`overriding`	`false`	`bool`
`return`	`false`	Return type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference
`static`	`false`	`bool`

`object_type.order` blocks

`object_type.order.arg`

`object_type.order.arg` attributes

Name	Required	Value
`default`	`false`	Order argument default value can be one of: `bool` `string` `number` Raw expression defined with `sql("expr")`
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`
`type`	`false`	Argument type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference to `object_type` Object reference to `varray` Object reference to `nested_table`

`object_type.order.arg` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `object_type.order.arg "name"` )	`true`

`object_type.order.self`

`object_type.order.self` attributes

Name	Required	Value
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`

`object_type.order` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `object_type.order "name"` )	`true`

`object_type.procedure`

`object_type.procedure` attributes

Name	Required	Value
`as`	`false`	`string`
`final`	`false`	`bool`
`overriding`	`false`	`bool`
`static`	`false`	`bool`

`object_type.procedure` blocks

`object_type.procedure.annotation`

`object_type.procedure.annotation` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Allow unknown blocks	`true`
Allow unknown attributes	`true`

`object_type.procedure.arg`

`object_type.procedure.arg` attributes

Name	Required	Value
`default`	`false`	Procedure argument default value can be one of: `bool` `string` `number` Raw expression defined with `sql("expr")`
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`
`type`	`false`	Argument type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference to `object_type` Object reference to `varray` Object reference to `nested_table`

`object_type.procedure.arg` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `object_type.procedure.arg "name"` )	`true`

`object_type.procedure.self`

`object_type.procedure.self` attributes

Name	Required	Value
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`

`object_type.procedure` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `object_type.procedure "name"` )	`true`
Repeatable	`true`

`object_type` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `object_type "name"` )	`true`
Allow Qualifier (e.g., `object_type "schema" "name"` )	`true`
Mutually exclusive sets	`[map, order]`

`operator`

`operator` attributes

Name	Required	Value
`schema`	`true`	Object reference to `schema`

`operator` blocks

`operator.binding`

`operator.binding` attributes

Name	Required	Value
`args`	`false`	List of schema types
`compute_ancillary`	`false`	`bool`
`function`	`true`	Binding function can be one of: Object reference to `function` Object reference to `object_type.function` Object reference to `object_type.procedure`
`impl_type`	`false`	Object reference to `object_type`
`return`	`true`	Return type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference
`with_index_context`	`false`	`bool`

`operator.binding` constraints

Constraint	Value
Required	`true`
Require Name	`false`
Repeatable	`true`

`operator` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `operator "name"` )	`true`
Allow Qualifier (e.g., `operator "schema" "name"` )	`true`

`permission`

`permission` attributes

Name	Required	Value
`for`	`true`	Permission target resource can be one of: Object reference to `schema` Object reference to `table` Object reference to `view` Object reference to `function` Object reference to `procedure` Object reference to `table.column` Object reference to `view.column`
`grantable`	`false`	`bool`
`privileges`	`true`	List of strings or/and `enums (ALTER, DEBUG, DELETE, EXECUTE, INDEX, INSERT, READ, REFERENCES, SELECT, UPDATE, WRITE)`
`to`	`true`	Permission grantee (name or role reference) can be one of: `string` Object reference to `role`

`permission` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Repeatable	`true`

`procedure`

The procedure block describes a procedure in a database schema.

procedure "proc" {
  schema = schema.public
  lang   = SQL
  arg "a" {
    type = integer
  }
  ...
}

`procedure` attributes

Name	Required	Value
`as`	`true`	`string`
`comment`	`false`	`string`
`schema`	`true`	Object reference to `schema`

`procedure` blocks

`procedure.annotation`

`procedure.annotation` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Allow unknown blocks	`true`
Allow unknown attributes	`true`

`procedure.arg`

`procedure.arg` attributes

Name	Required	Value
`default`	`false`	Procedure argument default value can be one of: `bool` `string` `number` Raw expression defined with `sql("expr")`
`mode`	`false`	`enum (IN, OUT, INOUT)`
`nocopy`	`false`	`bool`
`type`	`true`	Procedure argument type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference to `object_type` Object reference to `varray` Object reference to `nested_table`

`procedure.arg` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `procedure.arg "name"` )	`true`
Repeatable	`true`

`procedure` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `procedure "name"` )	`true`
Allow Qualifier (e.g., `procedure "schema" "name"` )	`true`

`role`

`role` attributes

Name	Required	Value
`auth`	`false`	`string`
`auth_package`	`false`	`string`
`member_of`	`false`	List of object reference to `role`
`password`	`false`	`string`

`role` blocks

`role.membership`

The membership block describes a membership in a role, along with its options.

user "vault" {
  membership {
    role  = role.reader
    admin = true
  }
}

`role.membership` attributes

Name	Required	Value
`admin`	`false`	`bool`
`role`	`true`	Object reference to `role`

`role.membership` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Repeatable	`true`

`role` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `role "name"` )	`true`
Repeatable	`true`
Mutually exclusive sets	`[password, auth_package, auth]`

`schema`

The schema block describes a database schema.

schema "public" {
  ...
}

`schema` attributes

Name	Required	Value
`name`	`false`	`string`

`schema` blocks

`schema.annotation`

`schema.annotation` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Allow unknown blocks	`true`
Allow unknown attributes	`true`

`schema` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `schema "name"` )	`true`

`sequence`

The sequence block describes a sequence in a database schema.

sequence "name" {
  schema    = schema.public
  type      = int
  increment = 3
  min_value = 9
}

`sequence` attributes

Name	Required	Value
`cache`	`false`	`int`
`cycle`	`false`	`bool`
`increment`	`false`	`number`
`max_value`	`false`	`number`
`min_value`	`false`	`number`
`order`	`false`	`bool`
`schema`	`true`	Object reference to `schema`
`start`	`false`	`number`

`sequence` blocks

`sequence.annotation`

`sequence.annotation` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Allow unknown blocks	`true`
Allow unknown attributes	`true`

`sequence` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `sequence "name"` )	`true`
Allow Qualifier (e.g., `sequence "schema" "name"` )	`true`

`synonym`

`synonym` attributes

Name Required Value

db_link

false

Referenced database link can be one of:

Object reference to database_link
string

object

true

Referenced object can be one of:

Object reference to table
Object reference to view
Object reference to sequence
Object reference to function
Object reference to procedure
string

schema

false

Object reference to schema

`synonym` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `synonym "name"` )	`true`
Allow Qualifier (e.g., `synonym "schema" "name"` )	`true`

`table`

The table block describes a table in a database schema.

table "users" {
  schema = schema.public
  column "id" {
    type = int
  }
  ...
}

`table` attributes

Name	Required	Value
`comment`	`false`	`string`
`depends_on`	`false`	List of object references
`schema`	`true`	Object reference to `schema`

`table` blocks

`table.annotation`

`table.annotation` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Allow unknown blocks	`true`
Allow unknown attributes	`true`

`table.check`

`table.check` attributes

Name	Required	Value
`expr`	`true`	`string`

`table.check` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Repeatable	`true`

`table.column`

`table.column` attributes

Name	Required	Value
`as`	`false`	`string`
`collate`	`false`	`string`
`comment`	`false`	`string`
`default`	`false`	Column default value can be one of: `bool` `string` `number` Raw expression defined with `sql("expr")`
`null`	`false`	`bool`
`type`	`true`	Column type can be one of: Schema type Raw expression defined with `sql("expr")` Object reference to `object_type` Object reference to `varray` Object reference to `nested_table`

`table.column` blocks

`table.column.annotation`

`table.column.annotation` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Allow unknown blocks	`true`
Allow unknown attributes	`true`

`table.column.as`

`table.column.as` attributes

Name	Required	Value
`expr`	`true`	`string`
`type`	`false`	`enum (VIRTUAL)`

`table.column.default`

`table.column.default` attributes

Name Required Value

as

true

Column default value can be one of:

bool
string
number
Raw expression defined with sql("expr")

on_null

true

enum (INSERT_ONLY, INSERT_AND_UPDATE)

`table.column.identity`

`table.column.identity` attributes

Name	Required	Value
`cache`	`false`	`int`
`cycle`	`false`	`bool`
`generated`	`false`	`enum (ALWAYS, BY_DEFAULT)`
`increment`	`false`	`number`
`max_value`	`false`	`number`
`min_value`	`false`	`number`
`on_null`	`false`	`enum (INSERT_ONLY, INSERT_AND_UPDATE)`
`order`	`false`	`bool`
`start`	`false`	`number`

`table.column` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `table.column "name"` )	`true`
Mutually exclusive sets	`[as (attribute), as (block)]`

`table.foreign_key`

`table.foreign_key` attributes

Name Required Value

columns

true

Foreign key columns can be one of:

List of object reference to column
List of object reference to table.column

on_delete

false

enum (NO_ACTION, CASCADE, SET_NULL)

ref_columns

true

Foreign key reference columns can be one of:

List of object reference to column
List of object reference to table.column

`table.foreign_key` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `table.foreign_key "name"` )	`true`

`table.index`

`table.index` attributes

Name	Required	Value
`bitmap`	`false`	`bool`
`columns`	`false`	Index columns can be one of: List of object reference to `column` List of object reference to `table.column`
`domain`	`false`	Domain index type can be one of: `string` Object reference to `index_type`
`parameters`	`false`	`string`
`reversed`	`false`	`bool`
`unique`	`false`	`bool`

`table.index` blocks

`table.index.on`

`table.index.on` attributes

Name Required Value

column

false

Index columns can be one of:

Object reference to column
Object reference to table.column

desc false bool

expr false string

`table.index.on` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Repeatable	`true`
Mutually exclusive sets	`[column, expr]`

`table.index.physical`

`table.index.physical` attributes

Name	Required	Value
`initrans`	`false`	`int`
`pctfree`	`false`	`int`
`pctused`	`false`	`int`
`tablespace`	`false`	`string`

`table.index.physical` blocks

`table.index.physical.storage`

`table.index.physical.storage` attributes

Name	Required	Value
`buffer_pool`	`false`	`enum (KEEP, RECYCLE, DEFAULT)`
`cell_flash_cache`	`false`	`enum (KEEP, NONE, DEFAULT)`
`flash_cache`	`false`	`enum (KEEP, NONE, DEFAULT)`
`freelist_groups`	`false`	`int`
`freelists`	`false`	`int`
`initial`	`false`	`int`
`max_extents`	`false`	`int`
`min_extents`	`false`	`int`
`next`	`false`	`int`
`pct_increase`	`false`	`int`

`table.index` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `table.index "name"` )	`true`
Mutually exclusive sets	`[columns, on]`
One of required sets	`[columns, on]`

`table.physical`

`table.physical` attributes

Name	Required	Value
`initrans`	`false`	`int`
`pctfree`	`false`	`int`
`pctused`	`false`	`int`
`tablespace`	`false`	`string`

`table.physical` blocks

`table.physical.storage`

`table.physical.storage` attributes

Name	Required	Value
`buffer_pool`	`false`	`enum (KEEP, RECYCLE, DEFAULT)`
`cell_flash_cache`	`false`	`enum (KEEP, NONE, DEFAULT)`
`flash_cache`	`false`	`enum (KEEP, NONE, DEFAULT)`
`freelist_groups`	`false`	`int`
`freelists`	`false`	`int`
`initial`	`false`	`int`
`max_extents`	`false`	`int`
`min_extents`	`false`	`int`
`next`	`false`	`int`
`pct_increase`	`false`	`int`

`table.primary_key`

`table.primary_key` attributes

Name	Required	Value
`columns`	`false`	Primary key columns can be one of: List of object reference to `column` List of object reference to `table.column`
`comment`	`false`	`string`
`deferrable`	`false`	`enum (INITIALLY_IMMEDIATE, INITIALLY_DEFERRED)`
`enabled`	`false`	`bool`
`index`	`false`	Object reference to `index`
`rely`	`false`	`bool`
`validated`	`false`	`bool`

`table.primary_key` blocks

`table.primary_key.on`

`table.primary_key.on` attributes

Name Required Value

column

true

Primary key columns can be one of:

Object reference to column
Object reference to table.column

desc false bool

`table.primary_key.on` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Repeatable	`true`

`table.primary_key` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `table.primary_key "name"` )	`true`
Mutually exclusive sets	`[columns, on]`
One of required sets	`[columns, on]`

`table.temporary`

`table.temporary` attributes

Name	Required	Value
`on_commit`	`false`	`enum (DELETE_ROWS, PRESERVE_ROWS)`

`table.unique`

`table.unique` attributes

Name	Required	Value
`columns`	`false`	Unique constraint columns can be one of: List of object reference to `column` List of object reference to `table.column`
`deferrable`	`false`	`enum (INITIALLY_IMMEDIATE, INITIALLY_DEFERRED)`
`enabled`	`false`	`bool`
`index`	`false`	Object reference to `index`
`rely`	`false`	`bool`
`validated`	`false`	`bool`

`table.unique` blocks

`table.unique.on`

`table.unique.on` attributes

Name Required Value

column

false

Unique constraint columns can be one of:

Object reference to column
Object reference to table.column

desc false bool

expr false string

`table.unique.on` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Repeatable	`true`
Mutually exclusive sets	`[column, expr]`

`table.unique` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `table.unique "name"` )	`true`
Mutually exclusive sets	`[columns, on]`
One of required sets	`[columns, on]`

`table` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `table "name"` )	`true`
Allow Qualifier (e.g., `table "schema" "name"` )	`true`

`trigger`

The trigger block describes a trigger on a table in a database schema.

trigger "trigger_orders_audit" {
  on = table.orders
  ...
}

`trigger` attributes

Name	Required	Value
`as`	`false`	`string`
`call`	`false`	`string`
`follows`	`false`	Object reference to `trigger`
`for`	`false`	`enum (ROW, STATEMENT)`
`foreach`	`false`	`enum (ROW, STATEMENT)`
`on`	`true`	Trigger on can be one of: Object reference to `table` Object reference to `view`
`precedes`	`false`	Object reference to `trigger`
`when`	`false`	`string`

`trigger` blocks

`trigger.after`

`trigger.after` attributes

Name	Required	Value
`delete`	`false`	`bool`
`insert`	`false`	`bool`
`truncate`	`false`	`bool`
`update`	`false`	`bool`
`update_of`	`false`	Trigger update_of columns can be one of: List of object reference to `view.column` List of object reference to `table.column`

`trigger.after` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Mutually exclusive sets	`[update, update_of]`
One of required sets	`[insert, delete, truncate, update, update_of]`

`trigger.annotation`

`trigger.annotation` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Allow unknown blocks	`true`
Allow unknown attributes	`true`

`trigger.before`

`trigger.before` attributes

Name	Required	Value
`delete`	`false`	`bool`
`insert`	`false`	`bool`
`truncate`	`false`	`bool`
`update`	`false`	`bool`
`update_of`	`false`	Trigger update_of columns can be one of: List of object reference to `view.column` List of object reference to `table.column`

`trigger.before` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Mutually exclusive sets	`[update, update_of]`
One of required sets	`[insert, delete, truncate, update, update_of]`

`trigger.instead_of`

`trigger.instead_of` attributes

Name	Required	Value
`delete`	`false`	`bool`
`insert`	`false`	`bool`
`truncate`	`false`	`bool`
`update`	`false`	`bool`
`update_of`	`false`	Trigger update_of columns can be one of: List of object reference to `view.column` List of object reference to `table.column`

`trigger.instead_of` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Mutually exclusive sets	`[update, update_of]`
One of required sets	`[insert, delete, truncate, update, update_of]`

`trigger.referencing`

`trigger.referencing` attributes

Name	Required	Value
`new`	`false`	`string`
`old`	`false`	`string`
`parent`	`false`	`string`

`trigger.referencing` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Repeatable	`true`

`trigger` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `trigger "name"` )	`true`
Repeatable	`true`
Mutually exclusive sets	`[foreach, for]`, `[follows, precedes]`, `[before, after, instead_of]`, `[as, call]`
One of required sets	`[before, after, instead_of]`, `[as, call]`

`varray`

`varray` attributes

Name Required Value

limit true int

schema

true

Object reference to schema

type

true

Element type can be one of:

Schema type
Raw expression defined with sql("expr")
Object reference to object_type
Object reference to varray
Object reference to nested_table

`varray` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `varray "name"` )	`true`
Allow Qualifier (e.g., `varray "schema" "name"` )	`true`

`view`

The view block describes a view in a database schema.

view "clean_users" {
  schema = schema.public
  column "id" {
    type = int
  }
  ...
}

`view` attributes

Name	Required	Value
`as`	`true`	`string`
`comment`	`false`	`string`
`depends_on`	`false`	List of object references
`schema`	`true`	Object reference to `schema`

`view` blocks

`view.annotation`

`view.annotation` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Allow unknown blocks	`true`
Allow unknown attributes	`true`

`view.column`

`view.column` attributes

Name Required Value

comment false string

null false bool

type

true

Column type can be one of:

Schema type
Raw expression defined with sql("expr")
Object reference to object_type
Object reference to varray
Object reference to nested_table

`view.column` blocks

`view.column.annotation`

`view.column.annotation` constraints

Constraint	Value
Required	`false`
Require Name	`false`
Allow unknown blocks	`true`
Allow unknown attributes	`true`

`view.column` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `view.column "name"` )	`true`

`view` constraints

Constraint	Value
Required	`false`
Require Name (e.g., `view "name"` )	`true`
Allow Qualifier (e.g., `view "schema" "name"` )	`true`

data
- data attributes
database_link
function
index_type
nested_table
- nested_table attributes
- nested_table constraints
object_type
operator
permission
- permission attributes
- permission constraints
procedure
role
schema
sequence
synonym
- synonym attributes
- synonym constraints
table
trigger
varray
- varray attributes
- varray constraints
view

data​

data attributes​

database_link​

database_link attributes​

database_link blocks​

database_link.authenticated_by​

database_link.authenticated_by attributes​

database_link.connect​

database_link.connect attributes​

database_link.connect constraints​

database_link constraints​

function​

function attributes​

function blocks​

function.annotation​

function.annotation constraints​

function.arg​

function.arg attributes​

function.arg constraints​

function constraints​

index_type​

index_type attributes​

index_type blocks​

index_type.operator​

index_type.operator attributes​

index_type.operator constraints​

index_type constraints​

nested_table​

nested_table attributes​

nested_table constraints​

object_type​

object_type attributes​

object_type blocks​

object_type.attribute​

object_type.attribute attributes​

object_type.attribute constraints​

object_type.constructor​

object_type.constructor attributes​

object_type.constructor blocks​

object_type.constructor.arg​

object_type.constructor.arg attributes​

object_type.constructor.arg constraints​

object_type.constructor.self​

object_type.constructor.self attributes​

object_type.function​

object_type.function attributes​

object_type.function blocks​

object_type.function.annotation​

object_type.function.annotation constraints​

object_type.function.arg​

object_type.function.arg attributes​

object_type.function.arg constraints​

object_type.function.self​

object_type.function.self attributes​

object_type.function constraints​

object_type.map​

object_type.map attributes​

object_type.map blocks​

object_type.map.arg​

object_type.map.arg attributes​

object_type.map.arg constraints​

object_type.map.self​

object_type.map.self attributes​

object_type.map constraints​

object_type.order​

object_type.order attributes​

object_type.order blocks​

object_type.order.arg​

object_type.order.arg attributes​

object_type.order.arg constraints​

object_type.order.self​

object_type.order.self attributes​

object_type.order constraints​

object_type.procedure​

object_type.procedure attributes​

object_type.procedure blocks​

object_type.procedure.annotation​

object_type.procedure.annotation constraints​

object_type.procedure.arg​

object_type.procedure.arg attributes​

`data`

`data` attributes

`database_link`

`database_link` attributes

`database_link` blocks

`database_link.authenticated_by`

`database_link.authenticated_by` attributes

`database_link.connect`

`database_link.connect` attributes

`database_link.connect` constraints

`database_link` constraints

`function`

`function` attributes

`function` blocks

`function.annotation`

`function.annotation` constraints

`function.arg`

`function.arg` attributes

`function.arg` constraints

`function` constraints

`index_type`

`index_type` attributes

`index_type` blocks

`index_type.operator`

`index_type.operator` attributes

`index_type.operator` constraints

`index_type` constraints

`nested_table`

`nested_table` attributes

`nested_table` constraints

`object_type`

`object_type` attributes

`object_type` blocks

`object_type.attribute`

`object_type.attribute` attributes

`object_type.attribute` constraints

`object_type.constructor`

`object_type.constructor` attributes

`object_type.constructor` blocks

`object_type.constructor.arg`

`object_type.constructor.arg` attributes

`object_type.constructor.arg` constraints

`object_type.constructor.self`

`object_type.constructor.self` attributes

`object_type.function`

`object_type.function` attributes

`object_type.function` blocks

`object_type.function.annotation`

`object_type.function.annotation` constraints

`object_type.function.arg`

`object_type.function.arg` attributes

`object_type.function.arg` constraints

`object_type.function.self`

`object_type.function.self` attributes

`object_type.function` constraints

`object_type.map`

`object_type.map` attributes

`object_type.map` blocks

`object_type.map.arg`

`object_type.map.arg` attributes

`object_type.map.arg` constraints

`object_type.map.self`

`object_type.map.self` attributes

`object_type.map` constraints

`object_type.order`

`object_type.order` attributes

`object_type.order` blocks

`object_type.order.arg`

`object_type.order.arg` attributes

`object_type.order.arg` constraints

`object_type.order.self`

`object_type.order.self` attributes

`object_type.order` constraints

`object_type.procedure`

`object_type.procedure` attributes

`object_type.procedure` blocks

`object_type.procedure.annotation`

`object_type.procedure.annotation` constraints

`object_type.procedure.arg`

`object_type.procedure.arg` attributes