Bridge Job Schedule
Attribute Name Attribute Type Field Length Key Description Sample
BJSchedule_Number Number 5 PK Identifies each schedule individually 87612
BJSchedule_BridgeNo Number 5   Bridge for which schedule is done 7765
BJSchedule_Description Character 50   Description of the job Routine Check
BJSchedule_JobType Character 30   Type of the job Maintenance
BJSchedule_Location Character 30   Location of the bridge Genessee
BJSchedule_Sdate Date 10   Start Date of the Job 13-Jun-00
BJSchedule_Duration Number 4   Approximate duration of the Job(days) 12