dictionary_banner (2K)

dict_table_key(enq1) - Enquire Key

dict_table_key(enq1) (15K)

The purpose of this form is to allow the user to view the detials of an entry on the DICT_TABLE_KEY table of the dictionary database.

This form is accessed by an option on the navigation bar in the List Key screen.

For a complete description of how this type of form works please see Transaction Pattern ENQUIRE 1.

Note that all values are set when the table details are imported and cannot be changed once they are within the dictionary.

Field List
Field NameTypeDescription
database_id STRING The name of the database.
table_id STRING The name of the table.
key_name STRING As a table can have more than one key each one requires a unique identifier. The primary key is given the name 'PRIMARY'.
column_id STRING This is the name column that appears within this key. A column may appear only once in any key, but it may appear in more than key for the same table.
seq_in_index NUMERIC A key may be comprised of more than one column, so this is the sequence number of this column within the key.
is_unique BOOLEAN Keys may be unique or non-unique. This identifies if the key is unique or not.
column_seq NUMERIC This is the sequence number of the entry returned by the SHOW INDEX statement which was issued to the database.
The following fields are set automatically by the system:
created_date DATE+TIME The date and time on which this record was created.
created_user STRING The identity of the USER who created this record.
revised_date DATE+TIME The date and time on which this record was last changed.
revised_user STRING The identity of the USER who last changed this record.

http://www.tonymarston.net
http://www.radicore.org