Service
Tables (4)
Customer (sCustomer)
- cID — INT — Primary key — NOT NULL
- name — varchar(40)
- address — varchar(40)
- phone — varchar(15)
- pID — INT — Foreign key → Product.pID — NOT NULL
Employee (sEmployee)
- Key (eID) — varchar(20) — Primary key — NOT NULL
- Field (name) — varchar(40)
- Field (position) — varchar(30)
- Field (phone) — varchar(15)
Product (sProduct)
- pID — INT — Primary key — NOT NULL
- kind (model) — varchar(20)
Untitled (sRepair)
- Key (seq) — INT — Primary key — NOT NULL
- Field (date) — varchar(30)
- cID — INT — Foreign key → Customer.cID — NOT NULL
- Key (eID) — varchar(20) — Foreign key → Employee.Key — NOT NULL