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