방과후
테이블 (12)
Lecture (lecture)
- idx (id) — bigint — 기본 키 — NOT NULL
- max_people (max_student) — int
- Field (min_student) — int
- Field (target_grade) — int
- Field (explanation) — varchar(255)
- Field (end_day) — date
- Field3 (end_time) — time
- Field2 (start_day) — date
- Field (start_time) — time
- Field (lecture_status) — varchar(255)
- Field (place_type) — varchar(255)
- Field (enroll_student) — int
- name (lecture_name) — varchar(255)
- Field (lecture_tag) — varchar(255)
Member (member)
- idx (id) — varchar(255) — 기본 키 — NOT NULL
- name — varchar(255)
- pw — varchar(255)
- phone (subject) — varchar(255)
- email — varchar(255)
- role (member_role) — varchar(255)
NumberOfStudent (student_of_info)
- idx (member_id) — varchar(255) — 외래 키 → Member.idx — NOT NULL
- grade — int
- class — int
- number — int
- year — int
Untitled (member_of_lecture)
- Key (id) — bigint — 기본 키 — NOT NULL
- idx (member_id) — varchar(255) — 외래 키 → Member.idx — NOT NULL
- idx (lecture_id) — bigint — 외래 키 → Lecture.idx — NOT NULL
- Field (apply_date_time) — dateTime(6)
Untitled (lecture_week_plan)
- Key (idx) — bigint — 기본 키 — NOT NULL
- Field (week) — int
- Field (explanation) — varchar(255)
- idx (lecture_id) — bigint — 외래 키 → Lecture.idx — NOT NULL
Untitled (attendance)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (attend_student) — int
- Field (attendance_status) — varchar(255)
- Field (attendance_time) — varchar(255)
- Field (code) — varchar(255)
- Field (lecture_date) — date
- idx (lecture_id) — bigint — 외래 키 → Lecture.idx — NOT NULL
Untitled (question)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (content) — varchar(255)
- Field2 (title) — varchar(255)
- Field3 (created_at) — datetime(6)
- Field4 (question_status) — varchar(255)
- idx (member_id) — varchar(255) — 외래 키 → Member.idx — NOT NULL
Untitled (absence)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (absence_status) — varchar(255)
- Field2 (attendance_id) — bigint
- Field3 (lecture_id) — bigint
- Field4 (created_at) — datetime(6)
- Field (reason) — varchar(255)
- idx (member_id) — varchar(255) — 외래 키 → Member.idx — NOT NULL
Untitled (attendant)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (apply_date_time) — dateTime(6)
- Field2 (attendant_id) — bigint
- Key (attendance_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
Untitled (suggestion)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (content) — varchar(255)
- Field2 (attitional) — varchar(255)
- Field3 (day_of_week) — varchar(255)
- Field4 (name) — varchar(255)
- Field (created_at) — datetime(6)
- idx (member_id) — varchar(255) — 외래 키 → Member.idx — NOT NULL
Untitled (notice)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (content) — varchar(255)
- Field2 (notice_status) — varchar(255)
- Field3 (created_at) — datetime(6)
Untitled (lecture_of_day_of_week)
- idx (lecture_id) — bigint — 외래 키 → Lecture.idx — NOT NULL
- Field (day_of_week) — varchar(255)