20211113071804_fill_vf_economic_resource.exs (2117B)
1 # Zenflows is designed to implement the Valueflows vocabulary, 2 # written and maintained by srfsh <info@dyne.org>. 3 # Copyright (C) 2021-2023 Dyne.org foundation <foundation@dyne.org>. 4 # 5 # This program is free software: you can redistribute it and/or modify 6 # it under the terms of the GNU Affero General Public License as published by 7 # the Free Software Foundation, either version 3 of the License, or 8 # (at your option) any later version. 9 # 10 # This program is distributed in the hope that it will be useful, 11 # but WITHOUT ANY WARRANTY; without even the implied warranty of 12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13 # GNU Affero General Public License for more details. 14 # 15 # You should have received a copy of the GNU Affero General Public License 16 # along with this program. If not, see <https://www.gnu.org/licenses/>. 17 18 defmodule Zenflows.DB.Repo.Migrations.Fill_vf_economic_resource do 19 use Ecto.Migration 20 21 def change() do 22 alter table("vf_economic_resource") do 23 add :name, :text, null: false 24 add :note, :text 25 add :tracking_identifier, :text 26 add :classified_as, {:array, :text} 27 add :conforms_to_id, references("vf_resource_specification"), null: false 28 add :accounting_quantity_has_unit_id, references("vf_unit"), null: false 29 add :accounting_quantity_has_numerical_value, :decimal, null: false 30 add :onhand_quantity_has_unit_id, references("vf_unit"), null: false 31 add :onhand_quantity_has_numerical_value, :decimal, nulL: false 32 add :primary_accountable_id, references("vf_agent"), null: false 33 add :custodian_id, references("vf_agent"), null: false 34 add :stage_id, references("vf_process_specification") 35 add :state_id, :vf_action_id 36 add :current_location_id, references("vf_spatial_thing") 37 add :lot_id, references("vf_product_batch") 38 add :contained_in_id, references("vf_economic_resource") 39 add :unit_of_effort_id, references("vf_unit") 40 add :previous_event_id, references("vf_economic_event"), null: false 41 add :okhv, :text 42 add :repo, :text 43 add :version, :text 44 add :licensor, :text 45 add :license, :text 46 add :metadata, :jsonb 47 timestamps() 48 end 49 end 50 end