toy

Tables (5)

Company (company)

  • id — long — Primary key — NOT NULL
  • cname — varchar

Machine (machine)

  • id — Primary key — NOT NULL
  • mname
  • pc_id — long — Foreign key → Product.id — NOT NULL
  • o_id — Foreign key → OrderProcess.id — NOT NULL
  • schedule (Field)

OrderProcess (orderprocess)

  • id — Primary key — NOT NULL
  • pc_id — long — Foreign key → Product.id — NOT NULL
  • p_id — long — Foreign key → Process.id — NOT NULL
  • idx

Process (process)

  • id — long — Primary key — NOT NULL
  • job
  • category

Product (product)

  • id — long — Primary key — NOT NULL
  • pname
  • p_id (c_id) — long — Foreign key → Company.id — NOT NULL