<?xml version="1.0" encoding="UTF-8"?>
<inport-metadata xmlns:xs="http://www.w3.org/2001/XMLSchema"
                 version="1.11"
                 source="https://www.fisheries.noaa.gov">
   <item-identification>
      <catalog-item-id>7808</catalog-item-id>
      <title>Table: DOLPHIN_INFO</title>
      <short-name>DOLPHIN_INFO</short-name>
      <catalog-item-type>Entity</catalog-item-type>
      <metadata-workflow-state ccs-id="9">Published / External</metadata-workflow-state>
      <parent-catalog-item-id>7802</parent-catalog-item-id>
      <parent-title>Biscayne Bay Dolphin Photo ID System</parent-title>
      <parent-catalog-item-type>Data Set</parent-catalog-item-type>
      <status>Completed</status>
      <abstract>Data table listing INFORMATION ABOUT THE DOLPHIN</abstract>
      <notes>Loaded by batch 2223, 08-11-2008 14:27</notes>
   </item-identification>
   <entity-information>
      <entity-type>Data Table</entity-type>
      <active-version>Yes</active-version>
      <schema>DOLPHINPHOTO</schema>
      <description>Data table listing INFORMATION ABOUT THE DOLPHIN</description>
   </entity-information>
   <data-attributes>
      <data-attribute cc-id="30858">
         <seq-order>1</seq-order>
         <name>ID</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>Yes</required>
         <primary-key>Yes</primary-key>
         <precision>38</precision>
         <status>Active</status>
         <description>Sequential Key</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="30857">
         <seq-order>2</seq-order>
         <name>SIGHTING_ID</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <precision>38</precision>
         <status>Active</status>
         <description>Foreign Key to SIghtings Table</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="30856">
         <seq-order>3</seq-order>
         <name>DOLPHIN_ID</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>20</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Foreign Key to Dlphin_ID Table</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="30855">
         <seq-order>4</seq-order>
         <name>NUMBER_OF_EXTRAS</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <precision>38</precision>
         <status>Active</status>
         <description>Number Of Extras</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="30854">
         <seq-order>5</seq-order>
         <name>PRELIMINARY_LETTER_ID</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>3</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Preliminary Letter ID</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="30853">
         <seq-order>6</seq-order>
         <name>IS_NEW_SIGHTING</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>1</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Is This A New Sighting</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="30852">
         <seq-order>7</seq-order>
         <name>COMMENTS</name>
         <data-storage-type>VARCHAR2</data-storage-type>
         <max-length>4000</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Any Comments About Dolphin</description>
         <general-data-type>VARCHAR2</general-data-type>
      </data-attribute>
      <data-attribute cc-id="30851">
         <seq-order>8</seq-order>
         <name>CREATED_BY_USER_ID</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>Yes</required>
         <primary-key>No</primary-key>
         <precision>38</precision>
         <status>Active</status>
         <description>Oracle Userid of the creator of this record</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="30850">
         <seq-order>9</seq-order>
         <name>CREATED_DATE</name>
         <data-storage-type>DATE</data-storage-type>
         <max-length>7</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Date Record was create</description>
         <general-data-type>DATE</general-data-type>
      </data-attribute>
      <data-attribute cc-id="30849">
         <seq-order>10</seq-order>
         <name>MODIFIED_BY_USER_ID</name>
         <data-storage-type>NUMBER</data-storage-type>
         <max-length>22</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <precision>38</precision>
         <status>Active</status>
         <description>Oracle Userid of the person who last changed this record</description>
         <general-data-type>NUMBER</general-data-type>
      </data-attribute>
      <data-attribute cc-id="30848">
         <seq-order>11</seq-order>
         <name>MODIFIED_DATE</name>
         <data-storage-type>DATE</data-storage-type>
         <max-length>7</max-length>
         <required>No</required>
         <primary-key>No</primary-key>
         <status>Active</status>
         <description>Date That this record was last modified</description>
         <general-data-type>DATE</general-data-type>
      </data-attribute>
   </data-attributes>
   <catalog-details>
      <guid>gov.noaa.nmfs.inport:7808</guid>
      <metadata-record-created-by pers-id="1279">Lee Weinberger</metadata-record-created-by>
      <metadata-record-created>2008-08-11T14:27:37</metadata-record-created>
      <metadata-record-last-modified-by pers-id="0">SysAdmin InPortAdmin</metadata-record-last-modified-by>
      <metadata-record-last-modified>2022-08-09T17:11:01</metadata-record-last-modified>
      <record-published>2021-04-29</record-published>
      <owner-organization>Southeast Fisheries Science Center</owner-organization>
      <owner-organization-acronym>SEFSC</owner-organization-acronym>
      <owner-organization-address>75 Virginia Beach Drive</owner-organization-address>
      <owner-organization-address-city>Miami</owner-organization-address-city>
      <owner-organization-address-state>FL</owner-organization-address-state>
      <owner-organization-address-zip>33149</owner-organization-address-zip>
      <owner-organization-address-country>USA</owner-organization-address-country>
      <owner-organization-phone>(305)361-5761</owner-organization-phone>
      <owner-organization-url>www.sefsc.noaa.gov</owner-organization-url>
      <owner-organization-business-hours>8:00 a.m. - 4:30 p.m. EST</owner-organization-business-hours>
      <owner-organization-group-id>1001</owner-organization-group-id>
      <publication-status>Public</publication-status>
      <is-do-not-publish>No</is-do-not-publish>
      <metadata-last-review-date>2021-04-29</metadata-last-review-date>
      <metadata-review-frequency>1 Year</metadata-review-frequency>
      <metadata-next-review-date>2022-04-29</metadata-next-review-date>
   </catalog-details>
</inport-metadata>
