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