Oihana Php Schema

Index

Property keys mapped to the columns of the OpenEdge SQL `SYSINDEXES` system catalog table.

SYSINDEXES contains one row for each (index, indexed-column) pair. The idxseq column gives the ordinal position of the column inside the index.

ABBREVIATE : string = 'abbreviate': Whether the index entry is stored in abbreviated form (`abbreviate`).
ASC_DESC : string = 'ascDesc': Sort direction of the indexed column: ascending or descending (`asc_desc`).
COLUMN : string = 'column': Indexed column name (`fldname` or `col` depending on revision).
FIELD_NUMBER : string = 'fieldNumber': Ordinal field number within the index definition (`fld_no`).
INDEX_OWNER : string = 'indexOwner': Owner (SQL schema) of the index itself (`idxowner`).
INDEX_SEQUENCE : string = 'indexSequence': Sequence (rank) of the column inside the index (`idxseq`).
INDEX_TYPE : string = 'indexType': Index type discriminator (`idxtype`): `U` for unique, `D` for duplicates.
NUMBER_OF_COMPONENTS : string = 'numberOfComponents': Total number of indexed components (`numcomp`).
PRIMARY : string = 'primary': Whether this index is the primary index of the table.
TABLE : string = 'table': Owning table of the index.
UNIQUE : string = 'unique': Whether the index enforces uniqueness (`unique`).

Whether the index entry is stored in abbreviated form (`abbreviate`).


    public
        string
    ABBREVIATE
    = 'abbreviate'

Sort direction of the indexed column: ascending or descending (`asc_desc`).


    public
        string
    ASC_DESC
    = 'ascDesc'

Indexed column name (`fldname` or `col` depending on revision).


    public
        string
    COLUMN
    = 'column'

Ordinal field number within the index definition (`fld_no`).


    public
        string
    FIELD_NUMBER
    = 'fieldNumber'

Owner (SQL schema) of the index itself (`idxowner`).


    public
        string
    INDEX_OWNER
    = 'indexOwner'

Sequence (rank) of the column inside the index (`idxseq`).


    public
        string
    INDEX_SEQUENCE
    = 'indexSequence'

Index type discriminator (`idxtype`): `U` for unique, `D` for duplicates.


    public
        string
    INDEX_TYPE
    = 'indexType'

Total number of indexed components (`numcomp`).


    public
        string
    NUMBER_OF_COMPONENTS
    = 'numberOfComponents'

Whether this index is the primary index of the table.


    public
        string
    PRIMARY
    = 'primary'

Owning table of the index.


    public
        string
    TABLE
    = 'table'

Whether the index enforces uniqueness (`unique`).


    public
        string
    UNIQUE
    = 'unique'