Bridge Status Report
Attribute Name Attribute Type Field Length Key Description Sample
BSReport_Number Number 5 PK Identifies each Report individually 11226
BSReport_BridgeNo. Number 5   Bridge that is being reported 87767
BSReport_Description Character 50   Description of the Report Good status
BSReport_Date Date 10   Date the Report was made 5-Apr-01
BSReport_Author Character 20   Person who prepared the report Neil
BSReport_Inspector Character 20   Person who checked the bridge Sam