<?xml version="1.0" encoding="UTF-8"?><Diagram version="1.0" type="POSTGRES" versionMajor="9" versionMinor="1" groupSchema="false" hide_inv="false">
<Table id="0" name="geometry_columns" schema="public" database="mbaritracking" background="16777165">
<Column id="1" name="f_table_catalog" type="varchar" length="256" nulls="false"/>
<Column id="2" name="f_table_schema" type="varchar" length="256" nulls="false"/>
<Column id="3" name="f_table_name" type="varchar" length="256" nulls="false"/>
<Column id="4" name="f_geometry_column" type="varchar" length="256" nulls="false"/>
<Column id="5" name="coord_dimension" type="int4" length="0" nulls="false"/>
<Column id="6" name="srid" type="int4" length="0" nulls="false"/>
<Column id="7" name="type" type="varchar" length="30" nulls="false"/>
</Table>
<Table id="8" name="platform" schema="public" database="mbaritracking" background="16777165">
<Column id="9" name="id" type="serial" length="0" nulls="false"/>
<Column id="10" name="platformtype_id" type="int4" length="0" nulls="true"/>
<Column id="11" name="name" type="varchar" length="16" nulls="false"/>
<Column id="12" name="mmsi" type="varchar" length="9" nulls="true"/>
<Column id="13" name="imei" type="varchar" length="17" nulls="true"/>
<Column id="14" name="source" type="varchar" length="32" nulls="true"/>
<Column id="15" name="color" type="varchar" length="8" nulls="true"/>
<Column id="16" name="abbr" type="varchar" length="10" nulls="true"/>
</Table>
<Table id="17" name="platform_type" schema="public" database="mbaritracking" background="16777165">
<Column id="18" name="id" type="serial" length="0" nulls="false"/>
<Column id="19" name="name" type="varchar" length="32" nulls="false"/>
</Table>
<Table id="20" name="position" schema="public" database="mbaritracking" background="16777165">
<Column id="21" name="id" type="serial" length="0" nulls="false"/>
<Column id="22" name="platform_id" type="int4" length="0" nulls="false"/>
<Column id="23" name="datetime" type="timestamptz" length="0" nulls="false"/>
<Column id="24" name="geom" type="geometry" length="0" nulls="false"/>
</Table>
<Table id="25" name="spatial_ref_sys" schema="public" database="mbaritracking" background="16777165">
<Column id="26" name="srid" type="int4" length="0" nulls="false"/>
<Column id="27" name="auth_name" type="varchar" length="256" nulls="true"/>
<Column id="28" name="auth_srid" type="int4" length="0" nulls="true"/>
<Column id="29" name="srtext" type="varchar" length="2048" nulls="true"/>
<Column id="30" name="proj4text" type="varchar" length="2048" nulls="true"/>
</Table>
<Relation id="31" name="platform_platformtype_id_fkey" cardinality="-2" identifying="false" nulls="false">
<Option name="initially" class="String" value="DEFERRED"/>
<Option name="deferrable" class="Boolean" value="true"/>
<Option name="match" class="String" value="SIMPLE"/>
<Option name="onDelete" class="String" value="NO ACTION"/>
<Option name="onUpdate" class="String" value="NO ACTION"/>
<FK>18</FK>
<PK>10</PK>
</Relation>
<Relation id="32" name="position_platform_id_fkey" cardinality="-2" identifying="false" nulls="false">
<Option name="initially" class="String" value="DEFERRED"/>
<Option name="deferrable" class="Boolean" value="true"/>
<Option name="match" class="String" value="SIMPLE"/>
<Option name="onDelete" class="String" value="NO ACTION"/>
<Option name="onUpdate" class="String" value="NO ACTION"/>
<FK>9</FK>
<PK>22</PK>
</Relation>
<Index table="8" name="platform_name_like" schema="public" database="mbaritracking">
<Option name="unique" class="Boolean" value="false"/>
<IndexColumn id="11" sequence="0" ascending="true"/>
</Index>
<Index table="8" name="platform_name" schema="public" database="mbaritracking">
<Option name="unique" class="Boolean" value="false"/>
<IndexColumn id="11" sequence="0" ascending="true"/>
</Index>
<Index table="8" name="platform_platformtype_id" schema="public" database="mbaritracking">
<Option name="unique" class="Boolean" value="false"/>
<IndexColumn id="10" sequence="0" ascending="true"/>
</Index>
<Index table="17" name="platform_type_name_key" schema="public" database="mbaritracking">
<Option name="unique" class="Boolean" value="true"/>
<IndexColumn id="19" sequence="0" ascending="true"/>
</Index>
<Index table="20" name="position_datetime" schema="public" database="mbaritracking">
<Option name="unique" class="Boolean" value="false"/>
<IndexColumn id="23" sequence="0" ascending="true"/>
</Index>
<Index table="20" name="position_platform_id" schema="public" database="mbaritracking">
<Option name="unique" class="Boolean" value="false"/>
<IndexColumn id="22" sequence="0" ascending="true"/>
</Index>
<Index table="20" name="position_geom_id" schema="public" database="mbaritracking">
<Option name="unique" class="Boolean" value="false"/>
<IndexColumn id="24" sequence="0" ascending="true"/>
</Index>
<Constraint table="0" name="geometry_columns_pk" type="PrimKey">
<Option name="tablespace" class="String" value="&lt;DEFAULT&gt;"/>
<ConstraintColumn id="1"/>
<ConstraintColumn id="2"/>
<ConstraintColumn id="3"/>
<ConstraintColumn id="4"/>
</Constraint>
<Constraint table="8" name="platform_pkey" type="PrimKey">
<Option name="tablespace" class="String" value="&lt;DEFAULT&gt;"/>
<ConstraintColumn id="9"/>
</Constraint>
<Constraint table="17" name="platform_type_pkey" type="PrimKey">
<Option name="tablespace" class="String" value="&lt;DEFAULT&gt;"/>
<ConstraintColumn id="18"/>
</Constraint>
<Constraint table="17" name="platform_type_name_key" type="Unique">
<Option name="tablespace" class="String" value="&lt;DEFAULT&gt;"/>
<ConstraintColumn id="19"/>
</Constraint>
<Constraint table="20" name="position_pkey" type="PrimKey">
<Option name="tablespace" class="String" value="&lt;DEFAULT&gt;"/>
<ConstraintColumn id="21"/>
</Constraint>
<Constraint table="20" name="enforce_srid_geom" type="Check" condition="(st_srid(geom) = 4326)"/>
<Constraint table="20" name="enforce_geotype_geom" type="Check" condition="((geometrytype(geom) = 'POINT'::text) OR (geom IS NULL))"/>
<Constraint table="20" name="enforce_dims_geom" type="Check" condition="(st_ndims(geom) = 2)"/>
<Constraint table="25" name="spatial_ref_sys_pkey" type="PrimKey">
<Option name="tablespace" class="String" value="&lt;DEFAULT&gt;"/>
<ConstraintColumn id="26"/>
</Constraint>
<Sheet name="mbaritracking on normandy as odssadm" id="33" disp_at="true" disp_ph="true" disp_co="true" disp_rn="true">
<Place id="25" visible="true">21,219,190,110</Place>
<Place id="20" visible="true">21,19,170,90</Place>
<Place id="32" visible="true">500,0,0,0</Place>
<Place id="31" visible="true">500,0,0,0</Place>
<Place id="0" visible="true">251,219,240,140</Place>
<Place id="8" visible="true">421,19,170,160</Place>
<Place id="17" visible="true">821,209,150,60</Place>
</Sheet>
<Settings sheet="33" zoom="1.0"/>
</Diagram>
