defmodule Plausible.ClickhouseSession do use Ecto.Schema @primary_key false schema "sessions" do field :hostname, :string field :domain, :string field :user_id, Ch.Types.UInt64 field :session_id, Ch.Types.UInt64 field :start, :naive_datetime field :duration, Ch.Types.UInt32 field :is_bounce, :boolean field :entry_page, :string field :exit_page, :string field :pageviews, Ch.Types.Int32 field :events, Ch.Types.Int32 field :sign, Ch.Types.Int8 field :"entry_meta.key", {:array, :string} field :"entry_meta.value", {:array, :string} field :utm_medium, :string field :utm_source, :string field :utm_campaign, :string field :utm_content, :string field :utm_term, :string field :referrer, :string field :referrer_source, :string field :country_code, Ch.Types.FixedString, size: 2 field :subdivision1_code, :string field :subdivision2_code, :string field :city_geoname_id, Ch.Types.UInt32 field :screen_size, :string field :operating_system, :string field :operating_system_version, :string field :browser, :string field :browser_version, :string field :timestamp, :naive_datetime field :transferred_from, :string end def random_uint64() do :crypto.strong_rand_bytes(8) |> :binary.decode_unsigned() end end