Baenamp

테이블 (14)

BlessYouList (Untitled2)

  • id (Field) — int
  • Field2

Copy Of LessonLog (CopyOfLessonLog)

  • Key (id) — int — 기본 키 — NOT NULL
  • matching_id — int — 외래 키 → Lesson.matching_id — NOT NULL
  • Field (class) — int

Lesson (lesson)

  • id — int — 기본 키 — NOT NULL
  • matching_id — int — 외래 키 → Matching.id — NOT NULL
  • Field (mentor_id) — int
  • mentee_id — int
  • extra_subject — string
  • available_courses — string[]
  • available_subjects — string[]
  • deleted_at
  • updated_at — datetime
  • created_at — datetime
  • status — string
  • generation — int
  • FK (user_id) — int — 외래 키 → User (멘토, 선교사님).id — NOT NULL

LessonLog

  • Key (id) — int — 기본 키 — NOT NULL
  • FK (lesson_id) — int — 외래 키 → Lesson.matching_id — NOT NULL
  • Field (class) — int
  • Field (feedback) — string
  • Field (created_at) — timestamp
  • Field (temperature) — int
  • Field (lesson_temperature) — int
  • Field (week) — int

Matching (matching)

  • id — int — 기본 키 — NOT NULL
  • mentor_application_id — int — 외래 키 → MentorApplication.id — NOT NULL — asdf
  • mentee_application_id — int — 외래 키 → MenteeApplication.id — NOT NULL
  • matching_status — string
  • subject — string
  • selected_mentee_application_id — int
  • deleted_at — datetime
  • updated_at — datetime
  • created_at — datetime
  • generation — int

Mentee

  • id — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → User (멘토, 선교사님).id — NOT NULL
  • name — string
  • status (Field) — string

MenteeApplication (mentee_application)

  • id — int — 기본 키 — NOT NULL
  • id (mentee_id) — int — 외래 키 → Mentee.id — NOT NULL
  • subject — string
  • generation — int
  • extra_subject — string
  • available_courses — string[]
  • available_subjects — string[]
  • korean_level — string
  • english_level — string
  • available_date_time — string[]
  • belong — string
  • prayer — string[]
  • feedback — string

MenteeHistory (CopyOfUntitled)

  • Key (id) — int — 기본 키 — NOT NULL
  • id (mentee_id) — int — 외래 키 → Mentee.user_id — NOT NULL
  • Field (generation) — int
  • Field (status) — string

MentorApplication (mentor_application)

  • id — int — 기본 키 — NOT NULL — asdf
  • user_id — int — 외래 키 → User (멘토, 선교사님).id — NOT NULL
  • subject — string
  • generation — int
  • extra_subject — string
  • available_courses — string[]
  • available_subjects — string[]
  • korean_level — string
  • english_level — string
  • belong — string — 멘토님 소속 공동체

MentorHistory (Untitled)

  • Key (id) — int — 기본 키 — NOT NULL
  • id (user_id) — int — 외래 키 → User (멘토, 선교사님).id — NOT NULL
  • Field (generation) — int
  • Field (status) — string

Planning

  • Key (id) — int — 기본 키 — NOT NULL
  • FK (lesson_id) — int — 외래 키 → Lesson.matching_id — NOT NULL
  • Field (lesson_datetime) — timestamp
  • Field (lesson_goal) — text
  • Field (textbook) — text
  • Field (mentee_character) — text
  • Field (week) — int

QNA

  • Key (id) — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → User (멘토, 선교사님).id — NOT NULL
  • Field (question) — text
  • Field (answer) — text

SystemConfig

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (key) — string
  • Field (사전신청 질문 리스트) — string
  • Field (사전신청기간)
  • Field (매칭기간)
  • Field (수업계획서작성기반)
  • Field (수업기간)
  • Field

User (멘토, 선교사님) (user)

  • id — int — 기본 키 — NOT NULL
  • birth — string — NOT NULL
  • email — string
  • password — string
  • gender — string
  • name — string
  • over_14 — boolean
  • privacy_policy — boolean
  • terms_of_service — boolean
  • created_at — datetime
  • mobile — string
  • type — string
  • status (Field) — string
  • role (Field2) — string