Table Data dictionary report - inventory_kit_items

Generated: 9/23/2016 2:44:28 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_items_id_seq'::regclass)
sequence integer No No Sequence number from 1 to the quantity of components in the kit
whse character varying(6) No No Warehouse for the component of the kit
part_no character varying(34) No No Part number for the component of the kit
description character varying(80) No No Description for the component of the kit
qty numeric(15,5) No No Quantity for this component of the kit
uom_usage character varying(10) No No Unit of measure used for the component.
cost numeric(15,5) No No The cost of the component
_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
kit_id integer Yes No The ID that this kit links to in table inventory_kits_id

Constraints

Name Type Definition Comment
bom_sub_level_pkey Primary key (id)
inventory_kit_items_kit_id_fkey Foreign key (kit_id) REFERENCES inventory_kits (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE
bom_items_bom_id_sequence_key Unique (kit_id, sequence) DEFERRABLE INITIALLY IMMEDIATE

Report generated by pgAdmin III