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