개인과제2

테이블 (5)

Activity

  • activity_code (Key) — int(20) — 기본 키 — NOT NULL
  • activity_name (Field) — char(20)
  • description (Field2) — text

Course

  • course_ID (Key) — int(20) — 기본 키 — NOT NULL
  • activity_code (Key3) — int(20) — 외래 키 → Activity.activity_code — NOT NULL
  • time_Info (Field) — date
  • max_registration (Field2) — int(20)
  • current_registration (Field3) — int(20)

Difficulty Level

  • level_id (Key) — int(20) — 기본 키 — NOT NULL
  • level_name (Field) — char(20)

Member

  • member_id (Key) — int(20) — 기본 키 — NOT NULL
  • member_name (Field) — cha(20)
  • address (Field2) — char(20)
  • age (Field3) — int(20)

Registration

  • registration_id (Key) — int(20) — 기본 키 — NOT NULL
  • member_id (Key2) — int(20) — 외래 키 → Member.member_id — NOT NULL
  • course_ID (Key3) — int(20) — 외래 키 → Course.course_ID — NOT NULL
  • activity_code (Key32) — int(20) — 외래 키 → Course.activity_code — NOT NULL
  • level_id (Key4) — int(20) — 외래 키 → Difficulty Level.level_id — NOT NULL