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: IMAGE

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

Summary

Abstract

This is a test

Description

This is a test

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		Sequential Key
IMAGE
BLOB 		Actual image file
FILE_NAME
VARCHAR2 		Actual name of image file
PARTNER_CODE
VARCHAR2 		Partner Code
SURVEY_DATE
DATE 		Date Of Survey
FIN_CATEGORY_CODE
VARCHAR2 		Fin category code
DESCRIPTION
VARCHAR2 		Description of photo
DOLPHIN_ID
VARCHAR2 		Key to dolphin table
DORSAL_RATIO
NUMBER 		Dorsal ratio
PUBLIC_NOTES
VARCHAR2 		Any public notes on the image
IS_PUBLISHABLE
NUMBER 		Indicates if the photo is publishable
UPLOADED_DATE
DATE 		Uploaded date
HAS_SCARS
VARCHAR2 		Indicates if there are scars in the image
HAS_LESIONS
VARCHAR2 		Indicates if there are lesions in the image
FIN_TYPE_CODE
NUMBER 		Fin type code
CREATED_BY_USER_ID
NUMBER 		Oracle User Code Of Person Who Created This Record
CREATED_DATE
DATE 		Date record was created
MODIFIED_BY_USER_ID
NUMBER 		Oracle User Code Of Person Who LAST MODIFIED This Record
MODIFIED_DATE
DATE 		time that record was last modified
STANDARD_ID
VARCHAR2 		Standard Id for linking

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: IMAGE
Short Name: IMAGE
Status: Completed
Abstract:

This is a test
Notes:

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

Entity Information

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

This is a test

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ID NUMBER Sequential Key
100
 IMAGE BLOB Actual image file
100
 FILE_NAME VARCHAR2 Actual name of image file
100
 PARTNER_CODE VARCHAR2 Partner Code
100
 SURVEY_DATE DATE Date Of Survey
100
 FIN_CATEGORY_CODE VARCHAR2 Fin category code
100
 DESCRIPTION VARCHAR2 Description of photo
100
 DOLPHIN_ID VARCHAR2 Key to dolphin table
100
 DORSAL_RATIO NUMBER Dorsal ratio
100
 PUBLIC_NOTES VARCHAR2 Any public notes on the image
100
 IS_PUBLISHABLE NUMBER Indicates if the photo is publishable
100
 UPLOADED_DATE DATE Uploaded date
100
 HAS_SCARS VARCHAR2 Indicates if there are scars in the image
100
 HAS_LESIONS VARCHAR2 Indicates if there are lesions in the image
100
 FIN_TYPE_CODE NUMBER Fin type code
100
 CREATED_BY_USER_ID NUMBER Oracle User Code Of Person Who Created This Record
100
 CREATED_DATE DATE Date record was created
100
 MODIFIED_BY_USER_ID NUMBER Oracle User Code Of Person Who LAST MODIFIED This Record
100
 MODIFIED_DATE DATE time that record was last modified
100
 STANDARD_ID VARCHAR2 Standard Id for linking

Attribute Details

ID

CC ID: 30885
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: 30884
Seq. Order: 2
Data Storage Type: BLOB
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Actual image file
General Data Type: BLOB

FILE_NAME

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

Actual name of image file
General Data Type: VARCHAR2

PARTNER_CODE

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

Partner Code
General Data Type: VARCHAR2

SURVEY_DATE

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

Date Of Survey
General Data Type: DATE

FIN_CATEGORY_CODE

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

Fin category code
General Data Type: VARCHAR2

DESCRIPTION

CC ID: 30879
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Description of photo
General Data Type: VARCHAR2

DOLPHIN_ID

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

Key to dolphin table
General Data Type: VARCHAR2

DORSAL_RATIO

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

Dorsal ratio
General Data Type: NUMBER

PUBLIC_NOTES

CC ID: 30876
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

Any public notes on the image
General Data Type: VARCHAR2

IS_PUBLISHABLE

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

Indicates if the photo is publishable
General Data Type: NUMBER

UPLOADED_DATE

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

Uploaded date
General Data Type: DATE

HAS_SCARS

CC ID: 30873
Seq. Order: 13
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates if there are scars in the image
General Data Type: VARCHAR2

HAS_LESIONS

CC ID: 30872
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Indicates if there are lesions in the image
General Data Type: VARCHAR2

FIN_TYPE_CODE

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

Fin type code
General Data Type: NUMBER

CREATED_BY_USER_ID

CC ID: 30870
Seq. Order: 16
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: 30869
Seq. Order: 17
Data Storage Type: DATE
Max Length: 7
Required: No
Primary Key: No
Status: Active
Description:

Date record was created
General Data Type: DATE

MODIFIED_BY_USER_ID

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

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

MODIFIED_DATE

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

time that record was last modified
General Data Type: DATE

STANDARD_ID

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

Standard Id for linking
General Data Type: VARCHAR2

Catalog Details

Catalog Item ID: 7812
GUID: gov.noaa.nmfs.inport:7812
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