EDIT

      <mapping class="eu.etaxonomy.cdm.model.occurrence.MaterialOrMethodEvent"/>

      <mapping class="eu.etaxonomy.cdm.model.occurrence.MediaSpecimen"/>

      <mapping class="eu.etaxonomy.cdm.model.occurrence.OccurrenceStatus"/>

	private static final String dbSchemaVersion = CdmVersion.V_05_29_00.versionString;

        V_05_27_01("5.27.1.0.20210922"),

        V_05_29_00("5.29.0.0.20211122")

import javax.validation.constraints.NotNull;

import eu.etaxonomy.cdm.model.EntityCollectionSetterAdapter;

import eu.etaxonomy.cdm.model.EntityCollectionSetterAdapter.SetterAdapterException;

import eu.etaxonomy.cdm.model.reference.Reference;

import eu.etaxonomy.cdm.model.term.DefinedTerm;

    "specimenTypeDesignations",

    "status"

    @XmlElementWrapper(name = "OccurrenceStatuses")

    @XmlElement(name = "OccurrenceStatus")

    @OneToMany(fetch= FetchType.LAZY, mappedBy = "unit", orphanRemoval=true)

    @Cascade({CascadeType.SAVE_UPDATE, CascadeType.MERGE,CascadeType.DELETE})

    @NotNull

    @IndexedEmbedded(depth=1)

    private Set<OccurrenceStatus> status = new HashSet<>();

	//** Status **/

    /**

     * Returns the set of {@link OccurrenceStatus occurrence status} assigned

     * to <i>this</i> unit.

     * This includes the occurrence status type of the occurrence status.

     *

     * @see     OccurrenceStatus

     */

    public Set<OccurrenceStatus> getStatus() {

        if(status == null) {

            this.status = new HashSet<>();

        }

        return status;

    }

    /**

     * Adds a new {@link OccurrenceStatus occurrence status}

     * to <i>this</i> unit's set of occurrence status.

     *

     * @param  nomStatus  the occurrence status to be added

     * @see               #getStatus()

     */

    public void addStatus(OccurrenceStatus occStatus) {

        this.status.add(occStatus);

        if (!this.equals(occStatus.getUnit())){

            occStatus.setUnit(this);

        }

    }

    public OccurrenceStatus addStatus(DefinedTerm statusType, Reference citation, String microCitation) {

        OccurrenceStatus newStatus = OccurrenceStatus.NewInstance(statusType, citation, microCitation);

        addStatus(newStatus);

        return newStatus;

    }

    /**

     * Removes one element from the set of occurrence status of <i>this</i> unit.

     *

     * @param  occStatus  the occurrence status of <i>this</i> unit which should be deleted

     * @see               #getStatus()

     */

    public void removeStatus(OccurrenceStatus nomStatus) {

        //TODO to be implemented?

        logger.warn("not yet fully implemented?");

        this.status.remove(nomStatus);

    }

    public void setStatus(Set<OccurrenceStatus> nomStatus) throws SetterAdapterException {

        new EntityCollectionSetterAdapter<DerivedUnit, OccurrenceStatus>(DerivedUnit.class, OccurrenceStatus.class, "status", "addStatus", "removeStatus").setCollection(this, nomStatus);

    }

// ****************** METHODS ********************************************/

/**

* Copyright (C) 2007 EDIT

* European Distributed Institute of Taxonomy

* http://www.e-taxonomy.eu

*

* The contents of this file are subject to the Mozilla Public License Version 1.1

* See LICENSE.TXT at the top of this package for the full license terms.

*/

package eu.etaxonomy.cdm.model.occurrence;

import javax.persistence.Entity;

import javax.persistence.FetchType;

import javax.persistence.ManyToOne;

import javax.xml.bind.annotation.XmlAccessType;

import javax.xml.bind.annotation.XmlAccessorType;

import javax.xml.bind.annotation.XmlElement;

import javax.xml.bind.annotation.XmlIDREF;

import javax.xml.bind.annotation.XmlSchemaType;

import javax.xml.bind.annotation.XmlType;

import org.apache.log4j.Logger;

import org.hibernate.envers.Audited;

import eu.etaxonomy.cdm.model.common.SingleSourcedEntityBase;

import eu.etaxonomy.cdm.model.reference.Reference;

import eu.etaxonomy.cdm.model.term.DefinedTerm;

/**

 * The class representing the assignment of a occurrence status to a

 * {@link DerivedUnit derived unit}. This includes an {@link OccurrenceStatusType occurrence status type}

 * (for instance "destroyed", "lost" or "not seen by ...").

 *

 * @author m.doering

 * @since 08-Nov-2007 13:06:39

 */

@XmlAccessorType(XmlAccessType.FIELD)

@XmlType(name = "OccurrenceStatus", propOrder = {

    "unit",

    "type"

})

@Entity

@Audited

