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