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