models

type Account struct {
	ID                            int64           `db:"id"`
	TwitterID                     int64           `db:"twitter_id"`
	TwitterHandle                 string          `db:"twitter_handle"`
	MultisigAddress               *sql.NullString `db:"multisig_address"`
	MultisigFactoryIdentifier     *sql.NullInt64  `db:"multisig_factory_identifier"`
	PassedRegistrationChallengeAt *time.Time      `db:"passed_registration_challenge_at"`
	CreatedAt                     *time.Time      `db:"created_at"`
	LastDMAt                      *time.Time      `db:"last_dm_at"`

	// ActivatedAt is used for the pre-registration phase of the party. After
	// pre-registration it can be ignored
	ActivatedAt *time.Time `db:"activated_at"`
}

type AnalyticsEvent struct {
	ID          int64              `db:"id"`
	Key         AnalyticsEventType `db:"key"`
	AccountID   sql.NullInt64      `db:"account_id"`
	Additionals types.JSONText     `db:"additionals"`
	CreatedAt   *time.Time         `db:"created_at"`
}

type AnalyticsEventType string

type Balance struct {
	ID            int64       `db:"id"`
	AccountID     int64       `db:"account_id"`
	ETHEventID    int64       `db:"eth_event_id"`
	PLCRBalance   TokenAmount `db:"plcr_balance"`
	WalletBalance TokenAmount `db:"wallet_balance"`
}

type ETHEvent struct {
	ID          int64          `db:"id"`
	EventType   string         `db:"event_type"`
	Data        types.JSONText `db:"data"`
	BlockNumber uint64         `db:"block_number"`
	TxHash      string         `db:"tx_hash"`
	TxIndex     uint           `db:"tx_index"`
	LogIndex    uint           `db:"log_index"`
	CreatedAt   *time.Time     `db:"created_at"`
}

type FaucetHit struct {
	ID        int64      `db:"id"`
	AccountID int64      `db:"account_id"`
	Amount    string     `db:"amount"`
	Timestamp *time.Time `db:"created_at"`
}

type OAuthToken struct {
	ID               int64     `db:"id"`
	TwitterHandle    string    `db:"twitter_handle"`
	TwitterID        int64     `db:"twitter_id"`
	OAuthToken       string    `db:"oauth_token"`
	OAuthTokenSecret string    `db:"oauth_token_secret"`
	CreatedAt        time.Time `db:"created_at"`
}

type RegistrationChallenge struct {
	ID                     int64      `db:"id"`
	AccountID              int64      `db:"account_id"`
	RegistrationQuestionID int64      `db:"registration_question_id"`
	SentAt                 *time.Time `db:"sent_at"`
	CompletedAt            *time.Time `db:"completed_at"`
}

type RegistrationChallengeRegistrationQuestion struct {
	RegistrationChallenge
	RegistrationQuestion `db:"registration_questions"`
}

type RegistrationQuestion struct {
	ID        int64      `db:"id"`
	Question  string     `db:"question"`
	Answer    string     `db:"answer"`
	DeletedAt *time.Time `db:"deleted_at"`
}

type RegistryChallenge struct {
	PollID              int64            `db:"poll_id" json:"poll_id"`
	ListingHash         string           `db:"listing_hash" json:"-"`
	ListingID           string           `db:"listing_id" json:"-"`
	ChallengerAccountID sql.NullInt64    `db:"challenger_account_id" json:"-"`
	ChallengerAddress   string           `db:"challenger_address" json:"-"`
	CreatedAt           *time.Time       `db:"created_at" json:"created_at"`
	CommitEndsAt        *time.Time       `db:"commit_ends_at" json:"commit_ends_at"`
	RevealEndsAt        *time.Time       `db:"reveal_ends_at" json:"reveal_ends_at"`
	SucceededAt         *time.Time       `db:"succeeded_at" json:"-"`
	FailedAt            *time.Time       `db:"failed_at" json:"-"`
	Listing             *RegistryListing `db:"registry_listing" json:"-"`
}

type RegistryListing struct {
	ID                   string     `db:"id" json:"-"`
	ListingHash          string     `db:"listing_hash" json:"listing_hash"`
	TwitterHandle        string     `db:"twitter_handle" json:"twitter_handle"`
	Deposit              string     `db:"deposit" json:"deposit"`
	ApplicationCreatedAt *time.Time `db:"application_created_at" json:"application_created_at"`
	ApplicationEndedAt   *time.Time `db:"application_ended_at" json:"application_ended_at"`
	WhitelistedAt        *time.Time `db:"whitelisted_at" json:"whitelisted_at"`
	RemovedAt            *time.Time `db:"removed_at" json:"-"`
}

type RegistryListingWithChallenge struct {
	RegistryListing
	RegistryChallenge `db:"registry_challenge" json:"challenge"`
}

type TokenAmount struct {
	Amt *big.Int
}

type Vote struct {
	PollID          int64      `db:"poll_id"`
	AccountID       int64      `db:"account_id"`
	Salt            int64      `db:"salt"`
	Vote            bool       `db:"vote"`
	Weight          int64      `db:"weight"`
	Revealed        *time.Time `db:"revealed_at"`
	RewardClaimedAt *time.Time `db:"reward_claimed_at"`
	CreatedAt       *time.Time `db:"created_at"`
}