email text,

    partytype text,

    partypublic int(1) DEFAULT true,

    accessioncode text

);

    commname_id int(11) NOT NULL,

    reference_id int(11),

    commdescription text,

    commname text,

    accessioncode text

);

    projectdescription text,

    startdate date,

    stopdate date,

    accessioncode text

);

    email text,

    partytype text,

    partypublic boolean DEFAULT true,

    accessioncode text,

    CONSTRAINT party_required_key CHECK (((organizationname IS NOT NULL) OR ((reference_id <> party_id) AND ((fullname IS NOT NULL) OR (surname IS NOT NULL)))))

);

    commname_id integer NOT NULL,

    reference_id integer,

    commdescription text,

    commname text,

    accessioncode text

);

    projectdescription text,

    startdate date,

    stopdate date,

    accessioncode text,

    CONSTRAINT project_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (projectname IS NOT NULL)))

);