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

Seat

    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