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