database.dtd
: Elements - Entities - Source | Intro - Index
FRAMES / NO FRAMES
Copyright 2011 Ziminji
Copyright 2007 Apache Software Foundation (ASF)
Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at:
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
<database> | Root element |
This defines the database
element as the root element.
Element's model:
<database>'s children Name Cardinality index Any number table Any number trigger Any number view Any number
<database>'s attributes Name Values Default description name
(index*, table*, trigger*, view*)
@name | Attribute of database |
This defines the database
element's attributes.
Required
@description | Attribute of database |
This defines the database
element's attributes.
<index> | Child of database |
This defines a index
element, which is a child of the database
element.
Element's model:
<index>'s children Name Cardinality column At least one
<index>'s attributes Name Values Default description name table unique true, false false
(column+)
@name | Attribute of index |
This defines a index
element's attributes.
Required
@description | Attribute of index |
This defines a index
element's attributes.
@table | Attribute of index |
This defines a index
element's attributes.
Required
@unique | Attribute of index |
This defines a index
element's attributes.
Possible values: true, false - Default value: false
<table> | Child of database |
This defines a table
element, which is a child of the database
element.
Element's model:
<table>'s children Name Cardinality column At least one foreign-key Any number
<table>'s attributes Name Values Default description name temporary true, false false
(column+, foreign-key*)
@name | Attribute of table |
This defines a table
element's attributes.
Required
@description | Attribute of table |
This defines a table
element's attributes.
@temporary | Attribute of table |
This defines a table
element's attributes.
Possible values: true, false - Default value: false
<trigger> | Child of database |
This defines a trigger
element, which is a child of the database
element.
Element's model:
<trigger>'s children Name Cardinality action At least one column Any number when Any number
<trigger>'s attributes Name Values Default advice before, after, instead-of description event delete, insert, update name table temporary true, false false
@name | Attribute of trigger |
This defines a trigger
element's attributes.
Required
@description | Attribute of trigger |
This defines a trigger
element's attributes.
@temporary | Attribute of trigger |
This defines a trigger
element's attributes.
Possible values: true, false - Default value: false
@advice | Attribute of trigger |
This defines a trigger
element's attributes.
Possible values: before, after, instead-of - Required
@event | Attribute of trigger |
This defines a trigger
element's attributes.
Possible values: delete, insert, update - Required
@table | Attribute of trigger |
This defines a trigger
element's attributes.
Required
<view> | Child of database |
This defines a view
element, which is a child of the database
element. This
element contains an SQL select statement in a CDATA block.
<view>'s attributes Name Values Default description name temporary true, false false
@name | Attribute of view |
This defines a view
element's attributes.
Required
@description | Attribute of view |
This defines a view
element's attributes.
@temporary | Attribute of view |
This defines a view
element's attributes.
Possible values: true, false - Default value: false
<action> | Child of trigger |
This defines a action
element, which is a child of the trigger
element.
This element contains an SQL select statement in a CDATA block.
<column> | Child of trigger, index, table |
This defines a column
element, which is a child of either the index
element,
the table
element, or the trigger
element.
Element's model:
<column>'s children Name Cardinality EMPTY
<column>'s attributes Name Values Default auto-increment true, false default description key primary, unique name nullable true, false order ASC, DESC ASC scale size type BINARY, BLOB, VARBINARY, CHAR, CHARACTER, CLOB, NATIONAL_VARYING_CHARACTER, NATIVE_CHARACTER, NCHAR, NVARCHAR, TEXT, VARCHAR, VARYING_CHARACTER, DATE, DATETIME, TIME, TIMESTAMP, BIGINT, BIT, BOOL, BOOLEAN, INT, INT2, INT8, INTEGER, MEDIUMINT, SMALLINT, TINYINT, NULL, DECIMAL, DOUBLE, DOUBLE_PRECISION, FLOAT, NUMERIC, REAL NUMERIC unsigned true, false
()
@name | Attribute of column |
This defines a column
element's attributes.
Required
@description | Attribute of column |
This defines a column
element's attributes.
@type | Attribute of column |
This defines a column
element's attributes.
Possible values: BINARY, BLOB, VARBINARY, CHAR, CHARACTER, CLOB, NATIONAL_VARYING_CHARACTER, NATIVE_CHARACTER, NCHAR, NVARCHAR, TEXT, VARCHAR, VARYING_CHARACTER, DATE, DATETIME, TIME, TIMESTAMP, BIGINT, BIT, BOOL, BOOLEAN, INT, INT2, INT8, INTEGER, MEDIUMINT, SMALLINT, TINYINT, NULL, DECIMAL, DOUBLE, DOUBLE_PRECISION, FLOAT, NUMERIC, REAL - Default value: NUMERIC
@unsigned | Attribute of column |
This defines a column
element's attributes.
Possible values: true, false
@size | Attribute of column |
This defines a column
element's attributes.
@scale | Attribute of column |
This defines a column
element's attributes.
@default | Attribute of column |
This defines a column
element's attributes.
@nullable | Attribute of column |
This defines a column
element's attributes.
Possible values: true, false
@key | Attribute of column |
This defines a column
element's attributes.
Possible values: primary, unique
@auto-increment | Attribute of column |
This defines a column
element's attributes.
Possible values: true, false
@order | Attribute of column |
This defines a column
element's attributes.
Possible values: ASC, DESC - Default value: ASC
<when> | Child of trigger |
This defines a when
element, which is a child of the trigger
element.
Element's model:
<when>'s children Name Cardinality EMPTY
<when>'s attributes Name Values Default operand-1 operand-2 operator
()
@operand-1 | Attribute of when |
This defines a when
element's attributes.
Required
@operator | Attribute of when |
This defines a when
element's attributes.
Required
@operand-2 | Attribute of when |
This defines a when
element's attributes.
Required
<foreign-key> | Child of table |
This defines a foreign-key
element, which indicates a relation between the table
this element is declared and another table.
Element's model:
<foreign-key>'s children Name Cardinality reference At least one
<foreign-key>'s attributes Name Values Default description foreign-table name on-delete cascade, setnull, restrict, none none on-update cascade, setnull, restrict, none none
(reference+)
@name | Attribute of foreign-key |
This defines a foreign-key
element's attributes.
Required
@description | Attribute of foreign-key |
This defines a foreign-key
element's attributes.
@foreign-table | Attribute of foreign-key |
This defines a foreign-key
element's attributes.
Required
@on-update | Attribute of foreign-key |
This defines a foreign-key
element's attributes.
Possible values: cascade, setnull, restrict, none - Default value: none
@on-delete | Attribute of foreign-key |
This defines a foreign-key
element's attributes.
Possible values: cascade, setnull, restrict, none - Default value: none
<reference> | Child of foreign-key |
This defines a reference
element. A foreign key is specified by one or more
references which put a column in the current table and a column in the foreign table into
relation.
Element's model:
<reference>'s children Name Cardinality EMPTY
<reference>'s attributes Name Values Default foreign local
()
@local | Attribute of reference |
This defines a reference
element's attributes.
Required
@foreign | Attribute of reference |
This defines a reference
element's attributes.
Required