wanago
Tables (10)
Curriculum_chapter (CopyOfUntitled)
- chapter_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- unit_id (Key2) — VARCHAR(10) — Foreign key → Curriculum_unit.unit_id — NOT NULL
- title (Field) — text
- sequence (Field2) — int
Curriculum_unit (Untitled)
- unit_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- user_id (Key2) — VARCHAR(10) — Foreign key → User.user_id — NOT NULL
- title (Field) — text
- sequence (Field2) — int
Sticker (Untitled9)
- sticker_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- question (Field) — TEXT
- title (Field2) — TEXT
- answer (Field3) — TEXT
User (Untitled4)
- user_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- period (Field) — timestamp
- level (Field2) — Enum
- type (Field3) — Enum
assignment (Untitled5)
- assignment_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- study_way_id (Key2) — VARCHAR(10) — Foreign key → studyway.study_way_id — NOT NULL
- concept_id (Key3) — VARCHAR(10) — Foreign key → concept.concept_id — NOT NULL
- content (Field) — TEXT
- answer (Field2) — TEXT
- correct (Field3) — TEXT
- standard (Field4) — TEXT
bookmark (Untitled7)
- bookmark_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- content (Field) — TEXT
- comment (Field2) — TEXT
- reason (Field3) — Enum
concept (Untitled2)
- concept_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- study_way_id (Key2) — VARCHAR(10) — Foreign key → studyway.study_way_id — NOT NULL
- chapter_id (Key3) — VARCHAR(10) — Foreign key → Curriculum_chapter.chapter_id — NOT NULL
- unit_id (Key22) — VARCHAR(10) — Foreign key → Curriculum_chapter.unit_id — NOT NULL
- title (Field) — TEXT
- content (Field3) — TEXT
- sucess (Field2) — boolean
- used_time (Field4) — timestamp
question (Untitled6)
- question_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- concept_id (Key2) — VARCHAR(10) — Foreign key → concept.concept_id — NOT NULL
- content (Field) — TEXT
- answer (Field2) — TEXT
structure (Untitled3)
- structure_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- concept_id (Key2) — VARCHAR(10) — Foreign key → concept.concept_id — NOT NULL
- sticker_id (Key4) — VARCHAR(10) — Foreign key → Sticker.sticker_id — NOT NULL
- question_id (Key3) — VARCHAR(10) — Foreign key → question.question_id — NOT NULL
- bookmark_id (Key5) — VARCHAR(10) — Foreign key → bookmark.bookmark_id — NOT NULL
- assignment_id (Key6) — VARCHAR(10) — Foreign key → assignment.assignment_id — NOT NULL
- kind (Field) — Enum
- type (Field2) — Enum
- URL (Field3) — varchar(100)
studyway (Untitled8)
- study_way_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- content (Field) — TEXT
- example (Field2) — TEXT