연습문제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))