Table Data dictionary report - phases

Generated: 9/23/2016 2:56:58 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('phases_id_seq'::regclass)
phase_type character varying(4) No No ''::character varying Phase type SORD = Sales order PORD = Purchae Order BORD = Production Order
phase_id character varying(20) No No ''::character varying ID for the phase
phase_desc character varying(100) No No ''::character varying Description of the phase
report_tmpl character varying(20) No No ''::character varying Crystal report template used when order enters this phase.
_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
next_phases character varying(20)[] Yes No '{"","","","","","","","","",""}'::character varying[] The phase ID that this phase goes to next.

Constraints

Name Type Definition Comment
bve_phase_pkey Primary key (id)

Report generated by pgAdmin III