Database Attributes

The sub form shows database atributes of fields in tables or fields in views. Modification is only possible in the sublists table fields.

Path name of a tables field
Index 1-3 field index
Uniqueness 1-3 uniqueness flag
Foreign key foreign key flag
Non Zero non-zero flag
Group grouping for View
Mode search mode

Sequence position number of the field in the table

Path

Name of the origin tables`s field to the view field

attribute master attribute for field (T_FIELD)
type, entry string, display only
max. no. of characters 255
selection tool no
multilingual field no

Display for View fields:

TABELLENNAME.SPALTENNAME>VIEWNAME1.SPALTENNAME>... >VIEWNAMEn.SPALTENNAME

Index 1-3

Index for table field

attribute master attribute for field (T_FIELD)
type, entry string, display only
max. no. of characters 13
selection tool no
multilingual field no

Anzeige für indizierte Felder:

INDEXNAME

Uniqueness 1-3

Uniqueness flag

attribute master attribute for field (T_FIELD)
type, entry string, display only
max. no. of characters 1
selection tool no
multilingual field no

Display for for fields in master tables:

G -> globally unique
All records in the master table are unique

- -> not unique (default)

Display for fields in relation tables:

G -> globally unique
All records in the master table are unique

1 -> Id-1 unique
partial uniqueness for all relation records with same parent element ( the unique field and C-ID1 represent a combined key)

2 -> Id-2 unique
partial uniqueness for all relation records with same child element (the unique field and C-ID2 represent a combined key)

R -> Id-1/2 unique
partial uniqueness for all relation records with same parent element and same child element (the unique field, C_ID1 and C_ID2 represent a combined key)

- -> not unique (default)

Display for fields in Type Tables

G -> globally unique
All records in the type table are unique

2 -> Id-2 unique
partial uniquess for all type`s record with the same parent element (unique field C_ID2 represent a combined key)

- -> not unique (default)

Foreign Key (flag)

Foreign key flag

attribute master attribute for field (T_FIELD)
type, entry logical, display only
max. no. of characters 1
selection tool no
multilingual field no

Entry:

Not set :
The field is not a foreign field

Set
The field is a foreign field

Non Zero (N)

Non-zero flag

attribute master attribute for field (T_FIELD)
type, entry logical
max. no. of characters 1
selection tool no
multilingual field no

Entry:

Not set (default)
a NULL entry is possible

Set
an entry is forced (field's Access is m = mandatory)

Group

Groups only apply in views

attribute master attribute for field (T_FIELD)
type, entry logic
max. no. of characters 1
selection tool no
multilingual field no

Identification for View fields when it si assorted.

Mode

Search mode for a table field

attribute master attribute for field (T_FIELD)
type, entry string, display only
max. no. of characters 1
selection tool no
multilingual field no

Entry:

(empty)
no case sensitivity (default)

I -> insensitive
alphabetical case is ignored

S -> sensitive
alphabetical case is considered

Sequence

A field's numerical position in a table or view

attribute master attribute for field (T_FIELD)
type, entry integer, display only
max. no. of characters 5
selection tool no
multilingual field no