OOP
Tables (8)
PreferenceResult
- 성향 결과 ID (preference_id) — Primary key — NOT NULL
- 선호소음정도 (Field)
- 선호혼잡도 (Field2)
- Field3
- 학번 (student_id) — varchar — Foreign key → User.학번 — NOT NULL
Reservation
- 예약ID (reservation_id) — bigint — Primary key — NOT NULL
- 예약시작시간 (start_time) — timestamp — NOT NULL
- 예약종료시간 (end_time) — timestamp — NOT NULL
- 학번 (student_id) — varchar — Foreign key → User.학번 — NOT NULL
- 공간ID (space_id) — bigint — Foreign key → Space.공간ID — NOT NULL
- 상태 (status) — enum — 사용중, 완료
Review
- 리뷰ID (review_id) — bigint — Primary key — NOT NULL
- 별점 (rating) — int — NOT NULL — 0-5
- 내용 (content) — varcahr(255) — NOT NULL
- 작성일시 (created_at) — timestamp — NOT NULL
- 공간ID (space_id) — bigint — Foreign key → Space.공간ID — NOT NULL
Space
- 공간ID (space_id) — bigint — Primary key — NOT NULL
- 공간이름 (space_name) — varcahr(255) — NOT NULL
- 공간유형 (space_type) — enum — NOT NULL — SEAT, STUDY_ROOM
- 건물위치 (location) — varcahr(255) — NOT NULL
Status
- 상태ID (status_id) — bigint — Primary key — NOT NULL
- 소음정도 (noise_level) — int — NOT NULL
- 혼잡도 (crowdedness) — int — NOT NULL
- 청결도 (cleanliness) — int — NOT NULL
- 등록시각 (created_at) — timestamp — NOT NULL
- 공간ID (space_id) — bigint — Foreign key → Space.공간ID — NOT NULL
StudyRoom
- 최소인원 (minPeople)
- 수용인원 (capacity) — int
User
- 학번 (student_id) — varchar — Primary key — NOT NULL
- 이름 (name) — varchar(20) — NOT NULL