과제2번

테이블 (4)

class (Untitled2)

  • class id (Key) — char(10) — 기본 키 — NOT NULL
  • codenumber (Key2) — char(10) — 외래 키 → leports activity.codenumber — NOT NULL
  • class time (Field) — char(5)
  • registlation limit (Field2) — char(10)
  • number of registerd member (Field3) — char(10)
  • level (Field4) — char(10)
  • classname (Field5)
  • price (Field6)
  • location (Field7)
  • lecturer (Field8)

class-member (Untitled4)

  • class id (Key) — char(10) — 외래 키 → class.class id — NOT NULL
  • codenumber (Key2) — char(10) — 외래 키 → class.codenumber — NOT NULL
  • member id (Key3) — char(10) — 외래 키 → member.member id — NOT NULL

leports activity (Untitled)

  • codenumber (Key) — char(10) — 기본 키 — NOT NULL
  • description (Field) — char(20)
  • name (Field2) — char(10)

member (Untitled3)

  • member id (Key) — char(10) — 기본 키 — NOT NULL
  • name (Field) — char(10)
  • adress (Field2) — char(20)
  • age (Field3) — char(10)
  • birthdate (Field5)