DB A/S

Tables (6)

Branch

  • brid (br_id) — CHAR(6) — Primary key — NOT NULL
  • brname (br_name) — VARCHAR(12) — NOT NULL
  • brnumber (br_number) — VARCHAR(14) — NOT NULL
  • bremployeenumber (br_em_num) — INT — NOT NULL

Customer

  • cuid (cu_id) — CHAR(6) — Primary key — NOT NULL
  • cuname (cu_name) — VARCHAR(5) — NOT NULL
  • cunumber (cu_number) — VARCHAR(14) — NOT NULL

Employee

  • emid (em_id) — CHAR(6) — Primary key — NOT NULL
  • emname (em_name) — VARCHAR(5) — NOT NULL
  • emnumber (em_number) — VARCHAR(14) — NOT NULL
  • brid (br_id) — CHAR(6) — Foreign key → Branch.brid — NOT NULL

Product

  • prid (pr_id) — CHAR(6) — Primary key — NOT NULL
  • cuid (cu_id) — CHAR(6) — Foreign key → Customer.cuid — NOT NULL
  • prname (pr_name) — VARCHAR(12) — NOT NULL

Receipt

  • reid (re_id) — CHAR(6) — Primary key — NOT NULL
  • prid (pr_id) — CHAR(6) — Foreign key → Product.prid — NOT NULL
  • cuid (cu_id) — CHAR(6) — Foreign key → Product.cuid — NOT NULL
  • brid (br_id) — CHAR(6) — Foreign key → Branch.brid — NOT NULL
  • date — DATE

Repair

  • repid (rep_id) — CHAR(6) — Primary key — NOT NULL
  • prid (pr_id) — CHAR(6) — Foreign key → Product.prid — NOT NULL
  • cuid (cu_id) — CHAR(6) — Foreign key → Product.cuid — NOT NULL
  • repdate (rep_date) — DATE — NOT NULL
  • repcost (rep_cost) — VARCHAR(20) — NOT NULL
  • emid (em_id) — CHAR(6) — Foreign key → Employee.emid — NOT NULL