Implement missing DB fields / custom types

[5HT2]

Trip Report Data structure and fields

Trip Report
├── ID
├── Creation Date
├── Last Modified Date
├── Source
│   ├── Name
│   ├── ID
│   └── URL
├── []Effect
│   ├── Name
│   ├── ID
│   └── []Matched Text
├── Submitter Info
│   ├── Name
│   ├── Gender
│   ├── Age
│   ├── Height
│   │   ├── Metric
│   │   └── Imperial
│   ├── Weight
│   │   ├── Metric
│   │   └── Imperial
│   ├── []Medication
│   │   ├── Name
│   │   ├── Dosage
│   │   ├── Frequency
│   │   ├── Route of Administration
│   │   └── Prescribed
│   └── Social Media
└── Report
├── Title
├── Date
├── Setting
└── []Report Event
├── Type
│   ├── Note
│   └── Substance
├── Time
│   ├── Absolute
│   └── Relative
└── Section
├── Onset
├── Offset
├── Peak
└── Description
├── Offset
├── Onset
└── Peak

Source text

ID
Creation Date
Last Modified Date
Source
Source/Name
Source/ID
Source/URL
[]Effect
[]Effect/Name
[]Effect/ID
[]Effect/[]Matched Text
Submitter Info
Submitter Info/Name
Submitter Info/Gender
Submitter Info/Age
Submitter Info/Height
Submitter Info/Height/Metric
Submitter Info/Height/Imperial
Submitter Info/Weight
Submitter Info/Weight/Metric
Submitter Info/Weight/Imperial
Submitter Info/[]Medication
Submitter Info/[]Medication/Name
Submitter Info/[]Medication/Dosage
Submitter Info/[]Medication/Frequency
Submitter Info/[]Medication/Route of Administration
Submitter Info/[]Medication/Prescribed
Submitter Info/Social Media
Report
Report/Title
Report/Date
Report/Setting
Report/[]Report Event
Report/[]Report Event/Type
Report/[]Report Event/Type/Note
Report/[]Report Event/Type/Substance
Report/[]Report Event/Time
Report/[]Report Event/Time/Absolute
Report/[]Report Event/Time/Relative
Report/[]Report Event/Section
Report/[]Report Event/Section/Description
Report/[]Report Event/Section/Description/Onset
Report/[]Report Event/Section/Description/Peak
Report/[]Report Event/Section/Description/Offset

See this Go snippet for a scanner impl

// Scan implements the sql.Scanner interface for database deserialization.
func (d *Decimal) Scan(value interface{}) error {
	// first try to see if the data is stored in database as a Numeric datatype
	switch v := value.(type) {

	case float32:
		*d = NewFromFloat(float64(v))
		return nil

	case float64:
		// numeric in sqlite3 sends us float64
		*d = NewFromFloat(v)
		return nil

	case int64:
		// at least in sqlite3 when the value is 0 in db, the data is sent
		// to us as an int64 instead of a float64 ...
		*d = New(v, 0)
		return nil

	default:
		// default is trying to interpret value stored as string
		str, err := unquoteIfQuoted(v)
		if err != nil {
			return err
		}
		*d, err = NewFromString(str)
		return err
	}
}

[5HT2]

See c74287e...0ce3f57

[5HT2]

Moving this to 1.1.0 as the important ones are done.