Figure 4. Study Fleet database model for the work table structure. “PK” indicates a database primary key, and “FK” indicates a database foreign key. Field formats, not null constraints, and indices are also shown. Accessory support tables for gear codes, ports, species, and dealers are not shown in this model.