dotoriv3-dormitory
Tables (6)
dormitory (기숙사)
- dormitory_id (기숙사 id) — Long — Primary key — NOT NULL
- school_id (학교 id) — Long
music (기상음악)
- music_id (기상음악 id) — Long — Primary key — NOT NULL
- domitory_id (기숙사 id) — Long — Foreign key → dormitory.dormitory_id — NOT NULL
- student_id (신청 학생 id) — Long
- music_title (음악 이름) — String
- music_url (음악 url) — String
- music_thumbnail (음악 썸네일) — String
- music_date (음악 신청 시간) — DateTime
penalty (벌점)
- penalty_Id (벌점 id) — Long — Primary key — NOT NULL
- domitory_id (기숙사 id) — Long — Foreign key → dormitory.dormitory_id — NOT NULL
- student_id (벌점자 정보) — Long
- penalty_reason (벌점 사유) — String
- penalty_point (벌점) — Int
- penalty_date (벌점 부여일) — DateTime
reservation (예약)
- reservation_id (예약 id) — Long — Primary key — NOT NULL
- dormitory_id (기숙사 id) — Long — Foreign key → dormitory.dormitory_id — NOT NULL
- reservation_type (예약 타입) — Enum
reservation_operation (예약 관리)
- reservation_count_id (예약 관리 id) — Long — Primary key — NOT NULL
- reservation_id (예약 id) — Long — Foreign key → reservation.reservation_id — NOT NULL
- reservation_limit (예약 정원) — Int
- reservation_count (예약 인원) — Int
- reservation_start (예약 시작 시간) — DateTime
- reservation_end (예약 마감 시간) — DateTime
reservation_user (예약자)
- reservation_user_id (예약자 id) — Long — Primary key — NOT NULL
- reservation_id (예약 id) — Long — Foreign key → reservation.reservation_id — NOT NULL
- student_id (예약자 학생 id) — Long
- reservation_date (예약 시간) — DateTime