빠따2

테이블 (4)

ACTIVITY (Untitled)

  • class (Key2) — char(20) — 기본 키 — NOT NULL
  • class_no (Key3) — char(20) — 외래 키 → CLASS_info.class_no — NOT NULL
  • MemberID (Key6) — char(10) — 외래 키 → CLASS_info.MemberID — NOT NULL
  • description (Field2) — char(100)
  • sports_code (Key) — char(10) — NOT NULL
  • sportsname (Key4) — 외래 키 → SPORTS.sportsname — NOT NULL

CLASS_info (Untitled2)

  • class_no (Key) — char(20) — 기본 키 — NOT NULL
  • MemberID (Key6) — char(10) — 외래 키 → CLIENTS.MemberID — NOT NULL
  • act_no (Key2) — char(10) — NOT NULL
  • time (Key3) — float — NOT NULL
  • num_max (Key4) — char(100) — NOT NULL
  • num_present (Key5) — char(100) — NOT NULL
  • classlevel (Key7) — char(10) — NOT NULL

CLIENTS (Untitled3)

  • MemberID (Key) — char(10) — 기본 키 — NOT NULL
  • adress (Field) — char(100)
  • age (Field2) — integer
  • name (Key2) — char(10) — NOT NULL

SPORTS (Untitled4)

  • sportsname (Key) — 기본 키 — NOT NULL