netflix

type BillingHistoryItem struct {
	gorm.Model
	TransactionDate        types.DateTime `csv:"Transaction Date" gorm:"uniqueIndex:netflix_billing_history_key"`
	ServicePeriodStartDate types.DateTime `csv:"Service Period Start Date"`
	ServicePeriodEndDate   types.DateTime `csv:"Service Period End Date"`
	Description            string         `csv:"Description"`
	PaymentType            string         `csv:"Payment Type" gorm:"uniqueIndex:netflix_billing_history_key"`
	MopLast4               string         `csv:"Mop Last 4" gorm:"uniqueIndex:netflix_billing_history_key"`
	MopCreationDate        types.DateTime `csv:"Mop Creation Date"`
	MopPmtProcessorDesc    string         `csv:"Mop Pmt Processor Desc"`
	ItemPriceAmt           float32        `csv:"Item Price Amt"`
	Currency               string         `csv:"Currency"`
	TaxAmt                 float32        `csv:"Tax Amt"`
	GrossSaleAmt           float32        `csv:"Gross Sale Amt"`
	PmtTxnType             string         `csv:"Pmt Txn Type" gorm:"uniqueIndex:netflix_billing_history_key"`
	PmtStatus              string         `csv:"Pmt Status" gorm:"uniqueIndex:netflix_billing_history_key"`
	FinalInvoiceResult     string         `csv:"Final Invoice Result" gorm:"uniqueIndex:netflix_billing_history_key"`
	Country                string         `csv:"Country"`
	NextBillingDate        types.DateTime `csv:"Next Billing Date"`
}

type ClickstreamAction struct {
	gorm.Model
	ProfileName     string         `csv:"Profile Name" gorm:"uniqueIndex:netflix_clickstream_key"`
	Source          string         `csv:"Source" gorm:"uniqueIndex:netflix_clickstream_key"`
	NavigationLevel string         `csv:"Navigation Level" gorm:"uniqueIndex:netflix_clickstream_key"`
	ReferrerUrl     string         `csv:"Referrer Url"`
	WebpageUrl      string         `csv:"Webpage Url"`
	ClickTime       types.DateTime `csv:"Click Utc Ts" gorm:"uniqueIndex:netflix_clickstream_key"`
}

type Device struct {
	gorm.Model
	ProfileName                                   string         `csv:"profileName" gorm:"uniqueIndex:netflix_devices_key"`
	ESN                                           string         `csv:"esn" gorm:"uniqueIndex:netflix_devices_key"`
	DeviceType                                    string         `csv:"deviceType"`
	AcctFirstPlaybackDate                         types.DateTime `csv:"acctFirstPlaybackDate"`
	AcctLastPlaybackDate                          types.DateTime `csv:"acctLastPlaybackDate"`
	AcctFirstPlaybackDateForUserGeneratedPlays    types.DateTime `csv:"acctFirstPlaybackDateForUserGeneratedPlays"`
	AcctLastPlaybackDateForUserGeneratedPlays     types.DateTime `csv:"acctLastPlaybackDateForUserGeneratedPlays"`
	ProfileFirstPlaybackDate                      types.DateTime `csv:"profileFirstPlaybackDate"`
	ProfileLastPlaybackDate                       types.DateTime `csv:"profileLastPlaybackDate"`
	ProfileFirstPlaybackDateForUserGeneratedPlays types.DateTime `csv:"profileFirstPlaybackDateForUserGeneratedPlays"`
	ProfileLastPlaybackDateForUserGeneratedPlays  types.DateTime `csv:"profileLastPlaybackDateForUserGeneratedPlays"`
	DeactivationTime                              types.DateTime `csv:"deactivationTime"`
}

type Duration struct {
	sql.NullInt64
}

type IPAddress struct {
	gorm.Model
	ESN                        string         `csv:"esn" gorm:"uniqueIndex:netflix_ip_addresses_key"`
	Country                    string         `csv:"country"`
	LocalizedDeviceDescription string         `csv:"localizedDeviceDescription"`
	DeviceDescription          string         `csv:"deviceDescription"`
	IP                         string         `csv:"ip"`
	RegionCodeDisplayName      string         `csv:"regionCodeDisplayName"`
	Time                       types.DateTime `csv:"ts" gorm:"uniqueIndex:netflix_ip_addresses_key"`
}

type IndicatedPreference struct {
	gorm.Model
	ProfileName  string         `csv:"Profile Name" gorm:"uniqueIndex:netflix_indicated_preferences_key"`
	Show         string         `csv:"Show" gorm:"uniqueIndex:netflix_indicated_preferences_key"`
	HasWatched   bool           `csv:"Has Watched" gorm:"uniqueIndex:netflix_indicated_preferences_key"`
	IsInterested bool           `csv:"Is Interested" gorm:"uniqueIndex:netflix_indicated_preferences_key"`
	EventDate    types.DateTime `csv:"Event Date" gorm:"uniqueIndex:netflix_indicated_preferences_key"`
}

type InteractiveTitle struct {
	gorm.Model
	ProfileName     string         `csv:"Profile Name" gorm:"uniqueIndex:netflix_interactive_titles_key"`
	TitleDesc       string         `csv:"Title Desc"`
	SelectionType   string         `csv:"Selection Type"`
	ChoiceSegmentId string         `csv:"Choice Segment Id"`
	HasWatched      bool           `csv:"Has Watched"`
	Source          string         `csv:"Source"`
	Time            types.DateTime `csv:"Utc Timestamp" gorm:"uniqueIndex:netflix_interactive_titles_key"`
}

