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)