과제 3

테이블 (10)

Untitled (CUSTOMER INFORMATION)

  • Key (ID number) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(30)
  • Field (phone) — char(30)

Untitled (DEPENDANT)

  • Key (dependant ID number) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (age) — char(30)
  • Key (ID number2) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SERVICES ANAILABLE)

  • Key (vocational education) — 기본 키 — NOT NULL
  • Key (explain) — text — 외래 키 → Untitled.Key — NOT NULL

Untitled (SERVICE PROVIDER)

  • Key (state the agent) — text — 기본 키 — NOT NULL
  • Key (ID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (TIME)

  • Key (p\rovide the date) — char(30) — 기본 키 — NOT NULL

Untitled (AVALABLE INFORMATION)

  • Key (explain) — text — 기본 키 — NOT NULL
  • Field (code) — char(30)

Untitled (SRVICE PROVIDER INFORMATON)

  • Key (ID) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(30)
  • Field (phone)

Untitled (CUSTOMER INFORMATON-TIME)

  • Key (ID number) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (p\rovide the date) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (CURTOMER INFORMATION-SEVICE PROVIDER)

  • Key (ID number) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (state the agent) — text — 외래 키 → Untitled.Key — NOT NULL

Untitled (CUSTOMER INFORMATION-SERVICES ANAILABLE)

  • Key (ID number) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (vocational education) — 외래 키 → Untitled.Key — NOT NULL