<?xml version="1.0" encoding="UTF-8"?><Diagram version="1.0" type="MSSQL" versionMajor="8" versionMinor="0" groupSchema="false" hide_inv="false">
<Table id="0" name="CollectionEvent" schema="dbo" database="MBARI_Samples" background="16777165">
<Column id="1" name="CollectionEventID" type="int" length="0" nulls="false">
<CP name="IDENTITY">YES</CP>
<CP name="IDENTITY_SEED">1</CP>
<CP name="IDENTITY_INCREMENT">1</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="2" name="CollectionEventDTG" type="datetime" length="0" nulls="true"/>
<Column id="3" name="TapeTimeCode" type="varchar" length="50" nulls="true"/>
<Column id="4" name="FrameGrabImageURL" type="varchar" length="255" nulls="true"/>
<Column id="5" name="CollectionGroupID" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="6" name="CollectionRefName" type="varchar" length="50" nulls="true"/>
<Column id="7" name="Interpreter" type="varchar" length="50" nulls="true"/>
<Column id="8" name="CollectionVIMSConcept" type="varchar" length="50" nulls="true"/>
<Column id="9" name="Equipment" type="varchar" length="50" nulls="true"/>
<Column id="10" name="Latitude" type="decimal" length="0" nulls="true">
<CP name="PRECISION">12</CP>
<CP name="SCALE">8</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="11" name="Longitude" type="decimal" length="0" nulls="true">
<CP name="PRECISION">14</CP>
<CP name="SCALE">8</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="12" name="Depth" type="decimal" length="0" nulls="true">
<CP name="PRECISION">7</CP>
<CP name="SCALE">1</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="13" name="DiveName" type="varchar" length="50" nulls="true"/>
<Column id="14" name="WaypointName" type="varchar" length="50" nulls="true"/>
<Column id="15" name="Temperature" type="decimal" length="0" nulls="true">
<CP name="PRECISION">7</CP>
<CP name="SCALE">3</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="16" name="Salinity" type="decimal" length="0" nulls="true">
<CP name="PRECISION">7</CP>
<CP name="SCALE">3</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="17" name="CTDPressure" type="decimal" length="0" nulls="true">
<CP name="PRECISION">7</CP>
<CP name="SCALE">1</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="18" name="DissolvedOxygen" type="decimal" length="0" nulls="true">
<CP name="PRECISION">6</CP>
<CP name="SCALE">2</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="19" name="Comment" type="varchar" length="255" nulls="true"/>
<Column id="20" name="CTDLookupStatus" type="smallint" length="0" nulls="true">
<CP name="DEFAULT_VALUE">(1)</CP>
</Column>
<Column id="21" name="CoreLength" type="decimal" length="0" nulls="true">
<CP name="PRECISION">6</CP>
<CP name="SCALE">1</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
</Table>
<Table id="22" name="CollectionGroup" schema="dbo" database="MBARI_Samples" background="16777165">
<Column id="23" name="CollectionGroupID" type="int" length="0" nulls="false">
<CP name="IDENTITY">YES</CP>
<CP name="IDENTITY_SEED">1</CP>
<CP name="IDENTITY_INCREMENT">1</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="24" name="StartDTG" type="smalldatetime" length="0" nulls="true"/>
<Column id="25" name="ShipName" type="varchar" length="50" nulls="true">
<CP name="DEFAULT_VALUE">('Point Lobos')</CP>
</Column>
<Column id="26" name="ROVName" type="varchar" length="50" nulls="true">
<CP name="DEFAULT_VALUE">('Ventana')</CP>
</Column>
<Column id="27" name="ChiefScientistID" type="int" length="0" nulls="true">
<CP name="DEFAULT_VALUE">(1)</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
</Table>
<Table id="28" name="Equipment" schema="dbo" database="MBARI_Samples" background="16777165">
<Column id="29" name="Equipment" type="varchar" length="50" nulls="false"/>
<Column id="30" name="LongerDescription" type="varchar" length="50" nulls="true"/>
</Table>
<Table id="31" name="Sample" schema="dbo" database="MBARI_Samples" background="16777165">
<Column id="32" name="SampleID" type="int" length="0" nulls="false">
<CP name="IDENTITY">YES</CP>
<CP name="IDENTITY_SEED">1</CP>
<CP name="IDENTITY_INCREMENT">1</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="33" name="CollectionEventID" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="34" name="SampleRefName" type="varchar" length="50" nulls="true"/>
<Column id="35" name="SampleExists" type="bit" length="0" nulls="false">
<CP name="DEFAULT_VALUE">(1)</CP>
</Column>
<Column id="36" name="ParentSampleID" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="37" name="SubSampleMethod" type="varchar" length="50" nulls="true">
<CP name="DEFAULT_VALUE">('not a subsample')</CP>
</Column>
<Column id="38" name="SubsamplePosition" type="varchar" length="50" nulls="true"/>
<Column id="39" name="DescriptionComment" type="varchar" length="255" nulls="true"/>
<Column id="40" name="CollectorID" type="int" length="0" nulls="true">
<CP name="DEFAULT_VALUE">(1)</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="41" name="Owner" type="varchar" length="50" nulls="true">
<CP name="DEFAULT_VALUE">('MBARI')</CP>
</Column>
<Column id="42" name="Sorted" type="bit" length="0" nulls="false">
<CP name="DEFAULT_VALUE">(1)</CP>
</Column>
<Column id="43" name="LotCount" type="int" length="0" nulls="true">
<CP name="DEFAULT_VALUE">(1)</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="44" name="TypeStatus" type="bit" length="0" nulls="false">
<CP name="DEFAULT_VALUE">(0)</CP>
</Column>
<Column id="45" name="EmbargoExpDate" type="smalldatetime" length="0" nulls="true"/>
<Column id="46" name="ContainerType" type="varchar" length="50" nulls="true">
<CP name="DEFAULT_VALUE">('None specified')</CP>
</Column>
<Column id="47" name="PreservativeMethod" type="varchar" length="50" nulls="true">
<CP name="DEFAULT_VALUE">('not specified')</CP>
</Column>
<Column id="48" name="ConditionComment" type="varchar" length="255" nulls="true"/>
<Column id="49" name="NeedsLabel" type="bit" length="0" nulls="false">
<CP name="DEFAULT_VALUE">(0)</CP>
</Column>
<Column id="50" name="NeedsNewContainer" type="bit" length="0" nulls="false">
<CP name="DEFAULT_VALUE">(0)</CP>
</Column>
<Column id="51" name="NeedsPreservative" type="bit" length="0" nulls="false">
<CP name="DEFAULT_VALUE">(0)</CP>
</Column>
<Column id="52" name="KeywordLookupStatus" type="smallint" length="0" nulls="true">
<CP name="DEFAULT_VALUE">(1)</CP>
</Column>
<Column id="53" name="ContactID" type="int" length="0" nulls="true">
<CP name="DEFAULT_VALUE">(1)</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
</Table>
<Relation id="54" name="FK_CollectionEvent_Equipment" cardinality="-2" identifying="false" nulls="false">
<Option name="enfConMS" class="Boolean" value="false"/>
<Option name="noReplication" class="Boolean" value="true"/>
<Option name="onDelete" class="String" value="NO ACTION"/>
<Option name="onUpdate" class="String" value="NO ACTION"/>
<FK>29</FK>
<PK>9</PK>
</Relation>
<Relation id="55" name="FK_CollectionEvent_CollectionGroup" cardinality="-2" identifying="false" nulls="false">
<Option name="enfConMS" class="Boolean" value="false"/>
<Option name="noReplication" class="Boolean" value="true"/>
<Option name="onDelete" class="String" value="NO ACTION"/>
<Option name="onUpdate" class="String" value="NO ACTION"/>
<FK>23</FK>
<PK>5</PK>
</Relation>
<Relation id="56" name="FK_Sample_CollectionEvent" cardinality="-2" identifying="false" nulls="false">
<Option name="enfConMS" class="Boolean" value="false"/>
<Option name="noReplication" class="Boolean" value="true"/>
<Option name="onDelete" class="String" value="NO ACTION"/>
<Option name="onUpdate" class="String" value="NO ACTION"/>
<FK>1</FK>
<PK>33</PK>
</Relation>
<Index table="0" name="CollEvent_CollEventDTG_Idx" schema="dbo" database="MBARI_Samples">
<Option name="padindex" class="Boolean" value="false"/>
<Option name="ignoreDupKey" class="Boolean" value="false"/>
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="true"/>
<Option name="statNoRecompute" class="Boolean" value="false"/>
<Option name="fillfactor" class="Integer" value="90"/>
<IndexColumn id="2" sequence="0" ascending="true"/>
</Index>
<Index table="0" name="CollEvent_CollGroupID_Idx" schema="dbo" database="MBARI_Samples">
<Option name="padindex" class="Boolean" value="false"/>
<Option name="ignoreDupKey" class="Boolean" value="false"/>
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="statNoRecompute" class="Boolean" value="false"/>
<Option name="fillfactor" class="Integer" value="90"/>
<IndexColumn id="5" sequence="0" ascending="true"/>
</Index>
<Index table="0" name="CollEvent_TapeTimeCd_Idx" schema="dbo" database="MBARI_Samples">
<Option name="padindex" class="Boolean" value="false"/>
<Option name="ignoreDupKey" class="Boolean" value="false"/>
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="statNoRecompute" class="Boolean" value="false"/>
<Option name="fillfactor" class="Integer" value="90"/>
<IndexColumn id="3" sequence="0" ascending="true"/>
</Index>
<Index table="0" name="CollEvent_Equipment_Idx" schema="dbo" database="MBARI_Samples">
<Option name="padindex" class="Boolean" value="false"/>
<Option name="ignoreDupKey" class="Boolean" value="false"/>
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="statNoRecompute" class="Boolean" value="false"/>
<Option name="fillfactor" class="Integer" value="90"/>
<IndexColumn id="9" sequence="0" ascending="true"/>
</Index>
<Index table="22" name="ChiefScientistID_Idx" schema="dbo" database="MBARI_Samples">
<Option name="padindex" class="Boolean" value="false"/>
<Option name="ignoreDupKey" class="Boolean" value="false"/>
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="statNoRecompute" class="Boolean" value="false"/>
<Option name="fillfactor" class="Integer" value="90"/>
<IndexColumn id="27" sequence="0" ascending="true"/>
</Index>
<Index table="31" name="Sample_CollEventID_Idx" schema="dbo" database="MBARI_Samples">
<Option name="padindex" class="Boolean" value="false"/>
<Option name="ignoreDupKey" class="Boolean" value="false"/>
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="statNoRecompute" class="Boolean" value="false"/>
<Option name="fillfactor" class="Integer" value="90"/>
<IndexColumn id="33" sequence="0" ascending="true"/>
</Index>
<Index table="31" name="Sample_CollectorID_Idx" schema="dbo" database="MBARI_Samples">
<Option name="padindex" class="Boolean" value="false"/>
<Option name="ignoreDupKey" class="Boolean" value="false"/>
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="statNoRecompute" class="Boolean" value="false"/>
<Option name="fillfactor" class="Integer" value="90"/>
<IndexColumn id="40" sequence="0" ascending="true"/>
</Index>
<Index table="31" name="Sample_ContainerType_Idx" schema="dbo" database="MBARI_Samples">
<Option name="padindex" class="Boolean" value="false"/>
<Option name="ignoreDupKey" class="Boolean" value="false"/>
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="statNoRecompute" class="Boolean" value="false"/>
<Option name="fillfactor" class="Integer" value="90"/>
<IndexColumn id="46" sequence="0" ascending="true"/>
</Index>
<Index table="31" name="Sample_PreservMethod_Idx" schema="dbo" database="MBARI_Samples">
<Option name="padindex" class="Boolean" value="false"/>
<Option name="ignoreDupKey" class="Boolean" value="false"/>
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="statNoRecompute" class="Boolean" value="false"/>
<Option name="fillfactor" class="Integer" value="90"/>
<IndexColumn id="47" sequence="0" ascending="true"/>
</Index>
<Index table="31" name="Sample_ParentSampleID_Idx" schema="dbo" database="MBARI_Samples">
<Option name="padindex" class="Boolean" value="false"/>
<Option name="ignoreDupKey" class="Boolean" value="false"/>
<Option name="unique" class="Boolean" value="false"/>
<Option name="clustered" class="Boolean" value="false"/>
<Option name="statNoRecompute" class="Boolean" value="false"/>
<Option name="fillfactor" class="Integer" value="90"/>
<IndexColumn id="36" sequence="0" ascending="true"/>
</Index>
<Constraint table="0" name="CollectionEvent_PK" type="PrimKey">
<Option name="clustered" class="Boolean" value="false"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="1"/>
</Constraint>
<Constraint table="22" name="CollectionGroup_PK" type="PrimKey">
<Option name="clustered" class="Boolean" value="true"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="23"/>
</Constraint>
<Constraint table="28" name="Equipment_PK" type="PrimKey">
<Option name="clustered" class="Boolean" value="true"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="29"/>
</Constraint>
<Constraint table="31" name="Sample_PK" type="PrimKey">
<Option name="clustered" class="Boolean" value="true"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="32"/>
</Constraint>
<Sheet name="Solstice as everyone" id="57" disp_at="true" disp_ph="true" disp_co="true" disp_rn="true">
<Place id="56" visible="true">500,0,0,0</Place>
<Place id="28" visible="true">21,19,220,60</Place>
<Place id="0" visible="true">281,19,250,380</Place>
<Place id="55" visible="true">500,0,0,0</Place>
<Place id="54" visible="true">500,0,0,0</Place>
<Place id="22" visible="true">381,589,180,110</Place>
<Place id="31" visible="true">791,19,250,400</Place>
</Sheet>
<Settings sheet="57" zoom="1.0"/>
</Diagram>
