Test Data

Tables (6)

Engineer (Untitled6)

  • Engineer_ID (Key) — char(8) — Primary key — NOT NULL

Operator (Untitled4)

  • Operator_ID (Key) — char(8) — Primary key — NOT NULL
  • Name (Field) — varchar(30)
  • Country (Field2) — char(8)
  • age (Field3) — char(8)
  • gender (Field4) — char(8)
  • Company (Field5) — char(8)
  • experience (Field6) — char(8)

Sensor (Untitled2)

  • Sensor_ID (Key) — char(8) — Primary key — NOT NULL
  • Type (Field) — char(8)
  • serial number (Field2) — char(8)
  • Manufacturer (Field3) — char(8)

Site (Untitled5)

  • Site_ID (Key) — char(8) — Primary key — NOT NULL
  • Name (Field) — varchar(30)
  • Type (Field2) — char(8)
  • Address (Field3) — varchar(30)

Test (Untitled3)

  • Test_ID (Key) — char(8) — Primary key — NOT NULL
  • Name (Field) — char(30)
  • Description (Field2) — varchar(30)
  • Date (Field3) — char(8)
  • Data (Field5) — char(8)
  • Type (Field4) — char(8)
  • Equipment_ID (Key2) — char(30) — Foreign key → Test object Equipment.Equipment_ID — NOT NULL
  • Sensor_ID (Key3) — char(8) — Foreign key → Sensor.Sensor_ID — NOT NULL
  • Site_ID (Key4) — char(8) — Foreign key → Site.Site_ID — NOT NULL
  • Operator_ID (Key5) — char(8) — Foreign key → Operator.Operator_ID — NOT NULL
  • Engineer_ID (Key6) — char(8) — Foreign key → Engineer.Engineer_ID — NOT NULL

Test object Equipment (Untitled)

  • Equipment_ID (Key) — char(30) — Primary key — NOT NULL
  • Name (Field) — varchar(30)
  • Build date (Field2) — char(8)
  • Type (Field3) — char(8)
  • serial number (Field4) — char(8)
  • size (Field5) — char(8)
  • options (Field6) — char(8)