model

type APITokens struct {
	ID         int64      `sql:"primary_key" db:"id"`
	CustomerID uuid.UUID  `db:"customer_id"`
	Label      string     `db:"label"`
	Secret     []byte     `db:"secret"`
	CreatedAt  time.Time  `db:"created_at"`
	RevokedAt  *time.Time `db:"revoked_at"`
}

type Customers struct {
	ID          uuid.UUID       `sql:"primary_key" db:"id"`
	Name        string          `db:"name"`
	Email       string          `db:"email"`
	Plan        string          `db:"plan"`
	IsActive    bool            `db:"is_active"`
	Preferences json.RawMessage `db:"preferences"`
	Notes       *string         `db:"notes"`
	CreatedAt   time.Time       `db:"created_at"`
}

type Orders struct {
	ID         int64      `sql:"primary_key" db:"id"`
	CustomerID uuid.UUID  `db:"customer_id"`
	Status     string     `db:"status"`
	TotalCents int32      `db:"total_cents"`
	Tags       []string   `db:"tags"`
	Paid       bool       `db:"paid"`
	ShippedAt  *time.Time `db:"shipped_at"`
	CreatedAt  time.Time  `db:"created_at"`
}