database_project

테이블 (5)

resist_timecheck

  • id — BIGINT
  • _1 — BOOLEAN
  • _1h — BOOLEAN
  • _2 — BOOLEAN
  • _2h — BOOLEAN
  • _3 — BOOLEAN
  • _3h — BOOLEAN
  • _4 — BOOLEAN
  • _4h — BOOLEAN
  • _5 — BOOLEAN
  • _5h — BOOLEAN
  • _6 — BOOLEAN
  • _6h — BOOLEAN
  • _7 — BOOLEAN
  • _7h — BOOLEAN
  • _8 — BOOLEAN
  • _8h — BOOLEAN
  • _9 — BOOLEAN
  • _9h — BOOLEAN
  • _10 — BOOLEAN
  • _10h — BOOLEAN
  • _11 — BOOLEAN
  • _11h — BOOLEAN
  • _12 — BOOLEAN
  • _12h — BOOLEAN
  • _13 — BOOLEAN
  • _13h — BOOLEAN
  • _14 — BOOLEAN
  • _14h — BOOLEAN

강의 (resist_course)

  • course_id — VARCHAR(50)
  • course_name — TEXT
  • professor_name — TEXT
  • tag_1 — VARCHAR(50)
  • tag_2 — VARCHAR(50)
  • custum_tag — VARCHAR(50)
  • classroom_id — VARCHAR(50)
  • day_of_week — VARCHAR(50)
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • room_id (room_id2) — VARCHAR(50) — 외래 키 → 강의실.room_id — NOT NULL

강의실 (resist_classroom)

  • room_id — VARCHAR(50) — 기본 키 — NOT NULL
  • building_name — VARCHAR(100) — NOT NULL
  • room_number — INT — NOT NULL
  • capacity — INT
  • is_checked — BOOLEAN
  • has_air_conditioning — BOOLEAN
  • has_lighting — BOOLEAN

예약 (resist_reservation)

  • id — BIGINT — 기본 키 — NOT NULL
  • classroom_id — VARCHAR(50)
  • applicant_id — INT
  • reservation_date — VARCHAR(50)
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • attendees_count — INT
  • tag_1 — VARCHAR(50)
  • tag_2 — VARCHAR(50)
  • custum_tag — VARCHAR(50)
  • student_id — INT — 외래 키 → 유저.student_id — NOT NULL
  • room_id (room_id2) — VARCHAR(50) — 외래 키 → 강의실.room_id — NOT NULL

유저 (resist_user)

  • student_id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — ENUM('Admin', 'Professor', 'Student') — NOT NULL
  • is_returned — BOOLEAN