Previous Topic: Active_Boolean_Table TableNext Topic: admin_tree Table


Active_Reverse_Boolean_Table Table

Table to translate 0 and 1 for the del field on records.

Field

Data Type

Reference

Remarks

del

INTEGER NOT_NULL

 

0—Active

1—Inactive/marked as deleted

description

STRING 240

 

Specifies the textual description of this boolean value

enum

INTEGER NOT_NULL

 

Enumerated value for this entry

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID

last_mod_dt

LOCAL_TIME

 

Indicates the timestamp of when this record was last modified

sym

STRING 12 S_KEY