FitBack
Tables (9)
Audit (공통시간모듈)
- Key — Primary key — NOT NULL
- Field (작성일)
- Field (수정일)
Calendar (캘린더)
- Key — Primary key — NOT NULL
- Field (일)
- Field2 (월)
- Field3 (연)
CalenmdarData (캘린더데이터)
- Key — Primary key — NOT NULL
- Field (연)
- Field2 (월)
- Field3 (일)
- Field4 (미리보기)
- Field (미리보기 id)
- Field (수납일자)
- Field2 (과외일정)
Feedback (피드백)
- Key — Primary key — NOT NULL
- Key (학생id) — Foreign key → Student.Key — NOT NULL
- id (강사id2) — Foreign key → Student.id — NOT NULL
- Field (학생)
- Field (피드백날짜)
- Field2 (출결여부)
- Field3 (진도내용)
- Field4 (오늘의 알림)
- Field (숙제)
Member (유저(강사))
- id (강사id) — Primary key — NOT NULL
- Field (프로필)
- Field2 (email)
- Field3 (nickname)
Payment (수납일자)
- Key — Primary key — NOT NULL
- Field (수납 상세)
- Field (날짜)
- Key (학생id) — Foreign key → Student.Key — NOT NULL
- id (강사id2) — Foreign key → Student.id — NOT NULL
Schedule (과외일정)
- Key — Primary key — NOT NULL
- Field (과외날짜)
- Field2
- Key (학생id) — Foreign key → Student.Key — NOT NULL
- id (강사id2) — Foreign key → Student.id — NOT NULL
Student (학생)
- Key (학생id) — Primary key — NOT NULL
- id (강사id2) — Foreign key → Member.id — NOT NULL
- Field (강사id)
- Field2 (학생이름)
- Field