FineDustLab

Tables (5)

auth_teacher (교육자유저모델)

  • Key (user_id) — Primary key — NOT NULL
  • Email (이메일) — CharField
  • Password (패스워드) — CharField

student_survey (학습자-설문)

  • PK (id) — Primary key — NOT NULL
  • PK (user_id) — IntegerField — Foreign key → user_student.PK — NOT NULL
  • PK (survey_id) — IntegerField — Foreign key → survey.PK — NOT NULL
  • Key (auth_id) — Foreign key → survey.Key — NOT NULL

survey (설문조사)

  • PK (id) — IntegerField — Primary key — NOT NULL
  • Key (user_id) — Foreign key → user_teacher.Key — NOT NULL
  • 내용 (content)

user_student (학습자유저)

  • PK (user_id) — IntegerField — Primary key — NOT NULL
  • 이름 (name) — CharField
  • 학교코드 (school_code) — CharField
  • 학년 (grade) — int

user_teacher (교육자프로필)

  • Key (user_id) — Foreign key → auth_teacher.Key — NOT NULL
  • 이름 (name) — CharField
  • 학교코드 (school_code) — CharField
  • 핀코드 (pin_code) — int