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 |
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 |