연습문제2번_다른버젼

테이블 (4)

Activity (Untitled)

  • activity_code (PK) (char(5)(PK)) — 기본 키 — NOT NULL
  • activity_name (char(30))
  • description (text)

Class (Untitled2)

  • class_id (PK) (int(6)(PK)) — 기본 키
  • activity_code (FK) (char(5)(FK)) — 외래 키 → Activity.activity_code (PK) — NOT NULL
  • time_info (char(20))
  • max_participants (int(100))
  • current_participants (int(30))

Member (Untitled3)

  • member_id (PK) (int(6)(PK)) — 기본 키
  • name (char(30))
  • address (char(50))
  • age (int(2))

Registration (Untitled4)

  • member_id (PK)(FK) (int(6)) — 기본 키
  • class_id (PK) (int(6)(PK)) — 외래 키 → Class.class_id (PK)
  • activity_code (FK) (char(5)(FK)) — 외래 키 → Class.activity_code (FK) — NOT NULL
  • member_id (PK) (int(6)(PK)2) — 외래 키 → Member.member_id (PK)
  • class_id (PK)(FK) (int(10))
  • registration_date (date)
  • level (char(10))