Files > SQLI_TABLE_ELEMENT

name
SQLI_TABLE_ELEMENT
number
1.5216
location
^DMSQ("E",
description
Names and domains of primary keys, columns and foreign keys. Each represents the relational concept of an attribute, whose essential charactaristics are a name (unique by relation) and a domain. See SQLI_PRIMARY_KEY, SQLI_COLUMN and SQLI_FOREIGN key for more.
Fields
#NameLocationTypeDetailsIndexDescription
.01e name(+)0;1FREE TEXTBName of table element. Foreign keys are suffixed _FK or PFK. Primary keys are suffixed _PK.
1e domain(+)0;2POINTER1.5212CIEN of domain in SQLI_DOMAIN
2e table(+)0;3POINTER1.5215DIEN of table in SQLI_TABLE. Required.
3e type(+)0;4SET OF CODESC:Column
P:Primary key
F:Foreign key
EC for column, P for primary key, or F for foreign key
4e comment0;5FREE TEXTA short description of the element

Referenced by 3 types

  1. SQLI_COLUMN (1.5217) -- c_table_element
  2. SQLI_PRIMARY_KEY (1.5218) -- p_tbl_element
  3. SQLI_FOREIGN_KEY (1.5219) -- f_tbl_element