Field

Data Type

Reference

Remarks

id

INTEGER

UNIQUE NOT_NULL KEY Unique to the table Numeric ID.

del

INTEGER

NOT_NULL Deleted flag:

0—Active

1—Inactive/marked as deleted

enum

INTEGER

NOT_NULL Enumerated value for this entry

0—False

1—True

sym

STRING 60

UNIQUE NOT_NULL S_KEY Identifies the symbolic value for this target

desc

STRING 40

Describes the enum