Table Data dictionary report - jobs

Generated: 2018-10-18 7:23:02 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Jobs

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('jobs_id_seq'::regclass) Unique identifier
job_no character varying(10) No No Job number as set by user
account character varying(10) No No Job account as set by user - blank for Job header record
name character varying(60) No No Job account name or description
start_date date No No Start date as set by user
end_date date No No End date as set by user
trans_flag boolean No No
memo character varying(60) No No Reference as set by user
status character varying(1) No No Job status; A = Active C = Completed H = Hold
ranking numeric(5) No No Rank as set by user
contract_no character varying(10) No No Contract number
contract_date date No No Contract date
estimator character varying(60) No No Job estimator
estimated_income numeric(15,2) No No Estimated Income or Revenue
actual_income numeric(15,2) No No Actual Income or Revenue
estimated_expense numeric(15,2) No No Estimated Expenses
actual_expense numeric(15,2) No No Actual Expenses
actual_hours numeric(9,2) No No Actual hours
estimated_hours numeric(9,2) No No Estimated hours
last_refno character varying(10) No No Last billing number
_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

Constraints

Name Type Definition Comment
job_header_pkey Primary key (id)

Report generated by pgAdmin3 LTS by BigSQL