RS company

Tables (5)

Document (문제집)

  • id (Key) — Integer — Primary key — NOT NULL
  • name — TEXT
  • filename — TEXT
  • fileformat — TEXT
  • uploaddate — datetime
  • modifieddate — datetime
  • numproblems

Newdocument (문제집 초안)

  • id (Key) — Integer — Primary key — NOT NULL
  • name — TEXT
  • memo — TEXT
  • numproblems — Integer

Newproblem (문제집 초안의 문제)

  • id (Key) — Integer — Primary key — NOT NULL
  • documentid — Integer — Foreign key → Newdocument.id — NOT NULL
  • problemid — Integer
  • question — TEXT
  • paragraph — TEXT
  • purpose — TEXT
  • answerChoice — JSONB
  • answer — TEXT
  • translated — TEXT
  • explanation — TEXT
  • reviews — TEXT
  • vocabs — TEXT
  • wronganswer — TEXT
  • difficulty — TEXT
  • source — TEXT
  • origin — TEXT
  • images — JSONB

Problem (문제)

  • id (Key) — Integer — Primary key — NOT NULL
  • documentid — Integer — Foreign key → Document.id — NOT NULL
  • problemid — Integer
  • question — TEXT
  • paragraph — TEXT
  • purpose — TEXT
  • answerChoice — JSONB
  • answer — TEXT
  • translated — TEXT
  • explanation — TEXT
  • reviews — TEXT
  • vocabs — TEXT
  • wronganswer — TEXT
  • difficulty — TEXT
  • source — TEXT
  • origin — TEXT
  • images — JSONB

User (유저)

  • id (Key) — Integer — Primary key — NOT NULL
  • email — TEXT
  • password — TEXT
  • username — TEXT
  • registered — boolean
  • permission — TEXT