수중 스포츠 종합 예약 시스템

테이블 (7)

equipment

  • EquipmentID — SERIAL — 기본 키
  • Type — VARCHAR(20) — NOT NULL
  • Name — VARCHAR(255) — NOT NULL
  • Description — TEXT
  • Price — DECIMAL

facilities

  • FacilityID — SERIAL — 기본 키
  • Name — VARCHAR(255) — NOT NULL
  • Address — TEXT
  • Location — VARCHAR(255)
  • OperatingHours — VARCHAR(255)

lessons

  • LessonID — SERIAL — 기본 키
  • SportID — INT
  • Level — VARCHAR(20)
  • Name — VARCHAR(255) — NOT NULL
  • Description — TEXT
  • Price — DECIMAL
  • SportID (SportID2) — SERIAL — 외래 키 → sports.SportID

members

  • MemberID — SERIAL — 기본 키
  • Name — VARCHAR(255) — NOT NULL
  • Email — VARCHAR(255) — NOT NULL
  • Password — VARCHAR(255) — NOT NULL
  • PhoneNumber — VARCHAR(20)
  • Address — TEXT
  • Birthdate — DATE
  • Certifications — TEXT

reservations

  • ReservationID — SERIAL — 기본 키
  • MemberID — INT
  • TimeslotID — INT
  • EquipmentID — INT
  • LessonID — INT
  • ReservationDate — TIMESTAMP
  • PaymentAmount — DECIMAL
  • PaymentStatus — VARCHAR(20)
  • MemberID (MemberID2) — SERIAL — 외래 키 → members.MemberID
  • EquipmentID (EquipmentID2) — SERIAL — 외래 키 → equipment.EquipmentID
  • LessonID (LessonID2) — SERIAL — 외래 키 → lessons.LessonID

sports

  • SportID — SERIAL — 기본 키
  • Type — VARCHAR(20) — NOT NULL
  • Name — VARCHAR(255) — NOT NULL
  • Description — TEXT

timeslots

  • TimeslotID — SERIAL — 기본 키
  • FacilityID — INT
  • SportID — INT
  • Date — DATE — NOT NULL
  • StartTime — TIME — NOT NULL
  • EndTime — TIME — NOT NULL
  • MaxCapacity — INT
  • AvailableSeats — INT
  • SportID (SportID2) — SERIAL — 외래 키 → sports.SportID
  • FacilityID (FacilityID2) — SERIAL — 외래 키 → facilities.FacilityID