Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Marine Mammal and Turtle Division > SEFSC Marine Mammal Projects > Marine Mammals Miami > Biscayne Bay Dolphin Photo ID System > Biscayne Bay Dolphin Photo ID System >

Table: RANGE_MAP

Entity (ENT)  |  Southeast Fisheries Science Center (SEFSC)
GUID: gov.noaa.nmfs.inport:7816  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

Data table listing images with dolphin counts

Description

Data table listing images with dolphin counts

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		Sequential Key
IMAGE
BLOB 		Actual Image Of Dolphin
DOLPHIN_ID
VARCHAR2 		Link to Doplhin_id table
PARTNER_CODE
VARCHAR2 		Link to Partner table
FILE_NAME
VARCHAR2 		Name Of the image file
FROM_DATE
DATE 		Start Date Of Count
TO_DATE
DATE 		End Date Of Count
OBS_COUNT
NUMBER 		Obsert Count Of Dolphins
IS_PUBLISHABLE
NUMBER 		Is This image publishable
UPLOADED_DATE
DATE 		Upload Date
CREATED_BY_USER_ID
NUMBER 		Oracle User Code Of Person Who Created This Record
CREATED_DATE
DATE 		Control Column Indicating When This Record Was Created

Child Items

No Child Items for this record.

Contact Information

No contact information is available for this record.

Please contact the owner organization (SEFSC) for inquiries on this record.

Item Identification

Title: Table: RANGE_MAP
Short Name: RANGE_MAP
Status: Completed
Abstract:

Data table listing images with dolphin counts
Notes:

Loaded by batch 2223, 08-11-2008 14:27

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: DOLPHINPHOTO
Description:

Data table listing images with dolphin counts

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ID NUMBER Sequential Key
100
 IMAGE BLOB Actual Image Of Dolphin
100
 DOLPHIN_ID VARCHAR2 Link to Doplhin_id table
100
 PARTNER_CODE VARCHAR2 Link to Partner table
100
 FILE_NAME VARCHAR2 Name Of the image file
100
 FROM_DATE DATE Start Date Of Count
100
 TO_DATE DATE End Date Of Count
100
 OBS_COUNT NUMBER Obsert Count Of Dolphins
100
 IS_PUBLISHABLE NUMBER Is This image publishable
100
 UPLOADED_DATE DATE Upload Date
100
 CREATED_BY_USER_ID NUMBER Oracle User Code Of Person Who Created This Record
100
 CREATED_DATE DATE Control Column Indicating When This Record Was Created

Attribute Details

ID

CC ID: 30916
Seq. Order: 1
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: Yes
Precision: 38
Status: Active
Description:

Sequential Key
General Data Type: NUMBER

IMAGE

CC ID: 30905
Seq. Order: 2
Data Storage Type: BLOB
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Actual Image Of Dolphin
General Data Type: BLOB

DOLPHIN_ID

CC ID: 30915
Seq. Order: 3
Data Storage Type: VARCHAR2
Max Length: 20
Required: Yes
Primary Key: No
Status: Active
Description:

Link to Doplhin_id table
General Data Type: VARCHAR2

PARTNER_CODE

CC ID: 30914
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 5
Required: Yes
Primary Key: No
Status: Active
Description:

Link to Partner table
General Data Type: VARCHAR2

FILE_NAME

CC ID: 30913
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 255
Required: Yes
Primary Key: No
Status: Active
Description:

Name Of the image file
General Data Type: VARCHAR2

FROM_DATE

CC ID: 30912
Seq. Order: 6
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Start Date Of Count
General Data Type: DATE

TO_DATE

CC ID: 30911
Seq. Order: 7
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

End Date Of Count
General Data Type: DATE

OBS_COUNT

CC ID: 30910
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Obsert Count Of Dolphins
General Data Type: NUMBER

IS_PUBLISHABLE

CC ID: 30909
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Is This image publishable
General Data Type: NUMBER

UPLOADED_DATE

CC ID: 30908
Seq. Order: 10
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Upload Date
General Data Type: DATE

CREATED_BY_USER_ID

CC ID: 30907
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: Yes
Primary Key: No
Precision: 38
Status: Active
Description:

Oracle User Code Of Person Who Created This Record
General Data Type: NUMBER

CREATED_DATE

CC ID: 30906
Seq. Order: 12
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Control Column Indicating When This Record Was Created
General Data Type: DATE

Catalog Details

Catalog Item ID: 7816
GUID: gov.noaa.nmfs.inport:7816
Metadata Record Created By: Lee M Weinberger
Metadata Record Created: 2008-08-11 14:27+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2021-04-29
Owner Org: SEFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2021-04-29
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2022-04-29