도서관 커뮤니티 프로그램 관리 시스템

테이블 (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)