 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';
-comment on column specimen_parts.category is 'Type of specimen encoded: a physical object stored in collections, an observation, a figurate specimen,...';
 
 create sequence insurances_id_seq;
 

        specimen_status varchar not null default 'good state',
        specimen_part_count_min integer not null default 1,
        specimen_part_count_max integer not null default 1,
        category varchar not null default 'physical',
        constraint pk_specimen_parts primary key (id),
        constraint fk_specimen_parts_specimen_individuals foreign key (specimen_individual_ref) references specimen_individuals(id) on delete cascade,
        constraint chk_chk_specimen_parts_minmax check (specimen_part_count_min <= specimen_part_count_max),

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