Gleipnir/nidus-sync
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity
nidus-sync/db/dbinfo/fieldseeker.proposedtreatmentarea.bob.go

473 lines
12 KiB
Go
Raw Permalink Normal View History

Make GlobalID required for all Fieldseeker tables I'm pretty sure it has to be there, and it allows me to clean up my code.
2026-01-05 02:28:28 +00:00
// Code generated by BobGen psql v0.0.4-0.20260105020634-53e08d840e47+dirty. DO NOT EDIT.
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
// This file is meant to be re-generated in place and/or deleted at any time.
package dbinfo
import "github.com/aarondl/opt/null"
var FieldseekerProposedtreatmentareas = Table[
fieldseekerProposedtreatmentareaColumns,
fieldseekerProposedtreatmentareaIndexes,
fieldseekerProposedtreatmentareaForeignKeys,
fieldseekerProposedtreatmentareaUniques,
fieldseekerProposedtreatmentareaChecks,
]{
Schema: "fieldseeker",
Name: "proposedtreatmentarea",
Columns: fieldseekerProposedtreatmentareaColumns{
Objectid: column{
Name: "objectid",
DBType: "bigint",
Default: "nextval('fieldseeker.proposedtreatmentarea_objectid_seq'::regclass)",
Comment: "",
Nullable: false,
Generated: false,
AutoIncr: false,
},
Method: column{
Name: "method",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
DBType: "character varying",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is METHOD",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Comments: column{
Name: "comments",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is COMMENTS",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Zone: column{
Name: "zone",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is ZONE",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Reviewed: column{
Name: "reviewed",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
DBType: "smallint",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is REVIEWED",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Reviewedby: column{
Name: "reviewedby",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is REVIEWEDBY",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Revieweddate: column{
Name: "revieweddate",
DBType: "timestamp without time zone",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is REVIEWEDDATE",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Zone2: column{
Name: "zone2",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is ZONE2",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Completeddate: column{
Name: "completeddate",
DBType: "timestamp without time zone",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is COMPLETEDDATE",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Completedby: column{
Name: "completedby",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is COMPLETEDBY",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Completed: column{
Name: "completed",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
DBType: "smallint",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is COMPLETED",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Issprayroute: column{
Name: "issprayroute",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
DBType: "smallint",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is ISSPRAYROUTE",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Name: column{
Name: "name",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is NAME",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Acres: column{
Name: "acres",
DBType: "double precision",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is ACRES",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Globalid: column{
Name: "globalid",
DBType: "uuid",
Make GlobalID required for all Fieldseeker tables I'm pretty sure it has to be there, and it allows me to clean up my code.
2026-01-05 02:28:28 +00:00
Default: "",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is GlobalID",
Make GlobalID required for all Fieldseeker tables I'm pretty sure it has to be there, and it allows me to clean up my code.
2026-01-05 02:28:28 +00:00
Nullable: false,
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Generated: false,
AutoIncr: false,
},
Exported: column{
Name: "exported",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
DBType: "smallint",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is EXPORTED",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Targetproduct: column{
Name: "targetproduct",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is TARGETPRODUCT",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Targetapprate: column{
Name: "targetapprate",
DBType: "double precision",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is TARGETAPPRATE",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Hectares: column{
Name: "hectares",
DBType: "double precision",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is HECTARES",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Lasttreatactivity: column{
Name: "lasttreatactivity",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is LASTTREATACTIVITY",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Lasttreatdate: column{
Name: "lasttreatdate",
DBType: "timestamp without time zone",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is LASTTREATDATE",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Lasttreatproduct: column{
Name: "lasttreatproduct",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is LASTTREATPRODUCT",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Lasttreatqty: column{
Name: "lasttreatqty",
DBType: "double precision",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is LASTTREATQTY",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Lasttreatqtyunit: column{
Name: "lasttreatqtyunit",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is LASTTREATQTYUNIT",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Priority: column{
Name: "priority",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
DBType: "character varying",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is PRIORITY",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Duedate: column{
Name: "duedate",
DBType: "timestamp without time zone",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is DUEDATE",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Creationdate: column{
Name: "creationdate",
DBType: "timestamp without time zone",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is CreationDate",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Creator: column{
Name: "creator",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is Creator",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Editdate: column{
Name: "editdate",
DBType: "timestamp without time zone",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is EditDate",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Editor: column{
Name: "editor",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is Editor",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
Targetspecies: column{
Name: "targetspecies",
DBType: "character varying",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is TARGETSPECIES",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
ShapeArea: column{
Name: "shape__area",
DBType: "double precision",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is Shape__Area",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Nullable: true,
Generated: false,
AutoIncr: false,
},
ShapeLength: column{
Name: "shape__length",
DBType: "double precision",
Default: "NULL",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "Original attribute from ArcGIS API is Shape__Length",
Nullable: true,
Generated: false,
AutoIncr: false,
},
Geometry: column{
Name: "geometry",
DBType: "jsonb",
Default: "",
Comment: "",
Nullable: false,
Generated: false,
AutoIncr: false,
},
Geospatial: column{
Name: "geospatial",
DBType: "geometry",
Default: "NULL",
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
Initially made it through full update with new fieldseeker schema
2025-12-05 23:11:57 +00:00
Version: column{
Name: "version",
DBType: "integer",
Default: "1",
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Comment: "",
Nullable: false,
Generated: false,
AutoIncr: false,
},
OrganizationID: column{
Name: "organization_id",
DBType: "integer",
Default: "",
Comment: "",
Initially made it through full update with new fieldseeker schema
2025-12-05 23:11:57 +00:00
Nullable: false,
Generated: false,
AutoIncr: false,
},
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
},
Indexes: fieldseekerProposedtreatmentareaIndexes{
ProposedtreatmentareaPkey: index{
Type: "btree",
Name: "proposedtreatmentarea_pkey",
Columns: []indexColumn{
{
Name: "objectid",
Desc: null.FromCond(false, true),
IsExpression: false,
},
Initially made it through full update with new fieldseeker schema
2025-12-05 23:11:57 +00:00
{
Name: "version",
Desc: null.FromCond(false, true),
IsExpression: false,
},
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
},
Unique: true,
Comment: "",
Initially made it through full update with new fieldseeker schema
2025-12-05 23:11:57 +00:00
NullsFirst: []bool{false, false},
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
NullsDistinct: false,
Where: "",
Include: []string{},
},
},
PrimaryKey: &constraint{
Name: "proposedtreatmentarea_pkey",
Initially made it through full update with new fieldseeker schema
2025-12-05 23:11:57 +00:00
Columns: []string{"objectid", "version"},
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Comment: "",
},
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
ForeignKeys: fieldseekerProposedtreatmentareaForeignKeys{
FieldseekerProposedtreatmentareaProposedtreatmentareaOrganizationIDFkey: foreignKey{
constraint: constraint{
Name: "fieldseeker.proposedtreatmentarea.proposedtreatmentarea_organization_id_fkey",
Columns: []string{"organization_id"},
Comment: "",
},
ForeignTable: "organization",
ForeignColumns: []string{"id"},
},
},
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
Comment: "",
}
type fieldseekerProposedtreatmentareaColumns struct {
Objectid column
Method column
Comments column
Zone column
Reviewed column
Reviewedby column
Revieweddate column
Zone2 column
Completeddate column
Completedby column
Completed column
Issprayroute column
Name column
Acres column
Globalid column
Exported column
Targetproduct column
Targetapprate column
Hectares column
Lasttreatactivity column
Lasttreatdate column
Lasttreatproduct column
Lasttreatqty column
Lasttreatqtyunit column
Priority column
Duedate column
Creationdate column
Creator column
Editdate column
Editor column
Targetspecies column
ShapeArea column
ShapeLength column
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
Geometry column
Geospatial column
Initially made it through full update with new fieldseeker schema
2025-12-05 23:11:57 +00:00
Version column
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
OrganizationID column
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
}
func (c fieldseekerProposedtreatmentareaColumns) AsSlice() []column {
return []column{
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
c.Objectid, c.Method, c.Comments, c.Zone, c.Reviewed, c.Reviewedby, c.Revieweddate, c.Zone2, c.Completeddate, c.Completedby, c.Completed, c.Issprayroute, c.Name, c.Acres, c.Globalid, c.Exported, c.Targetproduct, c.Targetapprate, c.Hectares, c.Lasttreatactivity, c.Lasttreatdate, c.Lasttreatproduct, c.Lasttreatqty, c.Lasttreatqtyunit, c.Priority, c.Duedate, c.Creationdate, c.Creator, c.Editdate, c.Editor, c.Targetspecies, c.ShapeArea, c.ShapeLength, c.Geometry, c.Geospatial, c.Version, c.OrganizationID,
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
}
}
type fieldseekerProposedtreatmentareaIndexes struct {
ProposedtreatmentareaPkey index
}
func (i fieldseekerProposedtreatmentareaIndexes) AsSlice() []index {
return []index{
i.ProposedtreatmentareaPkey,
}
}
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
type fieldseekerProposedtreatmentareaForeignKeys struct {
FieldseekerProposedtreatmentareaProposedtreatmentareaOrganizationIDFkey foreignKey
}
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
func (f fieldseekerProposedtreatmentareaForeignKeys) AsSlice() []foreignKey {
Remove old FieldSeeker tables, use v2 generated tables. This requires a bunch of changes since the types on these tables are much closer to the underlying types of the Fieldseeker data we are getting back from the API. I now need to use proper UUID types everywhere, which means I had to modify the bob gen config to consistently use google UUID, my UUID library of choice. I also had to add the organization_id to all the fieldseeker tables since we rely on them existing for some of our compound queries. There were some changes to the API type signatures to get things to build. I may yet regret those.
2025-12-24 17:49:39 -07:00
return []foreignKey{
f.FieldseekerProposedtreatmentareaProposedtreatmentareaOrganizationIDFkey,
}
Move to latest bobgen, add fieldseeker schema references This is an intermediate step between shifting from the old fs_* prefixed table names to an entire fieldseeker schema. At this point we have both, and we aren't doing much with the new schema but compiling.
2025-12-02 00:28:14 +00:00
}
type fieldseekerProposedtreatmentareaUniques struct{}
func (u fieldseekerProposedtreatmentareaUniques) AsSlice() []constraint {
return []constraint{}
}
type fieldseekerProposedtreatmentareaChecks struct{}
func (c fieldseekerProposedtreatmentareaChecks) AsSlice() []check {
return []check{}
}
Reference in a new issue Copy permalink