quest manager - dynamo

Tables (6)

answer (Untitled6)

  • id (Key) — number — Primary key — NOT NULL
  • creatorId (Key2) — Foreign key → creator.id — NOT NULL
  • surveyId (Key3) — number — Foreign key → survey.id — NOT NULL
  • content (Field) — json array
  • additionalInfo (Field2) — json object
  • yearMonth (Field3) — string

category (Untitled2)

  • id (Key) — number — Primary key — NOT NULL
  • categoryName (Field) — string
  • additionalInfo (Field2) — json object

creator (Untitled)

  • id (Key) — Primary key — NOT NULL

quest (Untitled3)

  • id (Key) — number — Primary key — NOT NULL
  • categoryId (Key2) — number — Foreign key → category.id — NOT NULL
  • isEnabled (Field) — boolean
  • title (Field2) — string
  • questions (Field3) — json array
  • questNumber (Field4) — number

submission (Untitled4)

  • id (Key) — number — Primary key — NOT NULL
  • creatorId (Key2) — Foreign key → creator.id — NOT NULL
  • questId (Key3) — number — Foreign key → quest.id — NOT NULL
  • categoryId (Key22) — number — Foreign key → quest.categoryId — NOT NULL
  • submissionStatus (Field) — string
  • logs (Field3) — json array
  • additionalInfo (Field2) — json object

survey (Untitled5)

  • id (Key) — number — Primary key — NOT NULL
  • title (Field) — string
  • startAt (Field2) — date
  • endAt (Field3) — date
  • questions (Field4) — json array
  • yearMonth (Field5) — string