defmodule DaProductApp.Activity.CustomEvent do
  use Ecto.Schema
  import Ecto.Changeset

  @primary_key {:id, :id, autogenerate: true}  # Define id as auto-incrementing primary key
  schema "custom_events" do
    field :is_published, :boolean
    field :date_added, :utc_datetime
    field :created_by, :binary_id
    field :created_by_user, :string
    field :date_modified, :utc_datetime
    field :modified_by, :binary_id
    field :modified_by_user, :string
    field :checked_out, :utc_datetime
    field :checked_out_by, :integer
    field :checked_out_by_user, :string
    field :name, :string
    field :alias, :string
    field :payloads, :map  # Changed from :string to :map
    field :idgoal, :string
    field :discription, :string

    timestamps()
  end

  def changeset(custom_event, attrs) do
    custom_event
    |> cast(attrs, [
      :is_published,
      :date_added,
      :created_by,
      :created_by_user,
      :date_modified,
      :modified_by,
      :modified_by_user,
      :checked_out,
      :checked_out_by,
      :checked_out_by_user,
      :name,
      :alias,
      :payloads,
      :idgoal,
      :discription
    ])
    |> validate_required([:is_published, :name, :alias, :payloads])
    |> unique_constraint(:idgoal)
  end
end