Table Data dictionary report - system_users

Generated: 9/23/2016 3:10:53 PM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict
Schema: public

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('system_users_id_seq'::regclass)
username character varying(12) No No User name
firstname character varying(60) No No First name
lastname character varying(60) No No Last name
initials character varying(3) No No Initials
password character varying(128) No No Password
active boolean No No Active TRUE = Yes False = No
default_whse character varying(6) No No Users default warehouse
division character varying(3) No No Users default division
default_salesperson character varying(10) No No Users default salesperson
_dbversion integer No No
_created timestamp without time zone No No
_created_by character varying(3) No No
_modified timestamp without time zone No No
_modified_by character varying(3) No No
udf_data hstore No No ''::hstore hstore field containing user defined data

Constraints

Name Type Definition Comment
users_pkey Primary key (id)

Report generated by pgAdmin III