빠따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