clap

Tables (4)

Goal (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • startDate (Field2)
  • endDate (Field3)
  • cyclc_id (Key2) — Foreign key → GoalCycle.id — NOT NULL
  • category (Field4)
  • useGoalProgressValue (Field6)
  • goalState (Field7)
  • users (Field8)
  • groups (Field9)

GoalCycle (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)
  • state (Field3)
  • team (Field4)
  • user (Field5)
  • startDate' (Field6)
  • endDate (Field7)

GoalProgress (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • goal_id (Key3) — Foreign key → Goal.id — NOT NULL
  • progressDetail (Field)

GoalProgressLog (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → Goal.id — NOT NULL
  • value (Field)
  • comment (Field2)
  • goalState (Field3)
  • progressPercentSnapshot (Field4)
  • values (Field5)