Exhibit_E.xlsx
XLSX spreadsheet 25 KB Posted
- Solicitation number
- 0000039898
- Issued by
- California
About this file
Exhibit E is a database schema document for the California Department of Fish and Wildlife's Recreational Fishing Regulations Mobile Application. The schema outlines the technical structure of a SQL Server database designed to support a publicly accessible mobile application that provides users with location-specific recreational marine and inland fishing regulations. The application is intended to enable geospatially driven access to fishing rules and restrictions based on user location, with support for offline functionality and an intuitive presentation of regulatory information. The database architecture includes tables for managing user authentication (AspNetUsers, AspNetRoles, AspNetUserClaims), fishing regulations and rules (Regulations, FishingRules, RestrictionTypes, RuleTypes), species management (SpeciesSet, SpeciesGroups, SpeciesSpeciesGroup), fishing methods and take methods (FishingMethods, TakeMethods), and supporting lookup tables for limits, measurement types and units, feature tiers, and comparative types. Additional tables support regulatory sources, tags for categorization, and audit trails through created/updated timestamps and user tracking fields.
The database schema demonstrates a comprehensive data model designed to store and organize complex fishing regulations with multiple filtering dimensions including geographic features, species groupings, fishing methods, take methods, seasonal restrictions, and catch limits with various measurement units. The structure includes soft-delete functionality (IsDeleted flags) and activation workflow capabilities (ActivatedTime, ActivationDoneBy fields) to manage regulatory changes and versions. Foreign key relationships establish connections between fishing rules and regulations, species, fishing methods, take methods, and feature tiers, enabling sophisticated queries that support the mobile application's requirement to deliver contextually relevant regulations based on user location and other filtering criteria. The schema's design supports the application's objective to enhance public understanding of fishing regulations and promote regulatory compliance across California.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Exhibit_C.pdf | ||
| Exhibit_1_-_CDFW_RFR_Requirements.docx | DOCX document | |
| Exhibit_A.docx | DOCX document | |
| Exhibit_B.docx | DOCX document | |
| Attachment_B_-_RFI_Response_Checklist.docx | DOCX document | |
| Attachment_A_-_Vendor_Questionnaire.docx | DOCX document | |
| Exhibit_D.pdf | ||
| RFR_Request_For_Information__RFI_.docx | DOCX document | |
| Exhibit_F.docx | DOCX document |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Schema
| table_name | column_id | column_name | data_type | max_length | is_nullable | is_primary_key | is_foreign_key | fk_name | referenced_table | referenced_column |
| AspNetRoleClaims | 1 | Id | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| AspNetRoleClaims | 2 | RoleId | nvarchar | 900 | 0 | 0 | 1 | FK_AspNetRoleClaims_AspNetRoles_RoleId | AspNetRoles | Id |
| AspNetRoleClaims | 3 | ClaimType | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetRoleClaims | 4 | ClaimValue | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetRoles | 1 | Id | nvarchar | 900 | 0 | 1 | 0 | NULL | NULL | NULL |
| AspNetRoles | 2 | Name | nvarchar | 512 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetRoles | 3 | NormalizedName | nvarchar | 512 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetRoles | 4 | ConcurrencyStamp | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUserClaims | 1 | Id | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| AspNetUserClaims | 2 | UserId | nvarchar | 900 | 0 | 0 | 1 | FK_AspNetUserClaims_AspNetUsers_UserId | AspNetUsers | Id |
| AspNetUserClaims | 3 | ClaimType | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUserClaims | 4 | ClaimValue | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUserLogins | 1 | LoginProvider | nvarchar | 900 | 0 | 1 | 0 | NULL | NULL | NULL |
| AspNetUserLogins | 2 | ProviderKey | nvarchar | 900 | 0 | 1 | 0 | NULL | NULL | NULL |
| AspNetUserLogins | 3 | ProviderDisplayName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUserLogins | 4 | UserId | nvarchar | 900 | 0 | 0 | 1 | FK_AspNetUserLogins_AspNetUsers_UserId | AspNetUsers | Id |
| AspNetUserRoles | 1 | UserId | nvarchar | 900 | 0 | 1 | 1 | FK_AspNetUserRoles_AspNetUsers_UserId | AspNetUsers | Id |
| AspNetUserRoles | 2 | RoleId | nvarchar | 900 | 0 | 1 | 1 | FK_AspNetUserRoles_AspNetRoles_RoleId | AspNetRoles | Id |
| AspNetUsers | 1 | Id | nvarchar | 900 | 0 | 1 | 0 | NULL | NULL | NULL |
| AspNetUsers | 2 | FirstName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 3 | LastName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 4 | CreatedDate | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 5 | UpdatedDate | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 6 | IsDeleted | bit | 1 | 0 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 7 | UserName | nvarchar | 512 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 8 | NormalizedUserName | nvarchar | 512 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 9 | nvarchar | 512 | 1 | 0 | 0 | NULL | NULL | NULL | |
| AspNetUsers | 10 | NormalizedEmail | nvarchar | 512 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 11 | EmailConfirmed | bit | 1 | 0 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 12 | PasswordHash | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 13 | SecurityStamp | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 14 | ConcurrencyStamp | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 15 | PhoneNumber | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 16 | PhoneNumberConfirmed | bit | 1 | 0 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 17 | TwoFactorEnabled | bit | 1 | 0 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 18 | LockoutEnd | datetimeoffset | 10 | 1 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 19 | LockoutEnabled | bit | 1 | 0 | 0 | 0 | NULL | NULL | NULL |
| AspNetUsers | 20 | AccessFailedCount | int | 4 | 0 | 0 | 0 | NULL | NULL | NULL |
| AspNetUserTokens | 1 | UserId | nvarchar | 900 | 0 | 1 | 1 | FK_AspNetUserTokens_AspNetUsers_UserId | AspNetUsers | Id |
| AspNetUserTokens | 2 | LoginProvider | nvarchar | 900 | 0 | 1 | 0 | NULL | NULL | NULL |
| AspNetUserTokens | 3 | Name | nvarchar | 900 | 0 | 1 | 0 | NULL | NULL | NULL |
| AspNetUserTokens | 4 | Value | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| ComparitiveTypes | 1 | ComparitiveTypeId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| ComparitiveTypes | 2 | ComparitiveTypeName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| ComparitiveTypes | 3 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| ComparitiveTypes | 4 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| ComparitiveTypes | 5 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| ComparitiveTypes | 6 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FeatureTiers | 1 | FeatureTierId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| FeatureTiers | 2 | FeatureTierName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FeatureTiers | 3 | FeatureTierValue | int | 4 | 0 | 0 | 0 | NULL | NULL | NULL |
| FeatureTiers | 4 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| FeatureTiers | 5 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FeatureTiers | 6 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| FeatureTiers | 7 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingMethods | 1 | FishingMethodId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| FishingMethods | 2 | FishingMethodName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingMethods | 3 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingMethods | 4 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingMethods | 5 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingMethods | 6 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 1 | FishingRuleId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| FishingRules | 2 | IsAllYear | bit | 1 | 0 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 3 | StartDate | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 4 | RestrictionType | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 5 | RegulationId | int | 4 | 1 | 0 | 1 | FK_FishingRules_Regulations_RegulationId | Regulations | RegulationId |
| FishingRules | 6 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 7 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 8 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 9 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 10 | ComparitiveType | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 11 | Details | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 12 | EndDate | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 13 | FeatureId | int | 4 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 14 | FishingMethodId | int | 4 | 1 | 0 | 1 | FK_FishingRules_FishingMethods_FishingMethodId | FishingMethods | FishingMethodId |
| FishingRules | 15 | FeatureCategory | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 16 | Limit | decimal | 9 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 17 | LimitType | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 18 | MeasurementUnit | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 19 | SpeciesGroupId | int | 4 | 1 | 0 | 1 | FK_FishingRules_SpeciesGroups_SpeciesGroupId | SpeciesGroups | SpeciesGroupId |
| FishingRules | 20 | SpeciesId | int | 4 | 1 | 0 | 1 | FK_FishingRules_SpeciesSet_SpeciesId | SpeciesSet | SpeciesId |
| FishingRules | 21 | TakeMethodId | int | 4 | 1 | 0 | 1 | FK_FishingRules_TakeMethods_TakeMethodId | TakeMethods | TakeMethodId |
| FishingRules | 22 | ActivatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 23 | ActivationDoneBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 24 | DeletedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 25 | DeletedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 26 | IsDeleted | bit | 1 | 0 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 27 | FeatureName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 28 | RuleType | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 29 | MesaurementType | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 30 | FishingMethodName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 31 | StaffDetails | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 32 | FeatureLayer | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| FishingRules | 33 | FeatureTierId | int | 4 | 1 | 0 | 1 | Fk_FishingRules_FeatureTierId | FeatureTiers | FeatureTierId |
| FishingRules | 34 | GlobalID | uniqueidentifier | 16 | 1 | 0 | 0 | NULL | NULL | NULL |
| LimitTypes | 1 | LimitTypeId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| LimitTypes | 2 | LimitTypeName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| LimitTypes | 3 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| LimitTypes | 4 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| LimitTypes | 5 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| LimitTypes | 6 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| MeasurementTypes | 1 | MeasurementTypeId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| MeasurementTypes | 2 | MeasurementTypeName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| MeasurementTypes | 3 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| MeasurementTypes | 4 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| MeasurementTypes | 5 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| MeasurementTypes | 6 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| MeasurementUnits | 1 | MeasurementUnitId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| MeasurementUnits | 2 | MeasurementUnitName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| MeasurementUnits | 3 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| MeasurementUnits | 4 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| MeasurementUnits | 5 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| MeasurementUnits | 6 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 1 | RegulationId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| Regulations | 2 | Title | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 3 | Verbatim | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 4 | Code | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 5 | ParentCode | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 6 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 7 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 8 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 9 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 10 | IsDeleted | bit | 1 | 0 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 11 | Source | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 12 | Type | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 13 | Tags | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 14 | DeletedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 15 | DeletedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 16 | ActivationTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| Regulations | 17 | ActivationDoneBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| RestrictionTypes | 1 | RestrictionTypeId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| RestrictionTypes | 2 | RestrictionTypeName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| RestrictionTypes | 3 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| RestrictionTypes | 4 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| RestrictionTypes | 5 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| RestrictionTypes | 6 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| RuleTypes | 1 | RuleTypeId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| RuleTypes | 2 | RuleTypeName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| RuleTypes | 3 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| RuleTypes | 4 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| RuleTypes | 5 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| RuleTypes | 6 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| RuleTypes | 7 | SortByID | int | 4 | 1 | 0 | 0 | NULL | NULL | NULL |
| Sources | 1 | SourceId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| Sources | 2 | SourceTitle | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Sources | 3 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| Sources | 4 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Sources | 5 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| Sources | 6 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 1 | SpeciesGroupId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 2 | Name | nvarchar | -1 | 0 | 0 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 3 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 4 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 5 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 6 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 7 | DefinitionInRegulations | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 8 | IsApplicationGroup | bit | 1 | 0 | 0 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 9 | Members | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 10 | Tier | int | 4 | 0 | 0 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 11 | SpeciesType | nvarchar | 100 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesGroups | 12 | Zone | nvarchar | -1 | 0 | 0 | 0 | NULL | NULL | NULL |
| SpeciesSet | 1 | SpeciesId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| SpeciesSet | 2 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesSet | 3 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesSet | 4 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesSet | 5 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesSet | 6 | CommonName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesSet | 7 | SortedName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| SpeciesSpeciesGroup | 1 | SpeciesGroupsSpeciesGroupId | int | 4 | 0 | 1 | 1 | FK_SpeciesSpeciesGroup_SpeciesGroups_SpeciesGroupsSpeciesGroupId | SpeciesGroups | SpeciesGroupId |
| SpeciesSpeciesGroup | 2 | SpeciesListSpeciesId | int | 4 | 0 | 1 | 1 | FK_SpeciesSpeciesGroup_SpeciesSet_SpeciesListSpeciesId | SpeciesSet | SpeciesId |
| Tags | 1 | TagId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| Tags | 2 | TagName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Tags | 3 | IsDeleted | bit | 1 | 0 | 0 | 0 | NULL | NULL | NULL |
| Tags | 4 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| Tags | 5 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| Tags | 6 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| Tags | 7 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| TakeMethods | 1 | TakeMethodId | int | 4 | 0 | 1 | 0 | NULL | NULL | NULL |
| TakeMethods | 2 | TakeMethodName | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| TakeMethods | 3 | DefinitionInRegulation | nvarchar | -1 | 0 | 0 | 0 | NULL | NULL | NULL |
| TakeMethods | 4 | CreatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| TakeMethods | 5 | CreatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
| TakeMethods | 6 | UpdatedBy | nvarchar | -1 | 1 | 0 | 0 | NULL | NULL | NULL |
| TakeMethods | 7 | UpdatedTime | datetime2 | 8 | 1 | 0 | 0 | NULL | NULL | NULL |
File details come from the government source that posted it. Updated .