2연습

테이블 (4)

ACTIVITY

  • actCode (code) — char(20) — 기본 키 — NOT NULL
  • name — char(30)
  • desoription (Field2) — int

CLASS

  • classID — integer — 기본 키 — NOT NULL
  • actCode (code2) — char(20) — 외래 키 → ACTIVITY.actCode — NOT NULL
  • clsaaName (className) — char(30)
  • year — integer(4)
  • month — integer(2)
  • level — char(2)
  • description (price) — text
  • price (description) — integer(10)
  • actCode (code) — char(20) — 외래 키 → ACTIVITY.actCode — NOT NULL
  • Key (lectuerID) — 외래 키 → Untitled.Key — NOT NULL

CLASS_TIME

  • classID — integer — 외래 키 → CLASS.classID — NOT NULL
  • Field (timeID) — int

Untitled (LECTURER)

  • Key (lectuerID) — char(20) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field2 (address) — int
  • Field3 (phone)