aboutsummaryrefslogtreecommitdiff
path: root/lib/db/schema.ex
blob: 860fc15101aec1fc96abae6351b81de23601e607 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
defmodule Thulani.Schema do
  alias Thulani.Schema

  defmodule Meme do
    use Ecto.Schema

    schema "memes" do
      has_many(:invocation_records, Schema.InvocationRecord)

      field(:title, :string)
      field(:content, :string)

      has_one(:image, Image)
      has_one(:audio, Audio)

      belongs_to(:metadata, Metadata)
    end
  end

  defmodule InvocationRecord do
    use Ecto.Schema

    schema "invocation_records" do
      field(:user_id, :integer)
      field(:message_id, :integer)
      field(:time, :utc_datetime)
      field(:random, :boolean)

      belongs_to(:meme, Schema.Meme)
    end
  end

  defmodule Metadata do
    use Ecto.Schema

    schema "metadata" do
      has_one(:meme, Schema.Meme)
      has_one(:audio, Schema.Audio)
      has_one(:image, Schema.Image)

      field(:created, :utc_datetime)
      field(:created_by, :integer)
    end
  end

  defmodule Audio do
    use Ecto.Schema

    schema "audio" do
      belongs_to(:metadata, Schema.Metadata)
      belongs_to(:meme, Schema.Meme)

      field(:data, :binary)
      field(:data_hash, :binary)
    end
  end

  defmodule Image do
    use Ecto.Schema

    schema "images" do
      belongs_to(:metadata, Schema.Metadata)
      belongs_to(:meme, Schema.Meme)

      field(:data, :binary)
      field(:data_hash, :binary)
      field(:filename, :string)
    end
  end

  defmodule Tombstone do
    use Ecto.Schema

    schema "tombstones" do
      field(:meme_id, :integer)

      field(:deleted_by, :integer)
      field(:deleted_at, :utc_datetime)

      has_one(:metadata, Schema.Metadata)
    end
  end
end