FI:TCP/SRL/2251
Field Document 2
TECHNICAL COOPERATION PROGRAM
ESTABLISHMENT OF A MONITORING SYSTEM FOR CATCHES OF ARTISANAL
DRIFTNET AND LONGLINE FISHING
SRI LANKA
Report prepared for
the Government of Sri Lanka
by
the Food and Agriculture Organisation of the United Nations
Howel Williams
FOOD AND AGRICULTURE ORGANISATION OF THE UNITED NATIONS
Colombo, 1995
This electronic document has been scanned using optical character recognition (OCR) software and careful manual recorrection. Even if the quality of digitalisation is high, the FAO declines all responsibility for any discrepancies that may exist between the present document and its original printed version.
1.1 Backup
1.2 Optimising database performance
1.3 Creating a new database
1.4 Changing validation rules
APPENDIX 1 DATABASE DESIGN SPECIFICATIONS
Table: Boat_description
Table: Boat_details
Table: Catch_details
Table: Code_gear
Table: Code_site
Table: Code_species
Table: Convert_number_to_weight
Table: Length_details
Table: Sample_details
Table: Supervisor_boat/catch_details
Table: Supervisor_site_details
Relationships: All
Module: Utilities
APPENDIX 2 CURRENT VALUES IN THE LOOK-UP TABLES
1.1 Backup
1.2 Optimising database performance
1.3 Creating a new database
1.4 Changing validation rules
The database is called PELAGOS and for each year there is different 'container' (or discrete database created. These files should be given the title 'pelago9*' with the 9* corresponding to the year's data (i.e. pelago94 for 1994 data).
Making backup copies of the database is an important part of maintaining your data and ensuring that they are secure. A typical pelago9*.mdb file may run to 8 Mb and so needs to be compressed in order to copy it to a floppy disk.
This can be done by using the 'Compress File' routine in the File Management application (provided by PC Tools) situated on the FAO_TCP desktop.
Figure 1. To compress a file using 'File Management'
Double click on the 'Compress File' option and at the dialogue box, select 'Browse' to find the file that you want to compress. It will be something like c:\fao_tcp\pelago9*\pelago9*.mdb.
For the compress to option insert your floppy in the a: drive and chose a:pelago9*.mdb (if a copy already exists on the floppy, choose the 'Overwrite' option.
Figure 2. Selecting the file and naming the destination.
You will need to ensure that you have more than one copy (in case one is damaged) and that the different copies are not kept at the same site. It is highly recommended that you maintain three sets of two duplicate backup disks, one set maintained at the MBRD and the other at IPTP. The sets should be used for the following backups:
|
J |
F |
M |
A |
M |
J |
J |
A |
S |
0 |
N |
D |
Year end |
|
Set 1 |
Set 2 |
Set 3 |
Set 1 |
Set 2 |
Set 3 |
Set 1 |
Set 2 |
Set 3 |
Set 1 |
Set 2 |
Set 3 |
Set 1 |
If you have a failure in the main database stored on the hard-disk, then you should first make sure that the hard-disk is safe to restore files to (so check for corruption of the directory with PC Tools or Norton Utilities), then when you are sure that the hard-disk is all right you can restore your last backup version of pelago9*. To do this, use the 'Expand File' routine in the File Management application (provided by PC Tools) or uncompress with PKZip2.
As you add data to your database and amend it, the data will become 'fragmented' over the hard-disk. This tends to slow the database down and may also cause it to store data inefficiently - taking more room than it actually needs. This problem is easily rectified - or avoided. Every quarter, load Microsoft ACCESS, close any database applications and then from the 'File' menu choose the 'Compress file...' option.
Figure 3. Optimising the performance of the database.
This will prompt you for the name of the file to be compressed and the name of the file for the result. Chose the current database (pelago9*.mdb) and give the same name for the destination.
Do not be confused by the name of the routine, it is not compressing the file in the way that PKZip would, rather it is optimising the file.
Each year requires a different database to store the data collected. The new file needs to have all the report formats, programming modules and look-up (constant) tables that were present in the latest version of the database (i.e. the previous year's database), but you don't want all of the sampling data from the previous year.
To create a new database activate the 'Program Manager' select the last version of PELAGOS (say pelago95.mdb for the 1995 data), then from the 'File' menu choose 'Copy'. For the destination name type pelago9*.mdb for data for the year 199*. The Program Manager will create a copy of the previous years database complete with routines, constants and all of the sampling data.
To get rid of the previous year's data, open the new database file, and when it is open close the 'Navigator' window. Behind it is the database window.
Figure 4. Selecting and opening tables for editing.
Click on the 'Tables' marker. From the list of Tables choose the "Sample_details' file click 'Open' and then select all of the rows by clicking in the cell in the top left hand comer of the window. Press 'Del' and close the window - you will get a warning dialogue asking for you to confirm the Delete action - say OK.
Now repeat these actions for the 'Supervisor_details' and the 'Convert_numbers_to_weights' tables.
All of the previous sampling data has now been removed, and now would be a good time to run the 'Compress' routine in the previous section.
Validation rules have been set for much of the input data. A 'sensible' range of values has been entered and if your a values fall outside that range a message will be shown and the figure will not be accepted. This is to protect against typographical errors. Sometimes you may have data that really does fall outside of the current accepted range. In this case you will need to change the validation rules before you can enter the data.
To change the validation rules, first determine which Table contains the field in which you were trying to enter the offending data. This is fairly simple to do as data from different tables are grouped together on the input forms. Go to the database window and select 'Tables' - now click on the appropriate table name and choose 'Design'. In the design mode select the field and the validation rule will be listed. Check that any changes that are reasonable and then close the window - the result will be saved and you can now continue to enter the data.
Entering data to the PELAGOS database is straight forward. At the 'Navigator' window, choose the type of data that you want to enter (Sampler's data, Supervisor's data or Length information).
Figure 5. The 'Navigator' window of PELAGOS.
This will take you to the appropriate entry screen containing all of the fields that you are required to enter data for.
Figure 6. The data entry screen for the Sampler's data.
Figure 7. The data entry screen for the Supervisor's data.
Figure 8. The data entry screen for length data.
To edit data just click on the appropriate record and field and change it, the changes are automatically made to the data files. To insert new records click on the 'New record' button. If you want to add new records for catches or lengths for a sample record that already exists, then just go to the part of the form that contains the catch or length data and enter the information in the row marked by the new record symbol.
You have access to most of the reports from the 'Navigator' window, by using either the 'Preview reports' or 'Production estimates' buttons. These reports have generally been set to include all of the records on the database. If you want to restrict the report to a specific value or a range of values then you will need to open and edit the report in 'Design' mode. If you do this it is best not to save the changes.
When you have opened the report in design mode, double click in the white square in the top left-hand comer of the report window. You will get a Properties box for the report. Select the record source line and click the procedure button (that's the one with the ellipsis '...')
You will see the following screen.
Figure 9. The Query screen that selects the data to include in the report.
To enter a restriction, find the column corresponding to the field that you want restricted. You can enter a specific value such as UN2A for 'Boat_type' or a range of values such as UN2A and UN2B. You can also use wildcard arguments in the restriction. This is particularly useful if you want a report that does not split the yellowfin and skipjack tunas into small, medium and large categories. To do this enter the restriction as shown in Figure 9. This would include all records with YF as the first two characters.
At the end of the sampling year you can run though the procedures for calculating annual production. To do this you will need to have completed data entry for the last year and also the entry of the January data for the current year.
At the 'Navigator' window select the 'Production estimates' button. This opens a new window that gives a step-by-step description of the actions that you will need to take and from which you can also run any of the reports or program modules required.
Figure 10. The step-by-step guide to making production estimates.
The final step requires you to leave PELAGOS with the various reports and open Excel. In Excel find the file ProdAnal.xls and save as say ProdAn95.xls (for 1995 production). The ProdAnal.xls spreadsheet needs four inputs from which to estimate production. It requires the number of vessels of different classes by zone and month engaged in fishing (from MOFAR or whatever), the average number of landings made by boats of the different classes by zone and month (from PELAGOS), the number of boats sampled in each boat category by zone and month (from PELAGOS) and the total quantity landed by sampled vessels of the various species by boats of the different classes by zone and month (from PELAGOS). All of these figures should be added to the sets of data on the left-hand side of the spreadsheet. The set on the right-hand side are the calculations and should not be altered.
When you have finished, print the file. You can cut and paste the summary results to other spreadsheets (like prodgraph.xls) if you want to plot the results.
Table: Boat_description
Table: Boat_details
Table: Catch_details
Table: Code_gear
Table: Code_site
Table: Code_species
Table: Convert_number_to_weight
Table: Length_details
Table: Sample_details
Table: Supervisor_boat/catch_details
Table: Supervisor_site_details
Relationships: All
Module: Utilities
The following are the database specifications for PELAGOS as listed by the Microsoft ACCESS database documentation procedure.
C:\FAO_TCP\PELAGOS\PELAGO94.MDB
17 April 1995
Properties
|
Date Created: |
01/03/95 13:00:37 |
Def. Updatable: |
Yes |
|
Last Updated: |
24/03/95 11:20:06 |
Record Count: |
8 |
|
Row Height: |
990 |
|
|
Columns
|
Name |
|
Type |
Size |
|
|
Boat_code |
|
Text |
4 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
1 |
|
|
|
|
Column Width: |
Default |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
4 char code for vessel class |
|
|
|
|
Input Mask: |
>L>L0>C;; |
|
|
|
|
Ordinal Position: |
1 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Boat_code |
|
|
|
|
Source Table: |
Boat_description |
|
|
|
|
Validate On Set: |
No |
|
|
|
Boat_type |
|
Memo |
|
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
6240 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Description of boat class |
|
|
|
|
Ordinal Position: |
2 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Boat_type |
|
|
|
|
Source Table: |
Boat_description |
|
|
|
|
Validate On Set: |
No |
|
|
Relationships
Reference2
Attributes: One to Many, Enforced, Cascade Updates
Reference9
Attributes: One to Many, Enforced, Cascade Updates
Properties
|
Date Created: |
13/02/95 13:01:52 |
|
Last Updated: |
03/04/95 12:38:37 |
|
Def. Updatable: |
Yes |
|
Record Count: |
3991 |
Columns
|
Name |
|
Type |
Size |
|
|
Site_code |
|
Text |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
540 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
2 char code for the site |
|
|
|
|
Input Mask: |
>L>L;; |
|
|
|
|
Ordinal Position: |
1 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Site_code |
|
|
|
|
Source Table: |
Boat_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Date |
|
Date/Time |
8 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
1035 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Sampling date |
|
|
|
|
Format: |
d/m/yy |
|
|
|
|
Ordinal Position: |
2 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Date |
|
|
|
|
Source Table: |
Boat_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Boat_number |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
465 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
0 |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
The number of the boat sampled for the day (1-n) |
|
|
|
|
Format: |
General Number |
|
|
|
|
Ordinal Position: |
3 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Boat_number |
|
|
|
|
Source Table: |
Boat_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Boat_type |
|
Text |
4 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
855 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Category of boat ie UN1 etc. |
|
|
|
|
Input Mask: |
>L>L0>C;; |
|
|
|
|
Ordinal Position: |
4 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Boat_type |
|
|
|
|
Source Table: |
Boat_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Days_fished |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
495 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of days that the boat was engaged in fishing |
|
|
|
|
Format: |
General Number |
|
|
|
|
Ordinal Position: |
5 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Days_fished |
|
|
|
|
Source Table: |
Boat_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=30 |
|
|
|
|
Validation Text: |
Must be less than 30 fishing days. |
|
|
|
Net_pieces |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
660 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of net pieces on board |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
6 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Net_pieces |
|
|
|
|
Source Table: |
Boat_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Must be less than 100 net pieces. |
|
|
|
Hook_number |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
705 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of hooks on board |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
7 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Hook_number |
|
|
|
|
Source Table: |
Boat_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=1000 |
|
|
|
|
Validation Text: |
Must be less than 1,000 hooks |
|
|
|
Gear_type |
|
Text |
3 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
570 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Other gear types used (if not GN or LL) |
|
|
|
|
Input Mask: |
>L>L>L;; |
|
|
|
|
Ordinal Position: |
8 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Gear_type |
|
|
|
|
Source Table: |
Boat_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Bait_type |
|
Text |
3 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
660 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Species code for bait type used |
|
|
|
|
Input Mask: |
>L>L>L;; |
|
|
|
|
Ordinal Position: |
9 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Bait_type |
|
|
|
|
Source Table: |
Boat_details |
|
|
|
|
Validate On Set: |
No |
|
|
Relationships
Reference
Attributes: One to Many, Enforced, Cascade Updates, Cascade Deletes
Reference1
Attributes: One to Many, Enforced, Cascade Updates, Cascade Deletes
Reference2
Attributes: One to Many, Enforced, Cascade Updates
Reference5
Attributes: One to Many, Enforced
Reference6
Attributes: One to Many, Enforced, Cascade Updates
Properties
|
Date Created: |
13/02/95 13:02:39 |
|
Last Updated: |
29/03/95 09:53:40 |
|
Def. Updatable: |
Yes |
|
Record Count: |
19521 |
Columns
|
Name |
|
Type |
Size |
|
|
Site_code |
|
Text |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
735 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
2 char site code |
|
|
|
|
Input Mask: |
>L>L;; |
|
|
|
|
Ordinal Position: |
1 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Site_code |
|
|
|
|
Source Table: |
Catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Date |
|
Date/Time |
8 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
855 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Date of sampling |
|
|
|
|
Format: |
d/m/yy |
|
|
|
|
Ordinal Position: |
2 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Date |
|
|
|
|
Source Table: |
Catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Boat_number |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
690 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
0 |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of the boat sampled |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
3 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Boat_number |
|
|
|
|
Source Table: |
Catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Species |
|
Text |
3 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
840 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Species code for this sample |
|
|
|
|
Input Mask: |
>L>L>L;; |
|
|
|
|
Ordinal Position: |
4 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Species |
|
|
|
|
Source Table: |
Catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Number |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
810 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of fish |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
5 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Number |
|
|
|
|
Source Table: |
Catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=5000 |
|
|
|
|
Validation Text: |
Number must be less than 5,000 |
|
|
|
Weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
900 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Weight in kgs. |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
6 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Weight |
|
|
|
|
Source Table: |
Catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=10000 |
|
|
|
|
Validation Text: |
Weight must not exceed 10,000 kgs. |
|
|
|
Calc_weight |
|
Number (Double) |
8 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
Default |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight calculated from numbers and average weights from lengths |
|
|
|
|
Ordinal Position: |
7 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Calc_weight |
|
|
|
|
Source Table: |
Catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
Relationships
Reference1
Attributes: One to Many, Enforced, Cascade Updates, Cascade Deletes
Reference11
Attributes: One to One, Not Enforced
Reference4
Attributes: One to Many, Enforced, Cascade Updates
Reference7
Attributes: One to Many, Enforced, Cascade Deletes
Properties
|
Date Created: |
20/02/95 11:39:10 |
|
Last Updated: |
06/03/95 12:18:33 |
|
Def. Updatable: |
Yes |
|
Record Count: |
9 |
Columns
|
Name |
|
Type |
Size |
|
|
Gear_code |
|
Text |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
570 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
2 char unique gear code |
|
|
|
|
Input Mask: |
>L>L;; |
|
|
|
|
Ordinal Position: |
1 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Gear_code |
|
|
|
|
Source Table: |
Code_gear |
|
|
|
|
Validate On Set: |
No |
|
|
|
Gear_description |
|
Memo |
|
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
Default |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Brief description of the gear |
|
|
|
|
Ordinal Position: |
2 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Gear_description |
|
|
|
|
Source Table: |
Code_gear |
|
|
|
|
Validate On Set: |
No |
|
|
Relationships
Reference5
Attributes: One to Many, Enforced
Properties
|
Date Created: |
20/02/95 11:39:05 |
|
Last Updated: |
21/03/95 13:09:01 |
|
Def. Updatable: |
Yes |
|
Record Count: |
20 |
Columns
|
Name |
|
Type |
Size |
|
|
|
Site_code |
|
Text |
2 |
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
Default |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
2 char unique code for sampling sites |
|
|
|
|
Input Mask: |
>L>L;; |
|
|
|
|
Ordinal Position: |
1 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Site_code |
|
|
|
|
Source Table: |
Code_site |
|
|
|
|
Validate On Set: |
No |
|
|
|
Site_name |
|
Memo |
|
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
Default |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Site name |
|
|
|
|
Ordinal Position: |
2 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Site_name |
|
|
|
|
Source Table: |
Code_site |
|
|
|
|
Validate On Set: |
No |
|
|
|
Statistical_zone |
|
Text |
50 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
Default |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Zone in which site is situated |
|
|
|
|
Ordinal Position: |
3 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Statistical_zone |
|
|
|
|
Source Table: |
Code_site |
|
|
|
|
Validate On Set: |
No |
|
|
Relationships
Reference10
Attributes: One to Many, Enforced
Reference3
Attributes: One to Many, Enforced
Properties
|
Date Created: |
20/02/95 11:38:53 |
|
Last Updated: |
24/03/95 16:14:57 |
|
Def. Updatable: |
Yes |
|
Record Count: |
53 |
Columns
|
Name |
|
Type |
Size |
|
|
Species_code |
|
Text |
3 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
1 |
|
|
|
|
Column Width: |
765 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
3 char unique code for species/family name or group |
|
|
|
|
Input Mask: |
>L>L>L;; |
|
|
|
|
Ordinal Position: |
1 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Species_code |
|
|
|
|
Source Table: |
Code_species |
|
|
|
|
Validate On Set: |
No |
|
|
|
Common_name |
|
Memo |
|
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
2295 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Common name (English) |
|
|
|
|
Ordinal Position: |
2 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Common_name |
|
|
|
|
Source Table: |
Code_species |
|
|
|
|
Validate On Set: |
No |
|
|
|
Scientific_name |
|
Memo |
|
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
2145 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Scientific name |
|
|
|
|
Ordinal Position: |
3 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Scientific_name |
|
|
|
|
Source Table: |
Code_species |
|
|
|
|
Validate On Set: |
No |
|
|
|
Local_name |
|
Memo |
|
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
1035 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Sinhala or Tamil names for species |
|
|
|
|
Ordinal Position: |
4 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Local_name |
|
|
|
|
Source Table: |
Code_species |
|
|
|
|
Validate On Set: |
No |
|
|
|
a_coefficient |
|
Number (Single) |
4 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
1005 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Coefficient of a for length(cm)/weight(kg) relationship w=al^b |
|
|
|
|
Ordinal Position: |
5 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
a_coefficient |
|
|
|
|
Source Table: |
Code_species |
|
|
|
|
Validate On Set: |
No |
|
|
|
b_coefficient |
|
Number (Single) |
4 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
795 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Coefficient of b for length(cm)/weight(kg) relationship w=al^b |
|
|
|
|
Ordinal Position: |
6 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
b_coefficient |
|
|
|
|
Source Table: |
Code_species |
|
|
|
|
Validate On Set: |
No |
|
|
|
Nominal_weight |
|
Number (Single) |
4 |
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
795 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Nominal weight for one individual in kilograms (used if no allometric relationship) |
|
|
|
|
Ordinal Position: |
7 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Nominal_weight |
|
|
|
|
Source Table: |
Code_species |
|
|
|
|
Validate On Set: |
No |
|
|
|
Relationships
Reference4
Attributes: One to Many, Enforced, Cascade Updates
Reference6
Attributes: One to Many, Enforced, Cascade Updates
Properties
|
Date Created: |
23/03/95 13:25:27 |
|
Last Updated: |
28/03/95 12:04:59 |
|
Def. Updatable: |
Yes |
|
Record Count: |
213 |
Columns
|
Name |
|
Type |
Size |
|
|
Species |
|
Text |
3 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
1 |
|
|
|
|
Column Width: |
1050 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
3 char species code |
|
|
|
|
Ordinal Position: |
2 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Species |
|
|
|
|
Source Table: |
Convert_number_to_weight |
|
|
|
|
Validate On Set: |
No |
|
|
|
Month |
|
Number (Double) |
8 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
1035 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Month (in numeric format) |
|
|
|
|
Format: |
General Number |
|
|
|
|
Ordinal Position: |
3 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Month |
|
|
|
|
Source Table: |
Convert_number_to_weight |
|
|
|
|
Validate On Set: |
No |
|
|
|
Weight_conversion |
|
Number (Double) |
8 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
Default |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Mean or nominal weight of the species |
|
|
|
|
Ordinal Position: |
4 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Weight_conversion |
|
|
|
|
Source Table: |
Convert_number_to_weight |
|
|
|
|
Validate On Set: |
No |
|
|
Relationships
Reference11
Attributes: One to One, Not Enforced
Properties
|
Date Created: |
28/02/95 15:45:52 |
|
Last Updated: |
24/03/95 13:49:25 |
|
Def. Updatable: |
Yes |
|
Record Count: |
48542 |
Columns
|
Name |
|
Type |
Size |
|
|
Site_code |
|
Text |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
1 |
|
|
|
|
Column Width: |
900 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
2 char site code |
|
|
|
|
Input Mask: |
>L>L;; |
|
|
|
|
Ordinal Position: |
1 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Site_code |
|
|
|
|
Source Table: |
Length_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Date |
|
Date/Time |
8 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
720 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Date of sample |
|
|
|
|
Format: |
d/m/yy |
|
|
|
|
Ordinal Position: |
2 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Date |
|
|
|
|
Source Table: |
Length_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Boat_number |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
840 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
0 |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Boat number of sample |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
3 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Boat_number |
|
|
|
|
Source Table: |
Length_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Species |
|
Text |
3 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
720 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Species sampled |
|
|
|
|
Input Mask: |
>L>L>L;; |
|
|
|
|
Ordinal Position: |
4 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Species |
|
|
|
|
Source Table: |
Length_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Sequence |
|
Number (Long) |
4 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size, Auto-Increment |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
1215 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
ACCESS generated sequence number to create unique key |
|
|
|
|
Format: |
General Number |
|
|
|
|
Ordinal Position: |
5 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Sequence |
|
|
|
|
Source Table: |
Length_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Length |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
1080 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Length (mm) FL for species |
|
|
|
|
Format: |
General Number |
|
|
|
|
Ordinal Position: |
6 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Length |
|
|
|
|
Source Table: |
Length_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=400 Or>10 |
|
|
|
|
Validation Text: |
Length is outside permitted range. |
|
|
Relationships
Reference7
Attributes: One to Many, Enforced, Cascade Deletes
Properties
|
Date Created: |
13/02/95 13:01:25 |
|
Description: |
Check sample size does not exceed boat numbers |
|
Record Count: |
661 |
|
Validation Text: |
Number of boats sampled in any categories must no exceed the number landing. |
|
Def. Updatable: |
Yes |
|
Last Updated: |
24/03/9513:50:53 |
|
Validation Rule: |
[UN1_landing]>=[UN1_sampled] And |
|
|
[UN2A_landing]>=[UN2A_sampled] And |
|
|
[UN2B_landing]>=[UN2B_sampled] And |
|
|
[UN3A_landing]>=[UN3A_sampled] And |
|
|
[UN3B_landing]>=[UN3B_sampled] And |
|
|
[UN4_landing]>=[UN4_sampled] And |
|
|
[UN5_landing]>=[UN5_sampled] |
Columns
|
Name |
|
Type |
Size |
|
|
Site_code |
|
Text |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
1 |
|
|
|
|
Column Width: |
825 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
2 char site code |
|
|
|
|
Input Mask: |
>L>L;; |
|
|
|
|
Ordinal Position: |
1 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Site_code |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Date |
|
Date/Time |
8 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
825 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Date of sample |
|
|
|
|
Format: |
d/m/yy |
|
|
|
|
Ordinal Position: |
2 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Date |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
UN1_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
885 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN1 s landing on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
3 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN1_landing |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number cannot exceed 100. |
|
|
|
UN2A_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
960 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN2As landing on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
4 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN2A_landing |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number cannot exceed 100. |
|
|
|
UN2B_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
930 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN2Bs landing on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
5 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN2B_landing |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number cannot exceed 100. |
|
|
|
UN3A_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
900 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN3As landing on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
6 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN3A_landing |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
|
|
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number cannot exceed 100. |
|
|
|
UN3B_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
855 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN3Bs landing on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
7 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN3B_landing |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number cannot exceed 100. |
|
|
|
UN4_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
885 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN4s landing on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
8 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN4_landing |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number cannot exceed 100. |
|
|
|
UN5_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
840 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN5s landing on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
9 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN5_landing |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number cannot exceed 100. |
|
|
|
UN1_sampled |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
795 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN1s sampled on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
10 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN1_sampled |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size should not exceed 40. |
|
|
|
UN2A_sampled |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
840 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN2As sampled on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
11 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN2A_sampled |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size should not exceed 40. |
|
|
|
UN2B_sampled |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
840 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN2Bs sampled on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
12 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN2B_sampled |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size should not exceed 40. |
|
|
|
UN3A_sampled |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
840 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN3As sampled on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
13 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN3A_sampled |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size should not exceed 40. |
|
|
|
UN3B_sampled |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
840 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN3Bs sampled on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
14 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN3B_sampled |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size should not exceed 40. |
|
|
|
UN4_sampled |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
825 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN4s sampled on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
15 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN4_sampled |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size should not exceed 40. |
|
|
|
UN5_sampled |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
795 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Description: |
Number of UN5s sampled on the sampling day |
|
|
|
|
Format: |
0 |
|
|
|
|
Ordinal Position: |
16 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN5_sampled |
|
|
|
|
Source Table: |
Sample_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size should not exceed 40. |
|
|
Relationships
Reference
Attributes: One to Many, Enforced, Cascade Updates, Cascade Deletes
Reference3
Attributes: One to Many, Enforced
Properties
|
Date Created: |
21/02/95 13:33:38 |
|
Last Updated: |
03/04/95 12:37:46 |
|
Def. Updatable: |
Yes |
|
Record Count: |
218 |
Columns
|
Name |
|
Type |
Size |
|
|
Site_code |
|
Text |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
1 |
|
|
|
|
Column Width: |
705 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
2 char site code |
|
|
|
|
Input Mask: |
>L>L;; |
|
|
|
|
Ordinal Position: |
1 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Site_code |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Date |
|
Date/Time |
8 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
720 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Date of sampling |
|
|
|
|
Format: |
d/m/yy |
|
|
|
|
Ordinal Position: |
2 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Date |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Boat_number |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
735 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of boat in the sample (1-n) |
|
|
|
|
Ordinal Position: |
3 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Boat_number |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Boat_type |
|
Text |
4 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
750 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Code for vessel type (UN1 etc) |
|
|
|
|
Input Mask: |
>L>L0>C;; |
|
|
|
|
Ordinal Position: |
4 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Boat_type |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Days_fished |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
780 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of days fished during trip |
|
|
|
|
Ordinal Position: |
5 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Days_fished |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=30 |
|
|
|
|
Validation Text: |
Number of days fished must not exceed 30. |
|
|
|
Main_gear |
|
Text |
5 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
735 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Gear combination |
|
|
|
|
Input Mask: |
>L>L>L>L>L;; |
|
|
|
|
Ordinal Position: |
6 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Main_gear |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
No_of_crew |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
510 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of crew |
|
|
|
|
Ordinal Position: |
7 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
No_of_crew |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=9 |
|
|
|
|
Validation Text: |
Number of crew must not exceed 9. |
|
|
|
Target_species |
|
Text |
3 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
645 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Species code for target species |
|
|
|
|
Input Mask: |
>L>L>L;; |
|
|
|
|
Ordinal Position: |
8 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Target_species |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Days_fished_last_month |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
690 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of days fished last month |
|
|
|
|
Ordinal Position: |
9 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Days_fished_last_month |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=31 |
|
|
|
|
Validation Text: |
Days fished last month cannot exceed 31. |
|
|
|
No_landings_last_month |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
630 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of landings made in previous month |
|
|
|
|
Ordinal Position: |
10 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
No_landings_last_month |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=25 |
|
|
|
|
Validation Text: |
Number of landings last month cannot exceed 25. |
|
|
|
YFT_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
615 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of yellowfin caught (kgs) |
|
|
|
|
Ordinal Position: |
11 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
YFT_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=20000 |
|
|
|
|
Validation Text: |
Weight must not exceed 20,000 kgs. |
|
|
|
SKT_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
630 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of skipjack caught (kgs) |
|
|
|
|
Ordinal Position: |
12 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
SKT_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=20000 |
|
|
|
|
Validation Text: |
Weight must not exceed 20,000 kgs. |
|
|
|
TUX_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
630 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of other tunas caught (kgs) |
|
|
|
|
Ordinal Position: |
13 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
TUX_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=20000 |
|
|
|
|
Validation Text: |
Weight must not exceed 20,000 kgs. |
|
|
|
KGX_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
615 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of seer fish caught (kgs) |
|
|
|
|
Ordinal Position: |
14 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
KGX_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=10000 |
|
|
|
|
Validation Text: |
Weight must not exceed 10,000 kgs. |
|
|
|
BIL_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
525 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of bill fish caught (kgs) |
|
|
|
|
Ordinal Position: |
15 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
BIL_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=10000 |
|
|
|
|
Validation Text: |
Weight must not exceed 10,000 kgs. |
|
|
|
MZZ_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
630 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of other bony fish caught (kgs) |
|
|
|
|
Ordinal Position: |
16 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
MZZ_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=10000 |
|
|
|
|
Validation Text: |
Weight must not exceed 10,000 kgs. |
|
|
|
RSK_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
585 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of requiem shark caught (kgs) |
|
|
|
|
Ordinal Position: |
17 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
RSK_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=10000 |
|
|
|
|
Validation Text: |
Weight must not exceed 10,000 kgs. |
|
|
|
LAM_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
555 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of mako caught (kgs) |
|
|
|
|
Ordinal Position: |
18 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
LAM_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=10000 |
|
|
|
|
Validation Text: |
Weight must not exceed 10,000 kgs. |
|
|
|
ALO_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
615 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of thresher shark caught (kgs) |
|
|
|
|
Ordinal Position: |
19 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
ALO_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=10000 |
|
|
|
|
Validation Text: |
Weight must not exceed 10,000 kgs. |
|
|
|
HAM_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
570 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of hammerhead shark caught (kgs) |
|
|
|
|
Ordinal Position: |
20 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
HAM_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=10000 |
|
|
|
|
Validation Text: |
Weight must not exceed 10,000 kgs. |
|
|
|
SKH_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
570 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of other sharks caught (kgs) |
|
|
|
|
Ordinal Position: |
21 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
SKH_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=10000 |
|
|
|
|
Validation Text: |
Weight must not exceed 10,000 kgs. |
|
|
|
SRX_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
615 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of skates and rays caught (kgs) |
|
|
|
|
Ordinal Position: |
22 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
SRX_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=10000 |
|
|
|
|
Validation Text: |
Weight must not exceed 10,000 kgs. |
|
|
|
MAM_weight |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
570 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Weight of mammals caught (kgs) |
|
|
|
|
Ordinal Position: |
23 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
MAM_weight |
|
|
|
|
Source Table: |
Supervisor_boat/catch_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=10000 |
|
|
|
|
Validation Text: |
Weight must not exceed 10,000 kgs. |
|
|
Relationships
Reference8
Attributes: One to Many, Enforced, Cascade Updates, Cascade Deletes
Reference9
Attributes: One to Many, Enforced, Cascade Updates
Properties
|
Date Created: |
21/02/95 13:15:51 |
|
Description: |
Check that sample size does not exceed number at site |
|
Record Count: |
65 |
|
Validation Text: |
The number of boats landing in any category must not exceed the number based at the site. |
|
Def. Updatable: |
Yes |
|
Last Updated: |
24/03/9513:53:59 |
|
Validation Rule: |
[UN1_based_at_port]>=[UN1_landing] And. |
|
|
[UN2A_based_at_port]>=[UN2A_landing] And |
|
|
[UN2B_based_at_port]>=[UN2B_landing] And |
|
|
[UN3A_based_at_port]>=[UN3A_landing] And |
|
|
[UN3B_based_at_port]>=[UN3B_landing] And |
|
|
[UN4_based_at_port]>=[UN4_landing] And |
|
|
[UN5_based_at_port]>=[UN5_landing] |
Columns
|
Name |
|
Type |
Size |
|
|
Site_code |
|
Text |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
1 |
|
|
|
|
Column Width: |
630 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
2 char site code |
|
|
|
|
Input Mask: |
>L>L;; |
|
|
|
|
Ordinal Position: |
1 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Site_code |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
Date |
|
Date/Time |
8 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
780 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Date of sampling |
|
|
|
|
Ordinal Position: |
2 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Date |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
UN1_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
735 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
|
|
|
|
|
|
Description: |
Number of UN1 landing on sampling day |
|
|
|
|
Ordinal Position: |
3 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN1_landing |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size must not exceed 40. |
|
|
|
UN2A_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
690 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN2A landing on sampling day |
|
|
|
|
Ordinal Position: |
4 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN2A_landing |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size must not exceed 40. |
|
|
|
UN2B_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
675 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN2B landing on sampling day |
|
|
|
|
Ordinal Position: |
5 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN2B_landing |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size must not exceed 40. |
|
|
|
UN3A_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
630 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN3A landing on sampling day |
|
|
|
|
Ordinal Position: |
6 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN3A_landing |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size must not exceed 40. |
|
|
|
UN3B_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
630 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN3B landing on sampling day |
|
|
|
|
Ordinal Position: |
7 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN3B_landing |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size must not exceed 40. |
|
|
|
UN4_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
600 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN4 landing on sampling day |
|
|
|
|
Ordinal Position: |
8 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN4_landing |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size must not exceed 40. |
|
|
|
UN5_landing |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
645 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN5 landing on sampling day |
|
|
|
|
Ordinal Position: |
9 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN5_landing |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=40 |
|
|
|
|
Validation Text: |
Sample size must not exceed 40. |
|
|
|
UN1_based_at_port |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
540 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN1 based at this port |
|
|
|
|
Ordinal Position: |
10 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN1_based_at_port |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number of boats at site must not exceed 100. |
|
|
|
UN2A_based_at_port |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
630 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN2A based at this port |
|
|
|
|
Ordinal Position: |
11 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN2A_based_at_port |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number of boats at site must not exceed 100. |
|
|
|
UN2B_based_at_port |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
660 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN2B based at this port |
|
|
|
|
Ordinal Position: |
12 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN2B_based_at_port |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number of boats at site must not exceed 100. |
|
|
|
UN3A_based_at_port |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
690 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN3A based at this port |
|
|
|
|
Ordinal Position: |
13 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN3A_based_at_port |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number of boats at site must not exceed 100. |
|
|
|
UN3B_based_at_port |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
675 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN3B based at this port |
|
|
|
|
Ordinal Position: |
14 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN3B_based_at_port |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number of boats at site must not exceed 100. |
|
|
|
UN4_based_at_port |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
555 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN4 based at this port |
|
|
|
|
Ordinal Position: |
15 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN4_based_at_port |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number of boats at site must not exceed 100. |
|
|
|
UN5_based_at_port |
|
Number (Integer) |
2 |
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Fixed Size |
|
|
|
|
Collating Order: |
Unknown or Undefined |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
585 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Decimal Places: |
Auto |
|
|
|
|
Default Value: |
0 |
|
|
|
|
Description: |
Number of UN5 based at this port |
|
|
|
|
Ordinal Position: |
16 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
UN5_based_at_port |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
|
|
Validation Rule: |
<=100 |
|
|
|
|
Validation Text: |
Number of boats at site must not exceed 100. |
|
|
|
Comment |
|
Memo |
|
|
|
|
Allow Zero Length: |
No |
|
|
|
|
Attributes: |
Variable Length |
|
|
|
|
Collating Order: |
General |
|
|
|
|
Column Hidden: |
No |
|
|
|
|
Column Order: |
Default |
|
|
|
|
Column Width: |
3450 |
|
|
|
|
Data Updatable: |
No |
|
|
|
|
Description: |
Comment for sampling day |
|
|
|
|
Ordinal Position: |
17 |
|
|
|
|
Required: |
No |
|
|
|
|
Source Field: |
Comment |
|
|
|
|
Source Table: |
Supervisor_site_details |
|
|
|
|
Validate On Set: |
No |
|
|
Relationships
Reference10
Attributes: One to Many, Enforced
Reference8
Attributes: One to Many, Enforced, Cascade Updates, Cascade Deletes
Relationships
Reference
Attributes: One to Many, Enforced, Cascade Updates, Cascade Deletes
Reference1
Attributes: One to Many, Enforced, Cascade Updates, Cascade Deletes
Reference10
Attributes: One to Many, Enforced
Reference11
Attributes: One to One, Not Enforced
Reference2
Attributes: One to Many, Enforced, Cascade Updates
Reference3
Attributes: One to Many, Enforced
Reference4
Attributes: One to Many, Enforced, Cascade Updates
Reference5
Attributes: One to Many, Enforced
Reference6
Attributes: One to Many, Enforced, Cascade Updates
Reference7
Attributes: One to Many, Enforced, Cascade Deletes
Reference8
Attributes: One to Many, Enforced, Cascade Updates, Cascade Deletes
Reference9
Attributes: One to Many, Enforced, Cascade Updates
Properties
|
Date Created: |
29/03/95 09:25:22 |
|
Owner: |
admin |
|
Last Updated: |
30/03/95 09:08:04 |
Code
|
1 |
Option Compare Database 'Use database order for string comparisons |
|
2 |
|
|
3 |
Sub Update_Total_weight () |
|
4 |
|
|
5 |
Dim MainDb As Database, Catch As Recordset, Conversion As Recordset, Number to weight As Long, SMonth As Integer, Av_weight As Long |
|
6 |
|
|
7 |
Set MainDb = DBEngine.Workspaces(0).Databases(0) |
|
8 |
Set Catch = MainDb.OpenRecordset("Catch_detaiIs") |
|
9 |
Set Conversion = MainDb.OpenRecordset<"Convert_number_to_weight") |
|
10 |
|
|
11 |
Catch.MoveFirst |
|
12 |
|
|
13 |
Do Until Catch.EOF |
|
14 |
|
|
15 |
'Initialise local variables |
|
16 |
Number to weight = 0 |
|
17 |
Av_weight = 0 |
|
18 |
|
|
19 |
'See if Catch is recorded in numbers |
|
20 |
If Catch![Number] > 0 Then |
|
21 |
|
|
22 |
SMonth = Month(Catch![Date]) |
|
23 |
|
|
24 |
Conversion.Index = "PrimaryKey" |
|
25 |
Conversion.Seek "=", Catch![Species], SMonth |
|
26 |
|
|
27 |
If Conversion.NoMatch Then |
|
28 |
|
|
29 |
MsgBox "Conversion table is not complete" |
|
30 |
Exit Sub |
|
31 |
|
|
32 |
Else |
|
33 |
Av_weight = Conversion![Weight_conversion] |
|
34 |
End If |
|
35 |
End If |
|
36 |
|
|
37 |
Number_to_weight = Catch![Number] * Av_weight |
|
38 |
|
|
39 |
Catch.Edit |
|
40 |
Catch![Calc_weight] = Number_to_weight + Catch![Weight] |
|
41 |
Catch.Update |
|
42 |
|
|
43 |
Catch.MoveNext |
|
44 |
|
|
45 |
Loop |
|
46 |
|
|
47 |
Catch.Close |
|
48 |
Conversion.Close |
|
49 |
|
|
50 |
|
|
51 |
End Sub |
|
52 |
|
Boat_description
03/04/95
|
Boat_code |
Boat_type |
|
TR5 |
Mechanised traditional orru |
|
Single day boats - assumed to be fishing in COASTAL WATERS |
|
|
UN1 |
5.5 - 7.2 m (17'-21') FRP dinghy |
|
Outboard engine - 8-70 HP (usually 15-25 HP) |
|
|
Single day boats - assumed to be fishing in COASTAL WATERS |
|
|
UN2A |
8.8 - 9.8 m (28'-34') displacement hull. FRP or wooden. |
|
Inboard engine (single) - 40 HP |
|
|
No ice box or insulated fish hold only - no gear hauler, nav or acoustic equipment. |
|
|
Single day boats - assumed to be fishing in COASTAL WATERS |
|
|
UN2B |
8.8 - 9.8 m (28'-34') displacement hull. FRP or wooden. |
|
Inboard engine (single) - 40 HP |
|
|
Insulated fish hold - no gear hauler, may have GPS/sounder/fish finder |
|
|
Multi-day boats - assumed to be fishing in OFFSHORE WATERS |
|
|
UN3A |
9.8 -12.2 m (34'-40') displacement hull. FRP or wooden. |
|
Inboard engine (single) - 60 HP - [includes Abu Dhabi vessels] |
|
|
Insulated fish hold and may have gear hauler/GPS/sounder/fish finder |
|
|
Multi-day boats - assumed to be fishing in OFFSHORE WATERS |
|
|
UN3B |
12.2m- (40'-) displacement hull. FRP or wooden. |
|
Inboard engine (single) - 60+ HP |
|
|
Insulated fish hold and may have freezer facilities. Gear hauler/GPS/sounder/fish finder |
|
|
Multi-day boats - assumed to be fishing in OFFSHORE WATERS |
|
|
UN4 |
Reserved for vessel category eg. 15.2 -18.3 m (50'-60') |
|
UN5 |
Reserved for vessel category eg. 18.3m+ (60'+) |
Code_site
24/03/95
|
Site_code |
Site_name |
Statistical_zone |
|
BA |
Batticoloa |
East |
|
BE |
Beruwala |
Southwest |
|
CW |
Chilaw |
Northwest |
|
DO |
Dondra |
South |
|
GA |
Galle |
Southwest |
|
GD |
Gandara |
South |
|
HA |
Hambantota |
Southeast |
|
KI |
Kalmunai |
East |
|
KM |
Kalmetiya |
Southeast |
|
KO |
Kottegoda |
South |
|
KR |
Kirinda |
Southeast |
|
KU |
Kudawela |
Southeast |
|
KY |
Kandakuliya |
Northwest |
|
MA |
Matara |
South |
|
MI |
Mirissa |
South |
|
MU |
Colombo (Mutwal) |
West |
|
NE |
Negombo |
West |
|
TA |
Tangalle |
Southeast |
|
TR |
Trincomalee |
Northeast |
|
WE |
Weligama |
South |
Code_gear
8/03/9
|
Gear_c |
Gear_description |
|
BB |
Pole and line |
|
GN |
Gillnet |
|
HL |
Hand line |
|
HN |
Harpoon |
|
LL |
Longline |
|
OT |
Other |
|
PS |
Purse seine |
|
RN |
Ring net |
|
TL |
Troll line |
Code_species
24/03/95
|
Species_c |
Common_name |
Scientific_name |
Local_name |
a_coefficient |
b_coefficient |
Nominal_v |
|
ALO |
Thresher sharks |
ALOPIIDAE |
|
|
|
35 |
|
AMS |
|
Ambyglaster sirm |
Hurulla |
|
|
|
|
BAR |
|
Sphyraena sp |
Jeelawa |
|
|
|
|
BET |
Bigeye tuna |
Thunnus obesus |
|
0.00002396 |
2.98 |
69.5 |
|
BIL |
Other billfish |
|
|
0.000002042 |
3.318 |
4.87 |
|
BIS |
|
Selar crumenophthalmus |
Bolla |
|
|
|
|
BLT |
Bullet tuna |
Auxis rocheii |
|
0.000017 |
3 |
0.22 |
|
BSH |
Blue shark |
Prionace glauca |
|
|
|
30 |
|
COM |
Narrow-barred king mackerel |
Scomberomorus commerson |
|
0.00001176 |
2.9002 |
5.4 |
|
DEC |
|
Decapterus macarellus |
Linna |
|
|
|
|
DOB |
|
Chirocentrus dorab |
Katuwalla |
|
|
|
|
DUS |
|
Dussumieria sp |
Thonda hurull |
|
|
|
|
FAL |
Silky shark |
Charcharhinus falciformis |
|
|
|
28 |
|
FRI |
Frigate tuna |
Auxis thazard |
|
0.000017 |
3 |
0.66 |
|
FUS |
|
Caesio sp |
Ratta |
|
|
|
|
GAZ |
|
Gazza sp |
Mas karalla |
|
|
|
|
HAM |
Hammerhead sharks |
SPHYRINIDAE |
|
|
|
40 |
|
HES |
|
Herklotsichthys quad. |
Koraburuwa |
|
|
|
|
KAW |
Kawakawa |
Euthynnus affinis |
|
0.000026 |
2.9 |
2.05 |
|
KGX |
Other seerfish |
SCOMBRIDAE |
|
0.00001176 |
2.9002 |
4.21 |
|
KOW |
|
Escualosa thoracata |
Vella sudaya |
|
|
|
|
LEO |
|
Leignathus sp |
Katu karalla |
|
|
|
|
MAM |
Marine mammals |
MAMMALIA |
|
|
|
30 |
|
MAR |
Marlin (all species) |
Makaria spp. |
|
0.0000081 |
3.033 |
108.31 |
|
MSK |
Mako sharks |
LAMNIDAE |
|
|
|
38 |
|
MZZ |
Other bony fish |
OSTEIICHTHYES |
|
|
|
1.5 |
|
OPL |
|
Opisthopterus tardoone |
Thottawa |
|
|
|
|
OTH |
Other bait types |
|
|
|
|
|
|
OWT |
Oceanic white tipped shark |
Charcharhinus longimanus |
|
|
|
25 |
|
PEO |
|
Pellona sp |
Venganawa |
|
|
|
|
RAX |
|
Rastrelliger sp |
Kumbalawa |
|
|
|
|
RSK |
Other requieum |
CHARCHARHINIDAE |
|
|
|
28 |
|
SAA |
White sardine |
|
Sudaya |
|
|
|
|
SAG |
|
Sardinella gibbosa |
Matta alaya |
|
|
|
|
SAS |
|
Sardinella sudensis |
Kalawanna |
|
|
|
|
SEC |
|
Secutor sp |
Salli karalla |
|
|
|
|
SFA |
Indo-Pacific sailfish |
Istiphorus platypterus |
|
0.00001577 |
2.819 |
30.8 |
|
SIX |
Other sardinella |
|
|
|
|
|
|
SKH |
Other sharks |
ELASMORANCHS |
|
|
|
15 |
|
SKL |
Skipjack tuna (large) |
Katsuwonu pelamis |
|
0.000006 |
3.3 |
4.98 |
|
SKM |
Skipjack tuna (medium) |
Katsuwonus pelamis |
|
0.000006 |
3.3 |
3.25 |
|
SKS |
Skipjack tuna (small) |
Katsuwonus pelamis |
|
0.000006 |
3.3 |
2.2 |
|
SRX |
Skates and rays |
|
|
|
|
40 |
|
STB |
|
Sardinella betariensis |
Potaya |
|
|
|
|
STH |
|
Stolephorus beterolobus |
Handella |
|
|
|
|
STO |
Other anchovy |
STOLEPHORUS |
|
|
|
|
|
SWO |
Swordfish |
Xiphias gladius |
|
0.00000633 |
3.1605 |
30.27 |
|
THR |
|
Thryssa spp |
Lagga |
|
|
|
|
TUX |
Other tuna |
SCOMBRIDAE |
|
0.000041 |
2.8 |
1.66 |
|
WAH |
Wahoo |
Acanthocybium solandri |
|
0.000001544 |
3.2945 |
6.49 |
|
YFL |
Yellowfin tuna (large) |
Thunnus albacares |
|
0.000041 |
2.8 |
26.54 |
|
YFM |
Yellowfin tuna (medium) |
Thunnus albacares |
|
0.000041 |
2.8 |
5.71 |
|
YFS |
Yellowfin tuna (small) |
Thunnus albacares |
|
0.000041 |
2.8 |
3.86 |
