2번 문제

테이블 (7)

Untitled (ACTIVITY)

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

Untitled (CLASS)

  • Key (ID) — char(50) — 기본 키 — NOT NULL
  • Field (activity code) — char(50)
  • Field (time) — char(50)
  • Field (contrnt) — text
  • Key (name) — char(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (MEMBER)

  • Key (name) — char(80) — 기본 키 — NOT NULL
  • Field (address) — char(80)
  • Field (age) — char(80)
  • Field (phone) — char(80)
  • Field (grade) — char(80)

Untitled (CLASS-MEMBER)

  • Key (name) — char(80) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ID) — char(50) — 외래 키 → Untitled.Key — NOT NULL

Untitled (TIME)

  • Key (start time) — char(50) — 기본 키 — NOT NULL
  • Field (finish time) — char(50)

Untitled (CLASS-TIME)

  • Key (ID) — char(50) — 외래 키 → Untitled.Key — NOT NULL
  • Key (start time) — char(50) — 외래 키 → Untitled.Key — NOT NULL

message (MESSAGE)

  • Key (personnel) — char(80) — 기본 키 — NOT NULL
  • Field (linit personnel) — char(50)
  • Field (registered personnel) — char(80)
  • Key (name) — char(80) — 외래 키 → Untitled.Key — NOT NULL
  • Key (ID) — char(50) — 외래 키 → Untitled.Key — NOT NULL