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