things

type Area struct {
	Uuid         string `sql:"uuid"`
	Title        string `sql:"title"`
	Visible      *int   `sql:"visible"`
	Index        int    `sql:"index"`
	CachedTags   []byte `sql:"cachedTags"`
	Experimental []byte `sql:"experimental"`
}

type AreaTag struct {
	Area string `sql:"areas"`
	Tags string `sql:"tags"`
}

type Tag struct {
	Uuid         string  `sql:"uuid"`
	Title        string  `sql:"title"`
	Shortcut     string  `sql:"shortcut"`
	UsedDate     float32 `sql:"usedDate"`
	Parent       string  `sql:"parent"`
	Index        int     `sql:"index"`
	Experimental []byte  `sql:"experimental"`
}

type Task struct {
	Uuid                             string   `sql:"uuid"`
	LeavesTombstone                  int      `sql:"leavesTombstone"`
	CreationDate                     float32  `sql:"creationDate"`
	UserModificationDate             *float32 `sql:"userModificationDate"`
	Type                             int      `sql:"type"`
	Status                           int      `sql:"status"`
	StopDate                         *float32 `sql:"stopDate"`
	Trashed                          int      `sql:"trashed"`
	Title                            string   `sql:"title"`
	Notes                            string   `sql:"notes"`
	NotesSync                        int      `sql:"notesSync"`
	CachedTags                       []byte   `sql:"cachedTags"`
	Start                            int      `sql:"start"`
	StartDate                        *int     `sql:"startDate"`
	StartBucket                      int      `sql:"startBucket"`
	ReminderTime                     *int     `sql:"reminderTime"`
	LastReminderInteractionDate      *float32 `sql:"lastReminderInteractionDate"`
	Deadline                         *int     `sql:"deadline"`
	DeadlineSuppressionDate          *int     `sql:"deadlineSuppressionDate"`
	T2_deadlineOffset                int      `sql:"t2_deadlineOffset"`
	Index                            int      `sql:"index"`
	TodayIndex                       int      `sql:"todayIndex"`
	TodayIndexReferenceDate          *int     `sql:"todayIndexReferenceDate"`
	Area                             *string  `sql:"area"`
	Project                          *string  `sql:"project"`
	Heading                          *string  `sql:"heading"`
	Contact                          *string  `sql:"contact"`
	UntrashedLeafActionsCount        int      `sql:"untrashedLeafActionsCount"`
	OpenUntrashedLeafActionsCount    int      `sql:"openUntrashedLeafActionsCount"`
	ChecklistItemsCount              int      `sql:"checklistItemsCount"`
	OpenChecklistItemsCount          int      `sql:"openChecklistItemsCount"`
	Rt1_RepeatingTemplate            *string  `sql:"rt1_repeatingTemplate"`
	Rt1_RecurrenceRule               []byte   `sql:"rt1_recurrenceRule"`
	Rt1_InstanceCreationStartDate    *int     `sql:"rt1_instanceCreationStartDate"`
	Rt1_InstanceCreationPaused       *int     `sql:"rt1_instanceCreationPaused"`
	Rt1_InstanceCreationCount        *int     `sql:"rt1_instanceCreationCount"`
	Rt1_AfterCompletionReferenceDate *int     `sql:"rt1_afterCompletionReferenceDate"`
	Rt1_NextInstanceStartDate        *int     `sql:"rt1_nextInstanceStartDate"`
	Experimental                     []byte   `sql:"experimental"`
	Repeater                         []byte   `sql:"repeater"`
	RepeaterMigrationDate            *float32 `sql:"repeaterMigrationDate"`
}

type TaskHierarchy struct {
	Area    *Area
	Project *Task
	Heading *Task
}

type TaskTag struct {
	Task string `sql:"tasks"`
	Tags string `sql:"tags"`
}