Database reference - calcom

calcom -  tables -  [dbo].[REG_RCAS]

Description

This table contains the rough boundaries, year of implementation, gear type, and area description of Rockfish Conservation Areas as part of the commercial regulations component of the database
 

Table properties

namevalue
name[dbo].[REG_RCAS]
ansi nullson 
quoted identifieron 
row count1,298
Size of data232 kb
Size of indexes8 kb
Maximum size of a single row3,624 bytes

Columns

columndatatypelengthbytesdefaultnullsPKFKUQcomputedcomment
Yearint104 yes      no   
Monthnvarchar520 yes      no   
Areanvarchar100400 yes      no 
the general location of the RCA
 
Location_Idnvarchar200800 yes      no   
Depthsnvarchar50200 yes      no   
Gear_typenvarchar50200 yes      no 
gear which the Conservation area applies to
 
Commentsnvarchar5002000 yes      no   

Dependency graph



Documentation generated by SqlSpec