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