Databases Reference
In-Depth Information
Object Type
Object Type Suffix
Example
Comment
IDX
Index
Regular index on the column
BOOK BOOKED FROM
in the table
FM BOOKINGS
:
BOOK BOOKED FROM IDX
FIDX
Index (Function
Based)
Function based index
(
upper(con title)
) on the column
CON TITLE
in the table
FM COUNTRIES
:
CON TITLE FIDX
MV
Materialized View
Materialized view on the bookings
to aggregate some results:
FM BOOKINGS MV
<no suffix>
Package
Interface to create and update
bookings:
FM BOOKING
For true API interfaces
(functions, procedures,
packages) we don't use a
suffix.
PK
FM USERS PK
Primary Key
<no suffix>
Procedure
Custom function to write logging
information:
XLOG
For true API interfaces
(functions, procedures,
packages) we don't use a
suffix.
SEQ
FM ID SEQ
FM LOG ID SEQ
Sequence
<no suffix>
Synonym
Synonyms don't use a
type suffix; their names
are identical to the
objects they refer to.
<no suffix>
Table
The bookings table:
FM BOOKINGS
Tables use no explicit
suffix; their names are
written in plural.
