Technical data

Database Object Standard

Database Design 3-3

• Use the suffix FLG to define a lookup table field. Flag columns must be CHAR(4). Choose

lookup field names carefully as these column names are defined in the lookup table

(CI_LOOKUP_FLD) and must be prefixed by the product owner flag value.

• Use the suffix CD to define user-defined codes. User-defined codes are primarily found as

the key column of the admin tables.

• Use the suffix ID to define system assigned key columns.

• Use the suffix SW to define Boolean columns. The valid values of the switches are 'Y' or 'N'.

The switch columns must be CHAR(1)

• Use the suffix DT to define Date columns.

• Use the suffix DTTM to define Date Time columns.

• Use the suffix TM to define Time columns.

Some examples are:

• ADJ_STATUS_FLG

• CAN_RSN_CD

Indexes

Index names are composed of the following parts:

[OF][application specific prefix][C/M/T]NNN[P/S]n

• OF- Owner Flag. Prior to Version 4.1.0 of the framework the leading character of the base

Owner Flag was used. From 4.1.0 on the first two characters of product’s owner flag value

should be used. For client specific implementation of index, use CM for Owner Flag.

• Application specific prefix could be C, F, T or another letter.

• C/M/T - The second character can be either C or M or T. C is used for control tables

(Admin tables). M is for the master tables. T is reserved for the transaction tables.

• NNN - A three-digit number that uniquely identifies the table on which the index is defined.

• P/S - P indicates that this index is the primary key index. S is used for indexes other than

primary keys.

• n is the index number, unique across all indexes on a given table (0 for primary and 1, 2, etc.,

for the secondary indexes).

Some examples are:

• F1C066P0

• F1C066S1

• CMT206S2

Warning! Do not use index names in the application as the names can change

due to unforeseeable reasons.

Updating Storage.xml

The storage.xml file that comes with the product allocates all base tables and indexes to the default

tablespace CISTS_01. If you decide to allocate some tables or indexes outside of the default

tablespace, then this has to be reflected in the storage.xml file by changing the tablespace name

from the default value to a custom value, according to the format shown below:

Format:

<Table_Name>

<TABLESPACE>CISTS_01</TABLESPACE>