Table: IMAGE
Entity (ENT) | Southeast Fisheries Science Center (SEFSC)GUID: gov.noaa.nmfs.inport:7812 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
This is a test
DescriptionThis 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
Name | Type | Description | ||
---|---|---|---|---|
100
|
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |