Database reference - calcom

calcom -  tables -  [dbo].[reg_oy_abc_ofl]

Description

This table contains OYs, ABCs, etc... for groundfish included the commercial regulations component of the database
 

Table properties

namevalue
name[dbo].[reg_oy_abc_ofl]
ansi nullson 
quoted identifieron 
row count1,876
Size of data240 kb
Size of indexes8 kb
Maximum size of a single row2,832 bytes

Columns

columndatatypelengthbytesdefaultnullsPKFKUQcomputedcomment
policy_idint identity (1,1) 104 no      no   
Species_or_Group_oldnvarchar50200 yes      no  
for internal use only
 
species_or_groupnvarchar100400 yes      no  
species or group the regulations apply to
 
Yearint104 yes      no   
Location_idnvarchar50200 yes      no  
code to link regulation to REG_ALL_LOCATIONS table
 
OYreal74 yes      no  
Optimal Yeild
 
ABC_pre2011real74 yes      no  
Allowable Biological Catch prior to definition change in 2011
 
ABC_post2010real74 yes      no  
Allowable Biological Catch after 2010 when definition changed
 
OFLreal74 yes      no   
ACLreal74 yes      no   
HGreal74 yes      no   
Commentsnvarchar5002000 yes      no   

Dependency graph

dboreg_oy_abc_ofl



Documentation generated by SqlSpec