Donggukelectronics
Tables (4)
Untitled (employee)
- Key (e_number) — Primary key — NOT NULL
- Field (name)
- Field2 (position)
- Field (salary)
- Field (location)
Untitled (part)
- Key (p_name) — Primary key — NOT NULL
- Field (stock)
- Field (price)
Untitled2 (customer)
- Key (c_name) — Primary key — NOT NULL
- Key (model) — Primary key — NOT NULL
- Field (location)
- Field (date)
- Field (fee)
Untitled3 (service)
- Key (number) — Primary key — NOT NULL
- Key (e_number) — Foreign key → Untitled.Key — NOT NULL
- Key (c_name) — Foreign key → Untitled2.Key — NOT NULL
- Key (model) — Foreign key → Untitled2.Key — NOT NULL
- Key (p_name) — Foreign key → Untitled.Key — NOT NULL
- Field (date)
- Field (fee)
- Field (note)