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

Subject (과목)