도서관 커뮤니티 프로그램 관리 시스템
테이블 (5)
Member (MEMBER)
- Key (memberID) — serial — 기본 키 — NOT NULL
- Field (name) — varchar(20)
- Field (phone) — varchar(14)
- Field (address) — varchar(50)
- Field (certification) — varchar(20)
Untitled (PLACE)
- Key (placeID) — serial — 기본 키 — NOT NULL
- Field (placeName) — varchar(20)
- Field (capacity) — integer
- Field (equipmentInfo) — text
Untitled (PROGRAM)
- Key (programID) — serial — 기본 키 — NOT NULL
- Key (instructorId) — serial — 외래 키 → Member.Key — NOT NULL
- Field (title) — varchar(50)
- Field (subject) — varchar(10)
- Field (maxCapacity) — integer
- Field (minCapacity) — integer
- Field (description) — text
- Field (status) — varchar(10)
- Field (settlementDate) — date
- Field (settlementStatus) — varchar(10)
- Field (fee) — integer
Untitled (PROGRAM_DETAILS)
- Key (programDetailsId) — serial — 기본 키 — NOT NULL
- Field (prgramDetailsDate) — date
- Field (startTime) — time
- Field (endTime) — time
- Key (programID) — serial — 외래 키 → Untitled.Key — NOT NULL
- Key (placeID) — serial — 외래 키 → Untitled.Key — NOT NULL
Untitled (ENROLL)
- Key (enrollID) — serial — 기본 키 — NOT NULL
- Key (memberID) — serial — 외래 키 → Member.Key — NOT NULL
- Key (programID) — serial — 외래 키 → Untitled.Key — NOT NULL
- Field (enrollDate) — date
- Field (paymentMethod) — varchar(10)
- Field (paymentStatus) — varchar(10)