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