Door
Tables (4)
Component (component)
- ComponentID (Key) — INT — Primary key — NOT NULL
- ComponentName (Field) — VARCHAR(50)
Door (door)
- DoorID (Key) — int — Primary key — NOT NULL
- DoorName (Field) — VARCHAR(50)
Inspection (inspection)
- InspectionID (Key) — INT — Primary key — NOT NULL
- ComponentID (Key2) — INT — Foreign key → Component.ComponentID — NOT NULL
- ROIID (Key3) — INT — Foreign key → ROI.ROIID — NOT NULL
- DoorID (Key22) — int — Foreign key → ROI.DoorID — NOT NULL
- Status (Field3) — VARCHAR(20)
ROI (roi)
- ROIID (Key) — INT — Primary key — NOT NULL
- DoorID (Key2) — int — Foreign key → Door.DoorID — NOT NULL
- Xposition (Field2) — INT
- Yposition (Field3) — INT