BindingOfPlanner

Tables (9)

Action

  • Key (id) — Long — Primary key — NOT NULL
  • Key (parent_action_id) — Long — Foreign key → Action.Key — NOT NULL
  • Field (title) — string
  • Field (content) — text
  • Field (is_complete) — boolean
  • Field (do_date) — Date
  • Key (user_id) — Long — Foreign key → User.Key — NOT NULL
  • Field (done_date) — Date
  • Field (active) — boolean
  • Field (type) — String
  • Field (priory) — enum
  • Field (when) — enum

Action Tag

  • Key — Primary key — NOT NULL
  • Field (type) — enum
  • Key (action_id) — Long — Foreign key → Action.Key — NOT NULL
  • Field (value) — string

Chunk

  • Key (id) — Long — Primary key — NOT NULL
  • Key (parent_id) — Long — Foreign key → Chunk.Key — NOT NULL
  • Key (action_id) — Long — Foreign key → Action.Key — NOT NULL
  • Field (title) — string
  • Field (is_complete) — boolean
  • Field (done_date) — time
  • Field (order) — int

Emotion

  • Key (id) — Long — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → User.Key — NOT NULL
  • Field (type) — Enum
  • Field (create_date) — date
  • Field (detail)

IdeaNote

  • Key (id) — Long — Primary key — NOT NULL
  • Key (user_id) — Long — Foreign key → User.Key — NOT NULL
  • Field (content) — string

IdeaNoteTag

  • Key (id) — Long — Primary key — NOT NULL
  • Key (idea_note_id) — Long — Foreign key → IdeaNote.Key — NOT NULL
  • Field (name) — string

Stack

  • Key (id) — Long — Primary key — NOT NULL
  • Field (Stacked_date) — date
  • Key (action_id) — Long — Foreign key → Action.Key — NOT NULL

Timer

  • Key (id) — Long — Primary key — NOT NULL
  • Key (chunk_id) — Long — Foreign key → Chunk.Key — NOT NULL
  • Field (start_time) — time
  • Field (exiting_time) — time
  • Field (set_time) — time
  • Field (completed) — boolean

User

  • Key (id) — Long — Primary key — NOT NULL
  • Field (user_name) — string
  • Field (platform) — string
  • Field (membership) — enum