sesac-study-room

Tables (6)

facility (시설(장소))

  • facility_id (PK) — BIGINT — Primary key — NOT NULL
  • facility_name (시설명) — VARCHAR(100)
  • facility_address (시설주소) — VARCHAR(50)
  • facility_desc (시설설명) — BOOLEAN
  • use_tf (시설 사용여부) — BOOLEAN
  • reg_date (시설 등록일) — DATETIME
  • up_date (시설 수정일) — DATETIME
  • del_date (시설 삭제일) — DATETIME

reservation (예약)

  • reservation_id (PK) — BIGINT — Primary key — NOT NULL
  • student_id (FK1) — BIGINT — Foreign key → student.student_id — NOT NULL
  • room_id (FK2) — BIGINT — Foreign key → study_room.room_id — NOT NULL
  • facility_id (FK3) — BIGINT — Foreign key → study_room.facility_id — NOT NULL
  • reservation_status (예약 상태) — ENUM OR VARCHAR(20)
  • reservation_date (예약 날짜) — DATE
  • reservation_start_date (예약 시작 시간) — DATETIME
  • reservation_end_date (예약 종료 시간) — DATETIME
  • reservation_count (예약 실제 이용 수) — INT
  • use_tf (예약 사용여부) — BOOLEAN
  • reg_date (예약 등록일) — DATE
  • up_date (예약 수정일) — DATE
  • del_date (예약 삭제일) — DATE
  • cancel_date (예약 취소일) — DATE

reservation_disable (예약불가)

  • disable_id (PK) — BIGINT — Primary key — NOT NULL
  • room_id (FK1) — BIGINT — Foreign key → study_room.room_id — NOT NULL
  • facility_id (FK2) — BIGINT — Foreign key → study_room.facility_id — NOT NULL
  • reason (예약불가 이유) — TEXT
  • disable_date (예약불가일) — DATE
  • disable_start_at (예약 불가 시작 시간) — DATETIME
  • disalble_end_at (예약 불가 종료 시간) — DATETIME

review (리뷰)

  • review_id (PK) — BIGINT — Primary key — NOT NULL
  • room_id (FK1) — BIGINT — Foreign key → study_room.room_id — NOT NULL
  • facility_id (FK2) — BIGINT — Foreign key → study_room.facility_id — NOT NULL
  • student_id (FK3) — BIGINT — Foreign key → student.student_id — NOT NULL
  • rating (평점) — REAL
  • comment (메모) — VARCHAR(255)

student (학생)

  • student_id (PK) — BIGINT — Primary key — NOT NULL
  • student_no (학번) — VARCHAR(30)
  • student_password (비밀번호) — VARCHAR(255)
  • student_name (이름) — VARCHAR(10)
  • student_department (학과) — VARCHAR(50)
  • student_phone (휴대폰번호) — VARCHAR(50)

study_room (스터디룸)

  • room_id (PK) — BIGINT — Primary key — NOT NULL
  • facility_id (FK) — BIGINT — Foreign key → facility.facility_id — NOT NULL
  • room_name (스터디룸 명) — VARCHAR(30)
  • room_floor (스터디룸 층) — VARCHAR(50)
  • room_image (스터디룸 이미지) — TEXT(FilePath)
  • room_capacity (스터디룸 정원) — INT
  • room_equipment (스터디룸 기자재) — VARCHAR(50)[]
  • use_tf (스터디룸 사용여부) — BOOLEAN
  • reg_date (스터디룸 등록일) — DATETIME
  • up_date (스터디룸 수정일) — DATETIME
  • del_date (스터디룸 삭제일) — DATETIME