Table Data dictionary report - production_template_items

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

Table for Prodution Template component details

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('production_template_items_id_seq'::regclass) Unique identifier
template_id integer Yes No Link to production_templates.id
child_template_id integer No No Link to production.template_id for sub assemblies
sequence smallint No No Sequential number for order line
whse character varying(6) No No Inventory warehouse for this record - links to inventory.whse
part_no character varying(34) No No Inventory part number for this record - links to inventory.part_no
description character varying(80) No No Description of component
unit_qty numeric(15,5) No No Quantity required of this component to build 1 of the sub-assembly or assembly, 1 level abov
unit_cost numeric(15,5) No No Cost of the component
uom_usage character varying(10) No No Unit of Measure to use for this item
lead_time numeric(5) No No Lead time of the item as set by user
category character varying(6) No No Category assigned to this component - links to bom_categories.category
expected_scrap_pct numeric(5,2) No No Expected scrap percentage of the component
guid character varying(32) No No Uniique identifier for linking to production_order_items
vend_no character varying(20) No No Vendor code that will be used for Inventory Requisition
employee character varying(6) No No Employee number added to the line - links to employees.employee_no
revision character varying(8) No No The revision number set by user when the Template was last edited and saved
instructions text No No Component instruction notes
user_flag boolean No No
_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
parent_item_id integer No No Link to production_order_items.id for the parent of this record
udf_data hstore No No ''::hstore User defined data for this record

Constraints

Name Type Definition Comment
production_template_items_pkey Primary key (id)
production_template_items_child_template_fkey Foreign key (child_template_id) REFERENCES public.production_templates (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE SET NULL
production_template_items_parent_id_fkey Foreign key (template_id, parent_item_id) REFERENCES public.production_template_items (template_id, id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE
production_template_items_template_id_fkey Foreign key (template_id) REFERENCES public.production_templates (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE
production_template_items_template_id_id_key Unique (template_id, id)

Report generated by pgAdmin3 LTS by BigSQL