You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
50 lines
1.3 KiB
Elixir
50 lines
1.3 KiB
Elixir
|
7 years ago
|
defmodule Plausible.ClickhouseSession do
|
||
|
7 years ago
|
use Ecto.Schema
|
||
|
|
|
||
|
7 years ago
|
@primary_key false
|
||
|
7 years ago
|
schema "sessions" do
|
||
|
|
field :hostname, :string
|
||
|
7 years ago
|
field :domain, :string
|
||
|
4 years ago
|
field :user_id, Ch.Types.UInt64
|
||
|
|
field :session_id, Ch.Types.UInt64
|
||
|
7 years ago
|
|
||
|
7 years ago
|
field :start, :naive_datetime
|
||
|
4 years ago
|
field :duration, Ch.Types.UInt32
|
||
|
7 years ago
|
field :is_bounce, :boolean
|
||
|
7 years ago
|
field :entry_page, :string
|
||
|
7 years ago
|
field :exit_page, :string
|
||
|
4 years ago
|
field :pageviews, Ch.Types.Int32
|
||
|
|
field :events, Ch.Types.Int32
|
||
|
|
field :sign, Ch.Types.Int8
|
||
|
7 years ago
|
|
||
|
4 years ago
|
field :"entry_meta.key", {:array, :string}
|
||
|
|
field :"entry_meta.value", {:array, :string}
|
||
|
5 years ago
|
|
||
|
6 years ago
|
field :utm_medium, :string
|
||
|
|
field :utm_source, :string
|
||
|
|
field :utm_campaign, :string
|
||
|
5 years ago
|
field :utm_content, :string
|
||
|
|
field :utm_term, :string
|
||
|
7 years ago
|
field :referrer, :string
|
||
|
|
field :referrer_source, :string
|
||
|
6 years ago
|
|
||
|
4 years ago
|
field :country_code, Ch.Types.FixedString, size: 2
|
||
|
|
field :subdivision1_code, :string
|
||
|
|
field :subdivision2_code, :string
|
||
|
|
field :city_geoname_id, Ch.Types.UInt32
|
||
|
5 years ago
|
|
||
|
7 years ago
|
field :screen_size, :string
|
||
|
|
field :operating_system, :string
|
||
|
6 years ago
|
field :operating_system_version, :string
|
||
|
7 years ago
|
field :browser, :string
|
||
|
6 years ago
|
field :browser_version, :string
|
||
|
7 years ago
|
field :timestamp, :naive_datetime
|
||
|
5 years ago
|
|
||
|
4 years ago
|
field :transferred_from, :string
|
||
|
7 years ago
|
end
|
||
|
|
|
||
|
7 years ago
|
def random_uint64() do
|
||
|
|
:crypto.strong_rand_bytes(8) |> :binary.decode_unsigned()
|
||
|
|
end
|
||
|
7 years ago
|
end
|