Table Data dictionary report - job_items

Generated: 9/23/2016 2:53:13 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('job_items_id_seq'::regclass)
job_no character varying(10) No No
account character varying(10) No No
date date No No
folio character varying(10) No No
recno integer No No
where_from character varying(4) No No
jcd_user character varying(3) No No
mf_who character varying(10) No No
mf_key character varying(20) No No
mf_tran character varying(25) No No
post_date date No No
tran_date date No No
exp_amt numeric(15,2) No No
inc_amt numeric(15,2) No No
hrs_amt numeric(9,2) No No
_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
gl_memo character varying(60) No No

Constraints

Name Type Definition Comment
job_detail_pkey Primary key (id)

Report generated by pgAdmin III