| id |
integer |
Yes |
Yes |
nextval('system_users_id_seq'::regclass) |
Unique identifier |
| username |
character varying(12) |
No |
No |
|
Logon user name |
| initials |
character varying(3) |
No |
No |
|
User initials |
| default_whse |
character varying(6) |
Yes |
No |
|
Default warehouse for user |
| division |
character varying(3) |
Yes |
No |
|
Default division for user |
| default_salesperson |
character varying(10) |
Yes |
No |
|
Default salesperson for user |
| _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 |
| udf_data |
hstore |
No |
No |
''::hstore |
User defined data for this record |
| uuid |
uuid |
Yes |
No |
|
Universal unique identifier for user |