Table Data dictionary report - jobs

Generated: 9/23/2016 2:54:17 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('jobs_id_seq'::regclass)
job_no character varying(10) No No
account character varying(10) No No
name character varying(60) No No
start_date date No No
end_date date No No
trans_flag boolean No No
memo character varying(60) No No
status character varying(1) No No
ranking numeric(5) No No
contract_no character varying(10) No No
contract_date date No No
estimator character varying(60) No No
estimated_income numeric(15,2) No No
actual_income numeric(15,2) No No
estimated_expense numeric(15,2) No No
actual_expense numeric(15,2) No No
actual_hours numeric(9,2) No No
estimated_hours numeric(9,2) No No
last_refno character varying(10) 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
udf_data hstore No No ''::hstore

Constraints

Name Type Definition Comment
job_header_pkey Primary key (id)

Report generated by pgAdmin III