Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
SEFSC Metadata Library > Sustainable Fisheries > Highly Migratory Species Branch > Recreational Billfish Survey > Recreational Billfish Survey (RBS) >

Table: TOURNAMENTS

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

Summary

Abstract

Master Table Of Tournaments

Description

Master Table Of Tournaments

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
TOURNAMENT_NAME
VARCHAR2 		Name Of The tournament
TOURNAMENT_CODE
NUMBER 		Tournament Code
LATITUDE
NUMBER 		Latitude Where Tournament Took Place
LONGITUDE
NUMBER 		Longitude Where Tournament Took Place
CITY
VARCHAR2 		City Of Tournament
STATE
VARCHAR2 		State Where tournament was held
COUNTRY
VARCHAR2 		Country Where Tournament Was Held
REGISTRATION_DATE
DATE 		Registration Date
SURVEY_SOURCE
VARCHAR2 		Source OfInformation From This tournament
ICCAT_AREA
VARCHAR2 		ICCAT Area Of Reporting
TERMINATION_DATE
DATE 		Termination Date
CLUB_SPONSOR
VARCHAR2 		Sponsor Of The Tournament
ID
NUMBER 		Sequential Key
COMMENTS
VARCHAR2 		Any Extra Comments about the tournament

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

Master Table Of Tournaments
Notes:

Loaded by batch 1863, 11-02-2007 09:24

Keywords

Theme Keywords

Thesaurus Keyword
UNCONTROLLED
None Tournament Lists

Entity Information

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

Master Table Of Tournaments

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 TOURNAMENT_NAME VARCHAR2 Name Of The tournament
100
 TOURNAMENT_CODE NUMBER Tournament Code
100
 LATITUDE NUMBER Latitude Where Tournament Took Place
100
 LONGITUDE NUMBER Longitude Where Tournament Took Place
100
 CITY VARCHAR2 City Of Tournament
100
 STATE VARCHAR2 State Where tournament was held
100
 COUNTRY VARCHAR2 Country Where Tournament Was Held
100
 REGISTRATION_DATE DATE Registration Date
100
 SURVEY_SOURCE VARCHAR2 Source OfInformation From This tournament
100
 ICCAT_AREA VARCHAR2 ICCAT Area Of Reporting
100
 TERMINATION_DATE DATE Termination Date
100
 CLUB_SPONSOR VARCHAR2 Sponsor Of The Tournament
100
 Primary Key ID NUMBER Sequential Key
100
 COMMENTS VARCHAR2 Any Extra Comments about the tournament

Attribute Details

TOURNAMENT_NAME

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

Name Of The tournament
General Data Type: VARCHAR2

TOURNAMENT_CODE

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

Tournament Code
General Data Type: NUMBER

LATITUDE

CC ID: 20732
Seq. Order: 3
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 6
Status: Active
Description:

Latitude Where Tournament Took Place
General Data Type: NUMBER

LONGITUDE

CC ID: 20733
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 10
Scale: 6
Status: Active
Description:

Longitude Where Tournament Took Place
General Data Type: NUMBER

CITY

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

City Of Tournament
General Data Type: VARCHAR2

STATE

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

State Where tournament was held
General Data Type: VARCHAR2

COUNTRY

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

Country Where Tournament Was Held
General Data Type: VARCHAR2

REGISTRATION_DATE

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

Registration Date
General Data Type: DATE

SURVEY_SOURCE

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

Source OfInformation From This tournament
General Data Type: VARCHAR2

ICCAT_AREA

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

ICCAT Area Of Reporting
General Data Type: VARCHAR2

TERMINATION_DATE

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

Termination Date
General Data Type: DATE

CLUB_SPONSOR

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

Sponsor Of The Tournament
General Data Type: VARCHAR2

ID

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

Sequential Key
General Data Type: NUMBER

COMMENTS

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

Any Extra Comments about the tournament
General Data Type: VARCHAR2

Catalog Details

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