public class OccurrenceStatus

        extends SingleSourcedEntityBase {

    private static final long serialVersionUID = 623891726208046243L;

    private static Logger logger = Logger.getLogger(OccurrenceStatus.class);

	@XmlElement(name = "OccurrenceStatusType")

    @XmlIDREF

    @XmlSchemaType(name = "IDREF")

    @ManyToOne(fetch = FetchType.LAZY)

	private DefinedTerm type;

    @XmlElement(name = "Name")

    @XmlIDREF

    @XmlSchemaType(name = "IDREF")

    @ManyToOne(fetch = FetchType.LAZY)

    private DerivedUnit unit;

// ************************** FACTORY *********************************/

    /**

	 * Creates a new occurrence status instance with a given

	 * occurrence status type.

	 *

	 * @see #OccurrenceStatus()

	 */

	public static OccurrenceStatus NewInstance(DefinedTerm occurrenceStatusType){

		return NewInstance(occurrenceStatusType, null, null);

	}

	/**

	 * Creates a new occurrence status instance with a given

	 * occurrence status type.

	 *

	 * @see #OccurrenceStatus()

	 */

	public static OccurrenceStatus NewInstance(DefinedTerm occurrenceStatusType, Reference citation, String microCitation){

		OccurrenceStatus status = new OccurrenceStatus();

		status.setType(occurrenceStatusType);

		status.setCitation(citation);

		status.setCitationMicroReference(microCitation);

		return status;

	}

// ************************ CONSTRUCTOR *************************/

	protected OccurrenceStatus() {

        super();

    }

// ************************ GETTER / SETTER ************************/

    public DerivedUnit getUnit() {

        return unit;

    }

    protected void setUnit(DerivedUnit unit) {

        if (this.unit != null && !this.unit.equals(unit)){

            this.unit.removeStatus(this);

        }

        this.unit = unit;

        if (unit != null){

            unit.addStatus(this);

        }

    }

	/**

	 * Returns the occurrence status type of <i>this</i>

	 * occurrence status.

	 */

	public DefinedTerm getType(){

		return this.type;

	}

	/**

	 * @see  #getType()

	 */

	public void setType(DefinedTerm type){

		this.type = type;

	}

//*********************** CLONE ********************************************************/

	/**

	 * Clones <i>this</i> occurrence status. This is a shortcut that enables to create

	 * a new instance that differs only slightly from <i>this</i> occurrence status by

	 * modifying only some of the attributes.

	 *

	 * @see eu.etaxonomy.cdm.model.common.SingleSourcedEntityBase#clone()

	 * @see java.lang.Object#clone()

	 */

	@Override

	public OccurrenceStatus clone() {

		try {

			OccurrenceStatus result = (OccurrenceStatus)super.clone();

	        //no changes to: type

			return result;

		} catch (CloneNotSupportedException e) {

			logger.warn("Object does not implement cloneable");

			e.printStackTrace();

			return null;

		}

	}

}

    //Occurrence status type

    public static final UUID uuidNotExtant = UUID.fromString("6b4888d8-194a-45c3-a16a-e5b5465a8f3d");

    public static final UUID uuidDestroyed = UUID.fromString("d41cce17-9e68-47f8-904f-fcea1b0029bc");

    public static final UUID uuidLost = UUID.fromString("9d82974f-9535-432d-af5b-f233016abe51");

    public static final UUID uuidNotFound = UUID.fromString("c7df83c2-6e4b-42e8-8fa7-c07720a78e2b");

    public static final UUID uuidNotSeen = UUID.fromString("44f5f025-8814-49dd-b1ef-17557a13ea3e");

    public static final UUID uuidNotPreserved = UUID.fromString("87447824-06d8-4449-abe6-0c11ed77fdc9");

    public static final UUID uuidDriedOut = UUID.fromString("01fe0283-0da6-46a5-a050-22f9be338461");

	protected static Map<UUID, DefinedTerm> termMap = null;

	public static DefinedTerm getTermByUuid(UUID uuid){

    //42

    /**

     * The type for occurrence status.

     **/

    @XmlEnumValue("OccurrenceStatusType")

    OccurrenceStatusType(UUID.fromString("c50a977a-e697-4973-9514-08aeb0d05483"), "Occurrence status type", "OST", null),

	TaxonNodeAgentRelationType("0aa8e0c6-c7b5-42dd-91b7-0bd273a64b2c", DefinedTerm.class),

	OccurrenceStatusType("6d06b750-4f48-42de-85b5-220256e4e5ba", DefinedTerm.class),

"6d06b750-4f48-42de-85b5-220256e4e5ba",,"Occurrence Status Type","Occurrence Status Type","OST","0"

"6b4888d8-194a-45c3-a16a-e5b5465a8f3d",,"not extant","not extant",""

"d41cce17-9e68-47f8-904f-fcea1b0029bc",,"destroyed","destroyed",""

"9d82974f-9535-432d-af5b-f233016abe51",,"lost","lost",""

"c7df83c2-6e4b-42e8-8fa7-c07720a78e2b",,"not found","not found",""

"44f5f025-8814-49dd-b1ef-17557a13ea3e",,"not seen","not seen",""

"87447824-06d8-4449-abe6-0c11ed77fdc9",,"not preserved","not preserved",""

"01fe0283-0da6-46a5-a050-22f9be338461",,"dried out","dried out (for specimens in alcohol)",""

		mediaSpecimen.addStatus(DefinedTerm.getTermByUuid(DefinedTerm.uuidDestroyed), getReference(), "123");

import eu.etaxonomy.cdm.database.update.v527_529.SchemaUpdater_5271_5290;

        return SchemaUpdater_5271_5290.NewInstance();

	      super(stepList, stepName, MN_tableName, new ArrayList<>(), new ArrayList<>(), new ArrayList<Object>(), new ArrayList<Boolean>(), new ArrayList<String>(), includeAudTable, false, false, false, false, false);

		        includeCdmBaseAttributes, includeAnnotatableEntity, includeIdentifiableEntity, false, false);

	private final boolean includeSingleSourcedEntity;

		return new TableCreator(stepList, stepName, tableName, columnNames, columnTypes, null, null, null, includeAudTable, includeCdmBaseAttributes, false, false, false, false);

		return new TableCreator(stepList, stepName, tableName, Arrays.asList(columnNames), Arrays.asList(columnTypes), null, null, Arrays.asList(referencedTables), includeAudTable, includeCdmBaseAttributes, false, false, false, false);

        return new TableCreator(stepList, stepName, tableName, Arrays.asList(columnNames), Arrays.asList(columnTypes), null, null, Arrays.asList(referencedTables), true, true, false, false, true, false);

		return new TableCreator(stepList, stepName, tableName, Arrays.asList(columnNames), Arrays.asList(columnTypes), null, null, Arrays.asList(referencedTables), false, true, false, false, true, false);

		return new TableCreator(stepList, stepName, tableName, Arrays.asList(columnNames), Arrays.asList(columnTypes), null, null, Arrays.asList(referencedTables), includeAudTable, true, false, false, false, false);

		return new TableCreator(stepList, stepName, tableName, Arrays.asList(columnNames), Arrays.asList(columnTypes), null, null, Arrays.asList(referencedTables), includeAudTable, true, true, false, false, false);

	}

	public static final TableCreator NewSingleSourcedInstance(List<ISchemaUpdaterStep> stepList, String stepName, String tableName, String[] columnNames, String[] columnTypes, String[] referencedTables, boolean includeAudTable){

	    return new TableCreator(stepList, stepName, tableName, Arrays.asList(columnNames), Arrays.asList(columnTypes), null, null, Arrays.asList(referencedTables), includeAudTable, true, true, false, false, true);

		TableCreator result = new TableCreator(stepList, stepName, tableName, Arrays.asList(columnNames), Arrays.asList(columnTypes), null, null, Arrays.asList(referencedTables), includeAudTable, true, true, false, false, false);

		return new TableCreator(stepList, stepName, tableName, Arrays.asList(columnNames), Arrays.asList(columnTypes), null, null, Arrays.asList(referencedTables), includeAudTable, true, true, true, false, false);

			boolean includeAudTable, boolean includeCdmBaseAttributes, boolean includeAnnotatableEntity, boolean includeIdentifiableEntity, boolean excludeVersionableAttributes, boolean includeSingleSourcedEntity) {

		this.includeSingleSourcedEntity = includeSingleSourcedEntity;

			if (this.includeSingleSourcedEntity){

			    updateQuery += "source_id integer, ";

			}

		if (this.includeSingleSourcedEntity){

		    //source

		    String attribute = "source_id";

            String referencedTable = "OriginalSourceBase";

            makeForeignKey(tableName, datasource, monitor, attribute,

                    referencedTable, caseType, result);

		}

import eu.etaxonomy.cdm.database.update.TableCreator;

	private static final CdmVersion endSchemaVersion = CdmVersion.V_05_29_00;

		String tableName;

		//#2506 status for specimen

		stepName = "Add status for specimen";

		tableName = "OccurrenceStatus";

		String[] columnNames = new String[]{"unit_id","type_id"};

        String[] columnTypes = new String[]{"int","int"};

        String[] referencedTables = new String[]{"SpecimenAndObservationBase","DefinedTermBase"};

		TableCreator.NewSingleSourcedInstance(stepList, stepName, tableName, columnNames, columnTypes, referencedTables, INCLUDE_AUDIT);

      <mapping class="eu.etaxonomy.cdm.model.occurrence.MaterialOrMethodEvent"/>

      <mapping class="eu.etaxonomy.cdm.model.occurrence.MediaSpecimen"/>

      <mapping class="eu.etaxonomy.cdm.model.occurrence.OccurrenceStatus"/>

		String database = (schema == DbSchemaValidation.VALIDATE  ? "cdm527" : "cdm529");

      <mapping class="eu.etaxonomy.cdm.model.occurrence.MaterialOrMethodEvent"/>

      <mapping class="eu.etaxonomy.cdm.model.occurrence.MediaSpecimen"/>

      <mapping class="eu.etaxonomy.cdm.model.occurrence.OccurrenceStatus"/>