7812 IMAGE Entity Published / External 7802 Biscayne Bay Dolphin Photo ID System Data Set Completed This is a test Loaded by batch 2223, 08-11-2008 14:27 Data Table Yes DOLPHINPHOTO This is a test 1 ID NUMBER 22 Yes Yes 38 Active Sequential Key NUMBER 2 IMAGE BLOB 4000 No No Active Actual image file BLOB 3 FILE_NAME VARCHAR2 255 Yes No Active Actual name of image file VARCHAR2 4 PARTNER_CODE VARCHAR2 5 Yes No Active Partner Code VARCHAR2 5 SURVEY_DATE DATE 7 No No Active Date Of Survey DATE 6 FIN_CATEGORY_CODE VARCHAR2 5 No No Active Fin category code VARCHAR2 7 DESCRIPTION VARCHAR2 4000 No No Active Description of photo VARCHAR2 8 DOLPHIN_ID VARCHAR2 20 Yes No Active Key to dolphin table VARCHAR2 9 DORSAL_RATIO NUMBER 22 No No 38 Active Dorsal ratio NUMBER 10 PUBLIC_NOTES VARCHAR2 4000 No No Active Any public notes on the image VARCHAR2 11 IS_PUBLISHABLE NUMBER 22 No No 38 Active Indicates if the photo is publishable NUMBER 12 UPLOADED_DATE DATE 7 No No Active Uploaded date DATE 13 HAS_SCARS VARCHAR2 1 No No Active Indicates if there are scars in the image VARCHAR2 14 HAS_LESIONS VARCHAR2 1 No No Active Indicates if there are lesions in the image VARCHAR2 15 FIN_TYPE_CODE NUMBER 22 No No 38 Active Fin type code NUMBER 16 CREATED_BY_USER_ID NUMBER 22 Yes No 38 Active Oracle User Code Of Person Who Created This Record NUMBER 17 CREATED_DATE DATE 7 No No Active Date record was created DATE 18 MODIFIED_BY_USER_ID NUMBER 22 No No 38 Active Oracle User Code Of Person Who LAST MODIFIED This Record NUMBER 19 MODIFIED_DATE DATE 7 No No Active time that record was last modified DATE 20 STANDARD_ID VARCHAR2 20 No No Active Standard Id for linking VARCHAR2 gov.noaa.nmfs.inport:7812 Lee Weinberger 2008-08-11T14:27:38 SysAdmin InPortAdmin 2022-08-09T17:11:01 2021-04-29 Southeast Fisheries Science Center SEFSC 75 Virginia Beach Drive Miami FL 33149 USA (305)361-5761 www.sefsc.noaa.gov 8:00 a.m. - 4:30 p.m. EST 1001 Public No 2021-04-29 1 Year 2022-04-29