Spaces:
Runtime error
Runtime error
| """User events schema definition.""" | |
| EVENT_TYPES = [ | |
| "click", "page_view", "purchase", "login", "logout", | |
| "search", "add_to_cart", "checkout", "refund", "scroll", | |
| ] | |
| DEVICE_TYPES = ["desktop", "mobile", "tablet"] | |
| OS_VALUES = ["Windows", "macOS", "iOS", "Android", "Linux"] | |
| BROWSER_VALUES = ["Chrome", "Firefox", "Safari", "Edge", "IE"] | |
| COUNTRY_CODES = [ | |
| "US", "GB", "DE", "FR", "CA", "AU", "IN", "JP", "BR", "MX", | |
| "IT", "ES", "NL", "SE", "NO", "DK", "FI", "PL", "RU", "CN", | |
| ] | |
| # Valid device/OS combos | |
| DEVICE_OS_COMPAT = { | |
| "desktop": ["Windows", "macOS", "Linux"], | |
| "mobile": ["iOS", "Android"], | |
| "tablet": ["iOS", "Android", "Windows"], | |
| } | |
| # Valid OS/browser combos (IE not on macOS/Linux) | |
| OS_BROWSER_COMPAT = { | |
| "Windows": ["Chrome", "Firefox", "Safari", "Edge", "IE"], | |
| "macOS": ["Chrome", "Firefox", "Safari", "Edge"], | |
| "iOS": ["Chrome", "Firefox", "Safari"], | |
| "Android": ["Chrome", "Firefox"], | |
| "Linux": ["Chrome", "Firefox"], | |
| } | |
| SCHEMA_COLUMNS = [ | |
| "event_id", | |
| "user_id", | |
| "session_id", | |
| "event_type", | |
| "timestamp", | |
| "page_url", | |
| "referrer_url", | |
| "ip_address", | |
| "device_type", | |
| "os", | |
| "browser", | |
| "country_code", | |
| "city", | |
| "duration_seconds", | |
| "revenue", | |
| "product_id", | |
| "quantity", | |
| "search_query", | |
| "user_agent", | |
| "is_authenticated", | |
| "user_age", | |
| "email", | |
| "user_registration_date", | |
| ] | |