Goal

Tables (15)

Goal (Untitled)

  • Key (id) — Primary key — NOT NULL
  • Key (cycle_id) — Foreign key → GoalCycle.Key — NOT NULL

GoalCustomField (Untitled8)

  • Key (id) — Primary key — NOT NULL
  • Key (team_id) — Foreign key → Team.Key — NOT NULL

GoalCustomFieldValue (Untitled7)

  • Key (id) — Primary key — NOT NULL
  • Key (field_id) — Foreign key → GoalCustomField.Key — NOT NULL
  • Key (goal_id) — Foreign key → Goal.Key — NOT NULL

GoalCycle (Untitled2)

  • Key (id) — Primary key — NOT NULL
  • Key (user_id) — Foreign key → User.Key — NOT NULL
  • Key (team_id) — Foreign key → Team.Key — NOT NULL

GoalCycleReadOnlyPeriod (Untitled10)

  • Key (id) — Primary key — NOT NULL
  • Key (cycle_id) — Foreign key → GoalCycle.Key — NOT NULL

GoalGroup (Untitled5)

  • Key (id) — Primary key — NOT NULL
  • Key (goal_id) — Foreign key → Goal.Key — NOT NULL
  • Key (group_id) — Foreign key → Group.Key — NOT NULL

GoalOrderSetting (Untitled11)

  • Key (id) — Primary key — NOT NULL
  • Key (team_id) — Foreign key → Team.Key — NOT NULL

GoalProgressLog (Untitled12)

  • Key (id) — Primary key — NOT NULL
  • Key (goal_id) — Foreign key → Goal.Key — NOT NULL
  • Key (user_id) — Foreign key → User.Key — NOT NULL

GoalTeamAlarmPeriod (Untitled13)

  • Key (id) — Primary key — NOT NULL
  • Key (team_id) — Foreign key → Team.Key — NOT NULL

GoalUser (Untitled3)

  • Key (id) — Primary key — NOT NULL
  • Key (goal_id) — Foreign key → Goal.Key — NOT NULL
  • Key (user_id) — Foreign key → User.Key — NOT NULL

GoalWeight (Untitled14)

  • Key (id) — Primary key — NOT NULL
  • Key (group_id) — Foreign key → GoalWeightGroup.Key — NOT NULL
  • Key (goal_id) — Foreign key → Goal.Key — NOT NULL
  • Key (user_id) — Foreign key → User.Key — NOT NULL

GoalWeightGroup (Untitled15)

  • Key (id) — Primary key — NOT NULL
  • Key (cycle_id) — Foreign key → GoalCycle.Key — NOT NULL

Group (Untitled6)

  • Key (id) — Primary key — NOT NULL

Team (Untitled9)

  • Key (id) — Primary key — NOT NULL

User (Untitled4)

  • Key (id) — Primary key — NOT NULL