Table Data dictionary report - inventory_components

Generated: 2018-10-18 6:19:25 AM
Server: PostgreSQL 9.3 (localhost:5432)
Database: datadict_donotremove
Schema: public
Notes:

Table for Kit and Macro Inventory components

Columns

Name Data type Not Null? Primary key? Default Comment
id integer Yes Yes nextval('bom_items_id_seq'::regclass) Unique identifier
sequence integer No No Sequential line number
whse character varying(6) No No Component warehouse - links to inventory.whse
part_no character varying(34) No No Component Part number - links to inventory.part_no
description character varying(80) No No Component description from inventory.description
qty numeric(15,5) No No Component quantity for this item
uom_usage character varying(10) No No Unit of measure used for the component
cost numeric(15,5) No No Not used
_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 Date and time this record was last modified
_modified_by character varying(3) No No UTC User initials that last modified this record
parent_id integer Yes No The inventory.id of the parent item for this group of components - links to inventory.id
inventory_id integer No No The inventory.id of this item - links to inventory.id
price numeric(15,5) No No Not used

Constraints

Name Type Definition Comment
bom_sub_level_pkey Primary key (id)
inventory_components_inventory_id_fkey Foreign key (inventory_id) REFERENCES public.inventory (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION
inventory_components_parent_id_fkey Foreign key (inventory_id) REFERENCES public.inventory (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE

Report generated by pgAdmin3 LTS by BigSQL