- id => { type => 'integer', not_null => 1, sequence => 'id' },
- partnumber => { type => 'text', not_null => 1 },
- description => { type => 'text' },
- listprice => { type => 'numeric', precision => 5, scale => 15 },
- sellprice => { type => 'numeric', precision => 5, scale => 15 },
- lastcost => { type => 'numeric', precision => 5, scale => 15 },
- priceupdate => { type => 'date', default => 'now' },
- weight => { type => 'float', precision => 4 },
- notes => { type => 'text' },
- makemodel => { type => 'boolean', default => 'false' },
- assembly => { type => 'boolean', default => 'false' },