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

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

Summary

Abstract

System profile/security table

Description

System profile/security table

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
ID
NUMBER 		Sequential Key/Code
USERNAME
VARCHAR2 		Oracle Userid/Usercode
PASSWORD
VARCHAR2 		Encoded Password
PARTNER_CODE
VARCHAR2 		Foreign Key To Partner Table
SECURITY_LEVEL_ID
NUMBER 		Code To Indicate Privileges Of The Indicated User
FIRST_NAME
VARCHAR2 		Data Manger/User First Name
LAST_NAME
VARCHAR2 		Data Manager/User Last Name
ORGANIZATION
VARCHAR2 		Organization Associated With User/Manager
TELEPHONE
VARCHAR2 		Telephone Numer Associated With User/Manager
EMAIL
VARCHAR2 		Electronic Mail Address of User/Manager
CREATED_DATE
DATE 		Control Column Indicating WHen This Record Was Created
UPLOADED_DATE
DATE 		Control Column To Indicate When Record as Last Uploaded
MODIFIED_DATE
DATE 		Control COlumn Indiccating When This Record Was Last Modified

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

System profile/security table
Notes:

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

Entity Information

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

System profile/security table

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 Primary Key ID NUMBER Sequential Key/Code
100
 USERNAME VARCHAR2 Oracle Userid/Usercode
100
 PASSWORD VARCHAR2 Encoded Password
100
 PARTNER_CODE VARCHAR2 Foreign Key To Partner Table
100
 SECURITY_LEVEL_ID NUMBER Code To Indicate Privileges Of The Indicated User
100
 FIRST_NAME VARCHAR2 Data Manger/User First Name
100
 LAST_NAME VARCHAR2 Data Manager/User Last Name
100
 ORGANIZATION VARCHAR2 Organization Associated With User/Manager
100
 TELEPHONE VARCHAR2 Telephone Numer Associated With User/Manager
100
 EMAIL VARCHAR2 Electronic Mail Address of User/Manager
100
 CREATED_DATE DATE Control Column Indicating WHen This Record Was Created
100
 UPLOADED_DATE DATE Control Column To Indicate When Record as Last Uploaded
100
 MODIFIED_DATE DATE Control COlumn Indiccating When This Record Was Last Modified

Attribute Details

ID

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

Sequential Key/Code
General Data Type: NUMBER

USERNAME

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

Oracle Userid/Usercode
General Data Type: VARCHAR2

PASSWORD

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

Encoded Password
General Data Type: VARCHAR2

PARTNER_CODE

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

Foreign Key To Partner Table
General Data Type: VARCHAR2

SECURITY_LEVEL_ID

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

Code To Indicate Privileges Of The Indicated User
General Data Type: NUMBER

FIRST_NAME

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

Data Manger/User First Name
General Data Type: VARCHAR2

LAST_NAME

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

Data Manager/User Last Name
General Data Type: VARCHAR2

ORGANIZATION

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

Organization Associated With User/Manager
General Data Type: VARCHAR2

TELEPHONE

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

Telephone Numer Associated With User/Manager
General Data Type: VARCHAR2

EMAIL

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

Electronic Mail Address of User/Manager
General Data Type: VARCHAR2

CREATED_DATE

CC ID: 30986
Seq. Order: 11
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

UPLOADED_DATE

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

Control Column To Indicate When Record as Last Uploaded
General Data Type: DATE

MODIFIED_DATE

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

Control COlumn Indiccating When This Record Was Last Modified
General Data Type: DATE

Catalog Details

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