방과후

테이블 (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)