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