개인과제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