Table Data dictionary report - bom_item_replacements

Generated: 9/23/2016 2:29:37 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('bom_item_replacements_id_seq'::regclass)
status character varying(1) No No
uuid character varying(36) No No
old_whse character varying(6) No No Warehouse for old part number
old_part_no character varying(34) No No Old part number
new_whse character varying(6) No No Warehouse for new part number
new_part_no character varying(34) No No New part number
update_bom boolean No No Flag for whether to update template TRUE = Yes FALSE = No
update_bo boolean No No Flag for whether to update production orders TRUE = Yes FALSE = No
include_allocated boolean No No Flag for whether to update allocated production orders TRUE = Yes FALSE = 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

Constraints

Name Type Definition Comment
bve_replace_components_pkey Primary key (id)

Report generated by pgAdmin III