[다시]ERD 연습문제 4
테이블 (6)
Untitled (dependent)
- Key (did) — int(5) — 기본 키 — NOT NULL
- Field (dname) — char(20)
- Field (dage) — int(3)
- Field (dgender) — char(10)
- Key (ssn2) — int(5) — 외래 키 → customer.Key — NOT NULL
Untitled (belong)
- Key (bcode) — char(20) — 기본 키 — NOT NULL
- Field (btype) — char(20)
- Field (bname) — char(20)
Untitled (server)
- Key (scode) — char(20) — 기본 키 — NOT NULL
- Field (sname) — char(20)
- Field (saddress) — char(20)
- Field (sphone) — int(11)
- Key (secode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (bcode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled (service)
- Key (secode) — char(20) — 기본 키 — NOT NULL
- Field (sename) — char(20)
- Field (sedescription) — text
- Field (seGiveDate) — date
Untitled (customer_server)
- Key (secode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Key (scode) — char(20) — 외래 키 → Untitled.Key — NOT NULL
- Field (seGiveDate) — date
customer
- Key (cid) — int(5) — 기본 키 — NOT NULL
- Field (cname) — char(20)
- Field (caddress) — char(20)
- Field (cphone) — int(15)
- Field (cage) — int(3)
- Field