2024_2_db_ex2-1
Tables (4)
Untitled (활동)
- Key (활동코드) — char(10) — Primary key — NOT NULL
- Field (활동명) — char(20)
- Field (활동설명) — text
Untitled (클래스)
- Key (클래스 아이디) — char)10) — Primary key — NOT NULL
- Key (활동코드) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (클래스이름) — char(10)
- Field (클래스시간) — char(20)
- Field (클래스사이즈(정원)) — int(3)
- Field (클래스레벨) — char(4)
- Field (클래스강사) — char(10)
- Field (클래스가격) — int(10)
- Field (클래스위치) — char(20)
- Field (년도) — char(4)
- Field (월) — char(2)
Untitled (회원)
- Key (회원코드) — char(10) — Primary key — NOT NULL
- Field (회원이름) — char(20)
- Field (회원주소) — char(50)
- Field (회원전화번호) — char(11)
- Field (회원생년월일) — date
- Field (성별) — char(1)
Untitled (등록)
- Key (회원코드) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (클래스 아이디) — char)10) — Foreign key → Untitled.Key — NOT NULL
- Key (활동코드) — char(10) — Foreign key → Untitled.Key — NOT NULL