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