backend

type Admin struct {
	UserID string `json:"user_id"`
}

type Captcha struct {
	ID         string    `json:"-"`
	Value      string    `json:"value"`
	Token      string    `json:"-"`
	Expiration time.Time `json:"expiration_time"`
}

type Group struct {
	ID                 string         `json:"group_id"`
	ReadPublic         int            `json:"readpublic"`
	ReadConfirmed      int            `json:"readconfirmed"`
	ExistencePublic    int            `json:"existencepublic"`
	ExistenceConfirmed int            `json:"existenceconfirmed"`
	PostPublic         int            `json:"postpublic"`
	PostConfirmed      int            `json:"postconformed"`
	PostMember         int            `json:"postmember"`
	JoinPublic         int            `json:"joinpublic"`
	JoinConfirmed      int            `json:"joinconfirmed"`
	JoinMember         int            `json:"joinmember"`
	Subscriptions      []Subscription `json:"subscriptions"`
}

type Medium struct {
	ID string
}

type Message struct {
	ID      string
	GroupID string `json:"-" sql:"type:varchar(255) REFERENCES groups(id) ON DELETE CASCADE ON UPDATE RESTRICT"`
	Unique  string
}

type Session struct {
	ID       string    `json:"session_id"`
	UserID   string    `json:"user_id" sql:"type:varchar(255) REFERENCES users(id) ON DELETE CASCADE ON UPDATE CASCADE"`
	LastUsed time.Time `json:"-"`
}

type ShortURL struct {
	ID   string
	Dest string //*url.URL // TODO: figure out how to have (un)marshalling happen automatically
}

type Subscription struct {
	AddressID int64  `sql:"type:bigint       REFERENCES user_addresses(id) ON DELETE CASCADE  ON UPDATE RESTRICT"`
	GroupID   string `sql:"type:varchar(255) REFERENCES groups(id)         ON DELETE CASCADE  ON UPDATE RESTRICT"`
	Confirmed bool
}

type TwilioNumber struct {
	ID     int64  `json:"number_id"`
	Number string `json:"number"`
}

type TwilioPool struct {
	UserID   string `json:"user_id"   sql:"type:varchar(255) REFERENCES users(id)          ON DELETE CASCADE  ON UPDATE RESTRICT"`
	GroupID  string `json:"group_id"  sql:"type:varchar(255) REFERENCES groups(id)         ON DELETE CASCADE  ON UPDATE RESTRICT"`
	NumberID int64  `json:"number_id" sql:"type:bigint       REFERENCES twilio_numbers(id) ON DELETE RESTRICT ON UPDATE RESTRICT"`
}

type TwilioSMSMessage struct {
	MessageSID    string `json:"MessageSid" sql:"type:varchar(34)"`
	MessageStatus string
	ErrorCode     string
}

type User struct {
	ID        string        `json:"user_id"`
	FullName  string        `json:"fullname"`
	PwHash    []byte        `json:"-"`
	Addresses []UserAddress `json:"addresses"`
}

type UserAddress struct {
	// TODO: add a "verified" boolean
	ID        int64  `json:"-"`
	UserID    string `json:"-"      sql:"type:varchar(255) REFERENCES users(id) ON DELETE CASCADE  ON UPDATE RESTRICT"`
	Medium    string `json:"medium" sql:"type:varchar(255) REFERENCES media(id) ON DELETE RESTRICT ON UPDATE RESTRICT"`
	Address   string `json:"address"`
	SortOrder uint64 `json:"sort_order"`
	Confirmed bool   `json:"confirmed"`
}