15주차
테이블 (3)
orders (o100)
- oid (o100) — NOT NULL — 기본 키 — NOT NULL
- date (2015-10-15) — NOT NULL
- phone (123-4567) — NOT NULL
- products pid (p111,p222) — NOT NULL
orders (o200)
- oid (o200) — NOT NULL — 기본 키 — NOT NULL
- date (2015-10-16) — NOT NULL
- phone (555-3434) — NOT NULL
- products pid (p333) — NOT NULL
products (pid)
- oid (o100) — NOT NULL — 외래 키 → orders.oid — NOT NULL
- oid (o200) — NOT NULL — 외래 키 → orders.oid — NOT NULL
- p111 (세탁기) — NOT NULL
- p222 (컴퓨터) — NOT NULL
- p333 (냉장고) — NOT NULL