| key |
character varying(128) |
Yes |
No |
|
Key for setting to control on this record |
| type |
smallint |
No |
No |
|
Internal use |
| num_data |
bigint |
No |
No |
|
Large number to store on this record |
| curr_data |
numeric(15,5) |
No |
No |
|
Decimal numeric data to store on this record |
| txt_data |
character varying(255) |
No |
No |
|
Text data to store on this record |
| _dbversion |
integer |
No |
No |
|
Program version that last modified this record |
| _created |
timestamp without time zone |
No |
No |
|
UTC Date and time record was created |
| _created_by |
character varying(3) |
No |
No |
|
User initials that created this record |
| _modified |
timestamp without time zone |
No |
No |
|
UTC Date and time this record was last modified |
| _modified_by |
character varying(3) |
No |
No |
|
User initials that last modified this record |
| id |
integer |
Yes |
Yes |
nextval('system_settings_id_seq'::regclass) |
Unique identifier |
| user_id |
integer |
No |
No |
|
Identifier from system_users_base.id related to this record |