Table Data dictionary report - system_users_base

Generated: 2018-10-18 8:09:59 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for User list

Columns

Name Data type Not Null? Primary key? Default Comment
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

Constraints

Name Type Definition Comment
users_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL