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