Data design
Tables (3)
material (material component)
- material_id (Key) — INT — Primary key — NOT NULL — experiment_id
- component_name (Field) — VARCHAR(50) — NOT NULL — component_name
- weight_percentage (Field2) — Float — NOT NULL — weight_percentage
- purify (Field3) — Float — NOT NULL — purify
- process_id (Key2) — INT — Foreign key → process.process_id — NOT NULL — procedure_id
process
- process_id (Key) — INT — Primary key — NOT NULL — procedure_id
- fiing_tempt (Field) — FLOAT — NOT NULL — firing_tempt
- firing_time (Field2) — FLOAT — NOT NULL — firing_time
- atmosphere (Field3) — VARCHAR(20) — NOT NULL — atmosphere
- heating_rate (Field4) — FLOAT — NOT NULL — heating_rate
test_result
- test_id (Key) — INT — Primary key — NOT NULL — test_id
- process_id (Key2) — INT — Foreign key → process.process_id — NOT NULL — procedure_id
- material_id (Key3) — INT — Foreign key → material.material_id — NOT NULL — experiment_id
- status (Field) — VARCHAR(100) — NOT NULL — status