수중 스포츠 종합 예약 시스템
테이블 (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