aboutsummaryrefslogtreecommitdiffstats
path: root/db/schema.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/schema.rb')
-rw-r--r--db/schema.rb81
1 files changed, 51 insertions, 30 deletions
diff --git a/db/schema.rb b/db/schema.rb
index 0f6f21b83..7e0e9c2b5 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -15,15 +15,14 @@ ActiveRecord::Schema.define(version: 20180319043333) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
- enable_extension "hstore"
enable_extension "postgis"
+ enable_extension "hstore"
enable_extension "unaccent"
- enable_extension "objectid"
create_table "access_links", id: :bigserial, force: :cascade do |t|
t.integer "access_point_id", limit: 8
t.integer "stop_area_id", limit: 8
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.string "name"
t.string "comment"
@@ -40,6 +39,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.string "link_orientation"
t.datetime "created_at"
t.datetime "updated_at"
+ t.jsonb "metadata", default: {}
end
add_index "access_links", ["objectid"], name: "access_links_objectid_key", unique: true, using: :btree
@@ -67,6 +67,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.text "import_xml"
t.datetime "created_at"
t.datetime "updated_at"
+ t.jsonb "metadata", default: {}
end
add_index "access_points", ["objectid"], name: "access_points_objectid_key", unique: true, using: :btree
@@ -78,6 +79,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.datetime "created_at"
t.datetime "updated_at"
t.integer "organisation_id", limit: 8
+ t.jsonb "metadata", default: {}
end
add_index "api_keys", ["organisation_id"], name: "index_api_keys_on_organisation_id", using: :btree
@@ -90,9 +92,10 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.integer "organisation_id", limit: 8
t.datetime "created_at"
t.datetime "updated_at"
+ t.integer "workgroup_id", limit: 8
t.integer "int_day_types"
t.date "excluded_dates", array: true
- t.integer "workgroup_id", limit: 8
+ t.jsonb "metadata", default: {}
end
add_index "calendars", ["organisation_id"], name: "index_calendars_on_organisation_id", using: :btree
@@ -118,13 +121,12 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.datetime "updated_at"
t.date "end_date"
t.string "date_type"
- t.string "mode"
end
add_index "clean_ups", ["referential_id"], name: "index_clean_ups_on_referential_id", using: :btree
create_table "companies", id: :bigserial, force: :cascade do |t|
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.string "name"
t.string "short_name"
@@ -141,7 +143,8 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.text "import_xml"
t.datetime "created_at"
t.datetime "updated_at"
- t.json "custom_field_values"
+ t.jsonb "custom_field_values"
+ t.jsonb "metadata", default: {}
end
add_index "companies", ["line_referential_id"], name: "index_companies_on_line_referential_id", using: :btree
@@ -194,14 +197,15 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.string "status"
t.integer "parent_id", limit: 8
t.string "parent_type"
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
t.string "current_step_id"
t.float "current_step_progress"
t.string "name"
t.datetime "started_at"
t.datetime "ended_at"
t.datetime "notified_parent_at"
+ t.jsonb "metadata", default: {}
end
add_index "compliance_check_sets", ["compliance_control_set_id"], name: "index_compliance_check_sets_on_compliance_control_set_id", using: :btree
@@ -240,8 +244,9 @@ ActiveRecord::Schema.define(version: 20180319043333) do
create_table "compliance_control_sets", id: :bigserial, force: :cascade do |t|
t.string "name"
t.integer "organisation_id", limit: 8
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.jsonb "metadata", default: {}
end
add_index "compliance_control_sets", ["organisation_id"], name: "index_compliance_control_sets_on_organisation_id", using: :btree
@@ -267,7 +272,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
create_table "connection_links", id: :bigserial, force: :cascade do |t|
t.integer "departure_id", limit: 8
t.integer "arrival_id", limit: 8
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.string "name"
t.string "comment"
@@ -283,6 +288,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.integer "int_user_needs"
t.datetime "created_at"
t.datetime "updated_at"
+ t.jsonb "metadata", default: {}
end
add_index "connection_links", ["objectid"], name: "connection_links_objectid_key", unique: true, using: :btree
@@ -400,7 +406,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
end
create_table "group_of_lines", id: :bigserial, force: :cascade do |t|
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.string "name"
t.string "comment"
@@ -409,6 +415,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.text "import_xml"
t.datetime "created_at"
t.datetime "updated_at"
+ t.jsonb "metadata", default: {}
end
add_index "group_of_lines", ["line_referential_id"], name: "index_group_of_lines_on_line_referential_id", using: :btree
@@ -462,9 +469,9 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.string "type"
t.integer "parent_id", limit: 8
t.string "parent_type"
+ t.datetime "notified_parent_at"
t.integer "current_step", default: 0
t.integer "total_steps", default: 0
- t.datetime "notified_parent_at"
t.string "creator"
end
@@ -487,7 +494,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
create_table "journey_patterns", id: :bigserial, force: :cascade do |t|
t.integer "route_id", limit: 8
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.string "name"
t.string "comment"
@@ -501,6 +508,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.text "checksum_source"
t.string "data_source_ref"
t.json "costs"
+ t.jsonb "metadata", default: {}
end
add_index "journey_patterns", ["objectid"], name: "journey_patterns_objectid_key", unique: true, using: :btree
@@ -574,6 +582,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.datetime "created_at"
t.datetime "updated_at"
t.boolean "seasonal"
+ t.jsonb "metadata", default: {}
end
add_index "lines", ["line_referential_id"], name: "index_lines_on_line_referential_id", using: :btree
@@ -595,7 +604,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
add_index "merges", ["workbench_id"], name: "index_merges_on_workbench_id", using: :btree
create_table "networks", id: :bigserial, force: :cascade do |t|
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.date "version_date"
t.string "description"
@@ -609,6 +618,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.integer "line_referential_id", limit: 8
t.datetime "created_at"
t.datetime "updated_at"
+ t.jsonb "metadata", default: {}
end
add_index "networks", ["line_referential_id"], name: "index_networks_on_line_referential_id", using: :btree
@@ -633,13 +643,14 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.integer "start_of_link_id", limit: 8
t.integer "end_of_link_id", limit: 8
t.integer "route_id", limit: 8
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.string "name"
t.string "comment"
t.decimal "link_distance", precision: 19, scale: 2
t.datetime "created_at"
t.datetime "updated_at"
+ t.jsonb "metadata", default: {}
end
add_index "pt_links", ["objectid"], name: "pt_links_objectid_key", unique: true, using: :btree
@@ -647,13 +658,14 @@ ActiveRecord::Schema.define(version: 20180319043333) do
create_table "purchase_windows", id: :bigserial, force: :cascade do |t|
t.string "name"
t.string "color"
- t.daterange "date_ranges", array: true
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
+ t.daterange "date_ranges", array: true
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
t.string "objectid"
t.string "checksum"
t.text "checksum_source"
t.integer "referential_id", limit: 8
+ t.jsonb "metadata", default: {}
end
add_index "purchase_windows", ["referential_id"], name: "index_purchase_windows_on_referential_id", using: :btree
@@ -744,6 +756,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.text "checksum_source"
t.string "data_source_ref"
t.json "costs"
+ t.jsonb "metadata"
end
add_index "routes", ["objectid"], name: "routes_objectid_key", unique: true, using: :btree
@@ -752,13 +765,14 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.string "name"
t.datetime "created_at"
t.datetime "updated_at"
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.integer "route_id", limit: 8
- t.integer "stop_point_ids", limit: 8, array: true
+ t.integer "stop_point_ids", limit: 8, array: true
t.string "checksum"
t.text "checksum_source"
t.string "data_source_ref"
+ t.jsonb "metadata", default: {}
end
create_table "routing_constraints_lines", id: false, force: :cascade do |t|
@@ -812,7 +826,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
create_table "stop_areas", id: :bigserial, force: :cascade do |t|
t.integer "parent_id", limit: 8
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.string "name"
t.string "comment"
@@ -845,6 +859,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.jsonb "localized_names"
t.datetime "confirmed_at"
t.jsonb "custom_field_values"
+ t.jsonb "metadata", default: {}
end
add_index "stop_areas", ["name"], name: "index_stop_areas_on_name", using: :btree
@@ -860,13 +875,14 @@ ActiveRecord::Schema.define(version: 20180319043333) do
create_table "stop_points", id: :bigserial, force: :cascade do |t|
t.integer "route_id", limit: 8
t.integer "stop_area_id", limit: 8
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.integer "position"
t.string "for_boarding"
t.string "for_alighting"
t.datetime "created_at"
t.datetime "updated_at"
+ t.jsonb "metadata", default: {}
end
add_index "stop_points", ["objectid"], name: "stop_points_objectid_key", unique: true, using: :btree
@@ -914,7 +930,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
add_index "time_table_periods", ["time_table_id"], name: "index_time_table_periods_on_time_table_id", using: :btree
create_table "time_tables", id: :bigserial, force: :cascade do |t|
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8, default: 1
t.string "version"
t.string "comment"
@@ -929,6 +945,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.string "checksum"
t.text "checksum_source"
t.string "data_source_ref"
+ t.jsonb "metadata", default: {}
end
add_index "time_tables", ["calendar_id"], name: "index_time_tables_on_calendar_id", using: :btree
@@ -944,13 +961,14 @@ ActiveRecord::Schema.define(version: 20180319043333) do
add_index "time_tables_vehicle_journeys", ["vehicle_journey_id"], name: "index_time_tables_vehicle_journeys_on_vehicle_journey_id", using: :btree
create_table "timebands", id: :bigserial, force: :cascade do |t|
- t.string "objectid", null: false
+ t.string "objectid", null: false
t.integer "object_version", limit: 8
t.string "name"
- t.time "start_time", null: false
- t.time "end_time", null: false
+ t.time "start_time", null: false
+ t.time "end_time", null: false
t.datetime "created_at"
t.datetime "updated_at"
+ t.jsonb "metadata", default: {}
end
create_table "users", id: :bigserial, force: :cascade do |t|
@@ -1033,6 +1051,7 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.text "checksum_source"
t.string "data_source_ref"
t.jsonb "custom_field_values", default: {}
+ t.jsonb "metadata", default: {}
end
add_index "vehicle_journeys", ["objectid"], name: "vehicle_journeys_objectid_key", unique: true, using: :btree
@@ -1074,8 +1093,10 @@ ActiveRecord::Schema.define(version: 20180319043333) do
t.string "name"
t.integer "line_referential_id", limit: 8
t.integer "stop_area_referential_id", limit: 8
- t.datetime "created_at", null: false
- t.datetime "updated_at", null: false
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ t.string "import_types", default: [], array: true
+ t.string "export_types", default: [], array: true
end
add_foreign_key "access_links", "access_points", name: "aclk_acpt_fkey"
generated by cgit v1.2.3 (git 2.25.1) at 2025-11-01 05:31:25 +0000