model

type Account struct {
	ID      int       `db:"id"`
	Name    string    `db:"name"`
	Balance float64   `db:"balance"`
	Time    time.Time `db:"time"`
}

type App struct {
	ID    int       `db:"id"`
	Name  string    `db:"name"`
	Type  string    `db:"type"`
	Token string    `db:"token"`
	Extra string    `db:"extra"`
	Time  time.Time `db:"time"`
}

type Assets struct {
	ID        int       `db:"id"`
	AccountID int       `db:"account_id"` // -> account
	Name      string    `db:"name"`
	Category  string    `db:"category"`
	Balance   float64   `db:"balance"`
	Time      time.Time `db:"time"`
}

type AttrChange struct {
	UserID  int    `json:"user_id"`
	Content string `json:"content"`
}

type AttrShort string

type Bill struct {
	ID          int       `db:"id"`
	Date        string    `db:"date"`
	Payee       string    `db:"payee"`
	Description string    `db:"description"`
	Amount      float64   `db:"amount"`
	Time        time.Time `db:"time"`
}

type BillRecord struct {
	ID      int     `db:"id"`
	BillID  int     `db:"bill_id"`
	Posting string  `db:"posting"` // -> assets
	Amount  float64 `db:"amount"`
}

type Credential struct {
	ID      int       `db:"id"`
	Name    string    `db:"name"`
	Type    string    `db:"type"`
	Content string    `db:"content"`
	Time    time.Time `db:"time"`
}

type Equipment struct {
	ID       int       `db:"id"`
	Name     string    `db:"name"`
	Quality  string    `db:"quality"`
	Level    int       `db:"level"`
	Category string    `db:"category"`
	Time     time.Time `db:"time"`
}

type Message struct {
	ID   int       `db:"id"`
	UUID string    `db:"uuid"`
	Type string    `db:"type"`
	Text string    `db:"text"`
	Time time.Time `db:"time"`
}

type Page struct {
	ID      int       `db:"id"`
	UUID    string    `db:"uuid"`
	Type    string    `db:"type"`
	Title   string    `db:"title"`
	Content string    `db:"content"`
	Time    time.Time `db:"time"`
}

type Quest struct {
	ID            int       `db:"id"`
	Title         string    `db:"title"`
	Exp           int       `db:"exp"`
	AttrPoints    string    `db:"attr_points"`
	Preconditions string    `db:"preconditions"`
	Time          time.Time `db:"time"`
}

type Role struct {
	ID         int    `db:"id"`
	UserID     int    `db:"user_id"`
	Profession string `db:"profession"`

	Exp   int `db:"exp"`
	Level int `db:"level"`

	// attr
	Strength    int `db:"strength"`
	Culture     int `db:"culture"`
	Environment int `db:"environment"`
	Charisma    int `db:"charisma"`
	Talent      int `db:"talent"`
	Intellect   int `db:"intellect"`

	Time time.Time `db:"time"`
}

type RoleAttr string

type Todo struct {
	ID             int        `db:"id"`
	Content        string     `db:"content"`
	Priority       int        `db:"priority"`
	IsRemindAtTime bool       `db:"is_remind_at_time"`
	RemindAt       *time.Time `db:"remind_at"`
	RepeatMethod   string     `db:"repeat_method"`
	RepeatRule     string     `db:"repeat_rule"`
	Category       string     `db:"category"`
	Remark         string     `db:"remark"`
	Complete       bool       `db:"complete"`
	Time           time.Time  `db:"time"`
}

type Trigger struct {
	ID        int       `db:"id"`
	Type      string    `db:"type"`
	Kind      string    `db:"kind"`
	Flag      string    `db:"flag"`
	Secret    string    `db:"secret"`
	When      string    `db:"when"`
	MessageID int       `db:"message_id"`
	Time      time.Time `db:"time"`
}

type User struct {
	ID     int    `db:"id"`
	Name   string `db:"name"`
	Mobile string `db:"mobile"`
	Remark string `db:"remark"`
	Time   string `db:"time"`
}