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