<?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="Dive" schema="dbo" database="EXPD" background="16777165">
<Column id="1" name="DiveID" type="int" length="0" nulls="false">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="2" name="DeviceID" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="3" name="RovName" type="varchar" length="4" nulls="true"/>
<Column id="4" name="DiveNumber" type="int" length="0" nulls="false">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="5" name="ExpeditionID_FK" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="6" name="DiveStartDtg" type="datetime" length="0" nulls="true"/>
<Column id="7" name="DiveEndDtg" type="datetime" length="0" nulls="true"/>
<Column id="8" name="DiveChiefScientist" type="varchar" length="50" nulls="true"/>
<Column id="9" name="BriefAccomplishments" type="varchar" length="5000" nulls="true"/>
<Column id="10" name="DiveStartTimecode" type="char" length="11" nulls="true"/>
<Column id="11" name="DiveEndTimecode" type="char" length="11" nulls="true"/>
<Column id="12" name="DiveLatMid" 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="13" name="DiveLonMid" 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="14" name="DiveDepthMid" 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="15" name="rowguid" type="uniqueidentifier" length="0" nulls="true">
<CP name="DEFAULT_VALUE">(newid())</CP>
<CP name="ISROWGUIDCOL">YES</CP>
</Column>
</Table>
<Table id="16" name="Expedition" schema="dbo" database="EXPD" background="16777165">
<Column id="17" name="ExpeditionID" type="int" length="0" nulls="false">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="18" name="DeviceID" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="19" name="ShipName" type="varchar" length="4" nulls="true"/>
<Column id="20" name="ShipSeqNum" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="21" name="Purpose" type="varchar" length="4096" nulls="true"/>
<Column id="22" name="StatCode" type="varchar" length="30" nulls="true"/>
<Column id="23" name="ExpdChiefScientist" type="varchar" length="50" nulls="true"/>
<Column id="24" name="ExpdPrincipalInvestigator" type="varchar" length="50" nulls="true"/>
<Column id="25" name="ScheduledStartDtg" type="datetime" length="0" nulls="true"/>
<Column id="26" name="ScheduledEndDtg" type="datetime" length="0" nulls="true"/>
<Column id="27" name="EquipmentDesc" type="varchar" length="2048" nulls="true"/>
<Column id="28" name="Participants" type="varchar" length="2048" nulls="true"/>
<Column id="29" name="RegionDesc" type="varchar" length="2048" nulls="true"/>
<Column id="30" name="PlannedTrackDesc" type="varchar" length="6144" nulls="true"/>
<Column id="31" name="StartDtg" type="datetime" length="0" nulls="true"/>
<Column id="32" name="EndDtg" type="datetime" length="0" nulls="true"/>
<Column id="33" name="Accomplishments" type="varchar" length="6144" nulls="true"/>
<Column id="34" name="ScientistComments" type="varchar" length="6144" nulls="true"/>
<Column id="35" name="SciObjectivesMet" type="varchar" length="50" nulls="true"/>
<Column id="36" name="OperatorComments" type="varchar" length="2048" nulls="true"/>
<Column id="37" name="AllEquipmentFunctioned" type="varchar" length="50" nulls="true"/>
<Column id="38" name="OtherComments" type="varchar" length="2048" nulls="true"/>
<Column id="39" name="UpdatedBy" type="varchar" length="50" nulls="true"/>
<Column id="40" name="ismodified" type="int" length="0" nulls="true">
<CP name="DEFAULT_VALUE">(0)</CP>
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
</Table>
<Table id="41" name="ExpeditionData" schema="dbo" database="EXPD" background="16777165">
<Column id="42" name="ExpeditionDataID" 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="43" name="DataType" type="varchar" length="1024" nulls="false"/>
<Column id="44" name="DeviceID" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="45" name="RovName_FK" type="varchar" length="4" nulls="true"/>
<Column id="46" name="DiveNumber_FK" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="47" name="ExpeditionID_FK" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="48" name="URL" type="varchar" length="1024" nulls="false"/>
<Column id="49" name="LinkText" type="varchar" length="1024" nulls="false"/>
<Column id="50" name="LinkComment" type="varchar" length="2048" nulls="true"/>
<Column id="51" name="UnixPath" type="varchar" length="1024" nulls="true"/>
<Column id="52" name="WindowsPath" type="varchar" length="1024" nulls="true"/>
<Column id="53" name="PlaceInList" type="int" length="0" nulls="true">
<CP name="IDENTITY">NO</CP>
<CP name="NOT_FOR_REPLICATION">NO</CP>
</Column>
<Column id="54" name="InsertedBy" type="varchar" length="128" nulls="true"/>
</Table>
<Index table="0" name="ChiefScientistPtcID" schema="dbo" database="EXPD">
<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="8" sequence="0" ascending="true"/>
</Index>
<Index table="0" name="IDX_Dive_RovName" schema="dbo" database="EXPD">
<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="DiveNumber" schema="dbo" database="EXPD">
<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="4" sequence="0" ascending="true"/>
</Index>
<Index table="0" name="ExpdID_FK" schema="dbo" database="EXPD">
<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="16" name="IDX_Expd_StartDtg" schema="dbo" database="EXPD">
<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="25" sequence="0" ascending="true"/>
</Index>
<Index table="16" name="IDX_Expd_EndDtg" schema="dbo" database="EXPD">
<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="26" sequence="0" ascending="true"/>
</Index>
<Index table="16" name="IDX_Expd_ChiefScientist" schema="dbo" database="EXPD">
<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="23" sequence="0" ascending="true"/>
</Index>
<Index table="16" name="IDX_Expd_ChfSci_StartDtg" schema="dbo" database="EXPD">
<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="23" sequence="0" ascending="true"/>
<IndexColumn id="25" sequence="1" ascending="true"/>
</Index>
<Index table="16" name="IDX_Expd_ChiefSci_Start_End" schema="dbo" database="EXPD">
<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="23" sequence="0" ascending="true"/>
<IndexColumn id="25" sequence="1" ascending="true"/>
<IndexColumn id="26" sequence="2" ascending="true"/>
</Index>
<Constraint table="0" name="aaaaaDive_PK" type="PrimKey">
<Option name="clustered" class="Boolean" value="true"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="1"/>
</Constraint>
<Constraint table="16" name="PK_Expedition_1" type="PrimKey">
<Option name="clustered" class="Boolean" value="true"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="17"/>
</Constraint>
<Constraint table="41" name="PK_ExpeditionData" type="PrimKey">
<Option name="clustered" class="Boolean" value="false"/>
<Option name="fillFactor" class="Integer" value="-1"/>
<ConstraintColumn id="42"/>
</Constraint>
<Sheet name="Solstice as everyone" id="55" disp_at="true" disp_ph="true" disp_co="true" disp_rn="true">
<Place id="16" visible="true">10,10,260,430</Place>
<Place id="0" visible="true">310,10,260,280</Place>
<Place id="41" visible="true">610,10,210,250</Place>
</Sheet>
<Settings sheet="55" zoom="1.0"/>
</Diagram>
