Table Data dictionary report - inventory_kits

Generated: 9/23/2016 2:45:02 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_id_seq'::regclass)
description character varying(80) No No Description for the kit
_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
udf_data hstore No No ''::hstore hstore field containing the user defined data
inventory_id integer Yes No The inventory ID that this item links to in table inventory.id

Constraints

Name Type Definition Comment
bom_top_level_pkey Primary key (id)
inventory_kits_inventory_id_fkey Foreign key (inventory_id) REFERENCES inventory (id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE CASCADE

Report generated by pgAdmin III