type MyListItem struct {
	gorm.Model
	ProfileName  string         `csv:"Profile Name" gorm:"uniqueIndex:netflix_my_list_key"`
	TitleName    string         `csv:"Title Name" gorm:"uniqueIndex:netflix_my_list_key"`
	Country      string         `csv:"Country"`
	TitleAddDate types.DateTime `csv:"Utc Title Add Date"`
}

type PlaybackRelatedEvent struct {
	gorm.Model
	ProfileName       string         `csv:"Profile Name" gorm:"uniqueIndex:netflix_playback_related_events_key"`
	TitleDescription  string         `csv:"Title Description" gorm:"uniqueIndex:netflix_playback_related_events_key"`
	Device            string         `csv:"Device"`
	Country           string         `csv:"Country"`
	PlaybackStartTime types.DateTime `csv:"Playback Start Utc Ts" gorm:"uniqueIndex:netflix_playback_related_events_key"`
	Playtraces        []Playtrace    `csv:"Playtraces"`
}

type Playtrace struct {
	gorm.Model
	PlaybackRelatedEventID int
	PlaybackRelatedEvent   PlaybackRelatedEvent
	EventType              string `json:"eventType"`
	SessionOffsetMs        int    `json:"sessionOffsetMs"`
	MediaOffsetMs          int    `json:"mediaOffsetMs"`
}

type Rating struct {
	gorm.Model
	ProfileName    string         `csv:"Profile Name" gorm:"uniqueIndex:netflix_ratings_key"`
	TitleName      string         `csv:"Title Name" gorm:"uniqueIndex:netflix_ratings_key"`
	RatingType     string         `csv:"Rating Type"`
	StarValue      int            `csv:"Star Value"`
	ThumbsValue    int            `csv:"Thumbs Value"`
	DeviceModel    string         `csv:"Device Model"`
	EventTime      types.DateTime `csv:"Event Utc Ts" gorm:"uniqueIndex:netflix_ratings_key"`
	RegionViewDate types.DateTime `csv:"Region View Date"`
}

type SearchHistoryItem struct {
	gorm.Model
	ProfileName    string             `csv:"Profile Name" gorm:"uniqueIndex:netflix_search_history_key"`
	CountryIsoCode string             `csv:"Country Iso Code"`
	Device         string             `csv:"Device" gorm:"uniqueIndex:netflix_search_history_key"`
	IsKids         types.NullableBool `csv:"Is Kids"`
	QueryTyped     string             `csv:"Query Typed"`
	DisplayedName  string             `csv:"Displayed Name"`
	Action         string             `csv:"Action"`
	Section        string             `csv:"Section"`
	Time           types.DateTime     `csv:"Utc Timestamp" gorm:"uniqueIndex:netflix_search_history_key"`
}

type SubscriptionHistoryItem struct {
	gorm.Model
	SubscriptionOpenedTime            types.DateTime  `csv:"Subscription Opened Ts" gorm:"unique"`
	IsFreeTrial                       bool            `csv:"Is Free Trial At Signup"`
	SubscriptionClosedTime            *types.DateTime `csv:"Subscription Closed Ts"`
	IsCustomerInitiatedCancel         bool            `csv:"Is Customer Initiated Cancel"`
	SignupPlanCategory                string          `csv:"Signup Plan Category"`
	SignupMaxConcurrentStreams        int             `csv:"Signup Max Concurrent Streams"`
	SignupMaxStreamingQuality         string          `csv:"Signup Max Streaming Quality"`
	PlanChangeDate                    types.DateTime  `csv:"Plan Change Date"`
	PlanChangeOldCategory             string          `csv:"Plan Change Old Category"`
	PlanChangeOldMaxConcurrentStreams int             `csv:"Plan Change Old Max Concurrent Streams"`
	PlanChangeOldMaxStreamingQuality  string          `csv:"Plan Change Old Max Streaming Quality"`
	PlanChangeNewCategory             string          `csv:"Plan Change New Category"`
	PlanChangeNewMaxConcurrentStreams int             `csv:"Plan Change New Max Concurrent Streams"`
	PlanChangeNewMaxStreamingQuality  string          `csv:"Plan Change New Max Streaming Quality"`
	CancellationReason                string          `csv:"Cancellation Reason"`
}

type ViewingAction struct {
	gorm.Model
	ProfileName           string         `csv:"Profile Name" gorm:"uniqueIndex:netflix_viewing_activity_key"`
	StartTime             types.DateTime `csv:"Start Time" gorm:"uniqueIndex:netflix_viewing_activity_key"`
	Duration              Duration       `csv:"Duration"`
	Attributes            string         `csv:"Attributes"`
	Title                 string         `csv:"Title" gorm:"uniqueIndex:netflix_viewing_activity_key"`
	SupplementalVideoType string         `csv:"Supplemental Video Type"`
	DeviceType            string         `csv:"Device Type"`
	Bookmark              Duration       `csv:"Bookmark"`
	LatestBookmark        Duration       `csv:"Latest Bookmark"`
	Country               string         `csv:"Country"`
}