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