ARM_FREQUENCIES

This table stores the frequencies defined by the user.

Details

Object type: TABLE

Primary Key

Name Columns

ARM_FREQUENCIES_PK

FREQUENCY_ID

Columns

Name Data Type Length Precision Scale Null Allowed Comments

FREQUENCY_ID

NUMBER

 

18

0

No

The unique ID of the frequency

FREQUENCY_NAME

VARCHAR2

180

   

No

The name of the frequency

FREQUENCY_ORDER

NUMBER

 

18

0

Yes

Order of frequency

OBJECT_VERSION_NUMBER

NUMBER

 

9

0

No

Used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

LAST_UPDATE_LOGIN

NUMBER

     

Yes

Who column. Stores the login/session ID of the user who last updated this row.

LAST_UPDATED_BY

VARCHAR2

255

   

No

Who column. Stores the ID of the user who last updated this row.

LAST_UPDATE_DATE

DATE

     

No

Who column. Stores the date when this row was last updated.

CREATED_BY

VARCHAR2

255

   

No

Who column. Stores the ID of the user who created this row.

CREATION_DATE

DATE

     

No

Who column. Stores the date when this row was created in the database.

Indexes

Index Uniqueness Columns

ARM_FREQUENCIES_PK

UNIQUE

FREQUENCY_ID