 comment on column specimens.mineral_ref is 'Reference of a mineral classification unit associated to the specimen encoded - id field of mineralogy table';
 comment on column specimens.host_taxon_ref is 'Reference of taxon definition defining the host which holds the current specimen - id field of taxonomy table';
 comment on column specimens.ig_ref is 'Reference of ig number this specimen has been associated to';
+comment on column specimens.category is 'Type of specimen encoded: a physical object stored in collections, an observation, a figurate specimen,...';
 
 create sequence codes_id_seq;
 

create table specimens
       (
        id integer not null default nextval('specimens_id_seq'),
        collection_ref integer not null default 0,
        expedition_ref integer not null default 0,
        gtu_ref integer not null default 0,

comment on column specimen_parts.specimen_part_count_min is 'Minimum number of parts/individuals';
comment on column specimen_parts.specimen_part_count_max is 'Maximum number of parts/individuals';
comment on column specimen_parts.complete is 'Flag telling if part/specimen is complete or not';

create sequence insurances_id_seq;

