Documentation
¶
Index ¶
Constants ¶
This section is empty.
Variables ¶
View Source
var FieldseekerContainerrelates = Table[ fieldseekerContainerrelateColumns, fieldseekerContainerrelateIndexes, fieldseekerContainerrelateForeignKeys, fieldseekerContainerrelateUniques, fieldseekerContainerrelateChecks, ]{ Schema: "fieldseeker", Name: "containerrelate", Columns: fieldseekerContainerrelateColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.containerrelate_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Inspsampleid: column{ Name: "inspsampleid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is INSPSAMPLEID", Nullable: true, Generated: false, AutoIncr: false, }, Mosquitoinspid: column{ Name: "mosquitoinspid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is MOSQUITOINSPID", Nullable: true, Generated: false, AutoIncr: false, }, Treatmentid: column{ Name: "treatmentid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is TREATMENTID", Nullable: true, Generated: false, AutoIncr: false, }, Containertype: column{ Name: "containertype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CONTAINERTYPE", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerContainerrelateIndexes{ ContainerrelatePkey: index{ Type: "btree", Name: "containerrelate_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "containerrelate_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerContainerrelateForeignKeys{ FieldseekerContainerrelateContainerrelateOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerFieldscoutinglogs = Table[ fieldseekerFieldscoutinglogColumns, fieldseekerFieldscoutinglogIndexes, fieldseekerFieldscoutinglogForeignKeys, fieldseekerFieldscoutinglogUniques, fieldseekerFieldscoutinglogChecks, ]{ Schema: "fieldseeker", Name: "fieldscoutinglog", Columns: fieldseekerFieldscoutinglogColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.fieldscoutinglog_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Status: column{ Name: "status", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is STATUS", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerFieldscoutinglogIndexes{ FieldscoutinglogPkey: index{ Type: "btree", Name: "fieldscoutinglog_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "fieldscoutinglog_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerFieldscoutinglogForeignKeys{ FieldseekerFieldscoutinglogFieldscoutinglogOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerHabitatrelates = Table[ fieldseekerHabitatrelateColumns, fieldseekerHabitatrelateIndexes, fieldseekerHabitatrelateForeignKeys, fieldseekerHabitatrelateUniques, fieldseekerHabitatrelateChecks, ]{ Schema: "fieldseeker", Name: "habitatrelate", Columns: fieldseekerHabitatrelateColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.habitatrelate_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, ForeignID: column{ Name: "foreign_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is FOREIGN_ID", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Habitattype: column{ Name: "habitattype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABITATTYPE", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerHabitatrelateIndexes{ HabitatrelatePkey: index{ Type: "btree", Name: "habitatrelate_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "habitatrelate_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerHabitatrelateForeignKeys{ FieldseekerHabitatrelateHabitatrelateOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerInspectionsampledetails = Table[ fieldseekerInspectionsampledetailColumns, fieldseekerInspectionsampledetailIndexes, fieldseekerInspectionsampledetailForeignKeys, fieldseekerInspectionsampledetailUniques, fieldseekerInspectionsampledetailChecks, ]{ Schema: "fieldseeker", Name: "inspectionsampledetail", Columns: fieldseekerInspectionsampledetailColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.inspectionsampledetail_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, InspsampleID: column{ Name: "inspsample_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is INSPSAMPLE_ID", Nullable: true, Generated: false, AutoIncr: false, }, Fieldspecies: column{ Name: "fieldspecies", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FIELDSPECIES", Nullable: true, Generated: false, AutoIncr: false, }, Flarvcount: column{ Name: "flarvcount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is FLARVCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Fpupcount: column{ Name: "fpupcount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is FPUPCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Feggcount: column{ Name: "feggcount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is FEGGCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Flstages: column{ Name: "flstages", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FLSTAGES", Nullable: true, Generated: false, AutoIncr: false, }, Fdomstage: column{ Name: "fdomstage", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FDOMSTAGE", Nullable: true, Generated: false, AutoIncr: false, }, Fadultact: column{ Name: "fadultact", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FADULTACT", Nullable: true, Generated: false, AutoIncr: false, }, Labspecies: column{ Name: "labspecies", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LABSPECIES", Nullable: true, Generated: false, AutoIncr: false, }, Llarvcount: column{ Name: "llarvcount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LLARVCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Lpupcount: column{ Name: "lpupcount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LPUPCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Leggcount: column{ Name: "leggcount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LEGGCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Ldomstage: column{ Name: "ldomstage", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LDOMSTAGE", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Processed: column{ Name: "processed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is PROCESSED", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerInspectionsampledetailIndexes{ InspectionsampledetailPkey: index{ Type: "btree", Name: "inspectionsampledetail_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "inspectionsampledetail_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerInspectionsampledetailForeignKeys{ FieldseekerInspectionsampledetailInspectionsampledetailOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerInspectionsamples = Table[ fieldseekerInspectionsampleColumns, fieldseekerInspectionsampleIndexes, fieldseekerInspectionsampleForeignKeys, fieldseekerInspectionsampleUniques, fieldseekerInspectionsampleChecks, ]{ Schema: "fieldseeker", Name: "inspectionsample", Columns: fieldseekerInspectionsampleColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.inspectionsample_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, InspID: column{ Name: "insp_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is INSP_ID", Nullable: true, Generated: false, AutoIncr: false, }, Sampleid: column{ Name: "sampleid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SAMPLEID", Nullable: true, Generated: false, AutoIncr: false, }, Processed: column{ Name: "processed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is PROCESSED", Nullable: true, Generated: false, AutoIncr: false, }, Idbytech: column{ Name: "idbytech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is IDBYTECH", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerInspectionsampleIndexes{ InspectionsamplePkey: index{ Type: "btree", Name: "inspectionsample_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "inspectionsample_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerInspectionsampleForeignKeys{ FieldseekerInspectionsampleInspectionsampleOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerLinelocations = Table[ fieldseekerLinelocationColumns, fieldseekerLinelocationIndexes, fieldseekerLinelocationForeignKeys, fieldseekerLinelocationUniques, fieldseekerLinelocationChecks, ]{ Schema: "fieldseeker", Name: "linelocation", Columns: fieldseekerLinelocationColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.linelocation_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Name: column{ Name: "name", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is NAME", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Habitat: column{ Name: "habitat", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABITAT", Nullable: true, Generated: false, AutoIncr: false, }, Priority: column{ Name: "priority", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is PRIORITY", Nullable: true, Generated: false, AutoIncr: false, }, Usetype: column{ Name: "usetype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is USETYPE", Nullable: true, Generated: false, AutoIncr: false, }, Active: column{ Name: "active", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIVE", Nullable: true, Generated: false, AutoIncr: false, }, Description: column{ Name: "description", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is DESCRIPTION", Nullable: true, Generated: false, AutoIncr: false, }, Accessdesc: column{ Name: "accessdesc", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACCESSDESC", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Symbology: column{ Name: "symbology", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SYMBOLOGY", Nullable: true, Generated: false, AutoIncr: false, }, Externalid: column{ Name: "externalid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is EXTERNALID", Nullable: true, Generated: false, AutoIncr: false, }, Acres: column{ Name: "acres", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACRES", Nullable: true, Generated: false, AutoIncr: false, }, Nextactiondatescheduled: column{ Name: "nextactiondatescheduled", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is NEXTACTIONDATESCHEDULED", Nullable: true, Generated: false, AutoIncr: false, }, Larvinspectinterval: column{ Name: "larvinspectinterval", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LARVINSPECTINTERVAL", Nullable: true, Generated: false, AutoIncr: false, }, LengthFT: column{ Name: "length_ft", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LENGTH_FT", Nullable: true, Generated: false, AutoIncr: false, }, WidthFT: column{ Name: "width_ft", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is WIDTH_FT", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Locationnumber: column{ Name: "locationnumber", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNUMBER", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectdate: column{ Name: "lastinspectdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTDATE", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectbreeding: column{ Name: "lastinspectbreeding", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTBREEDING", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectavglarvae: column{ Name: "lastinspectavglarvae", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTAVGLARVAE", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectavgpupae: column{ Name: "lastinspectavgpupae", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTAVGPUPAE", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectlstages: column{ Name: "lastinspectlstages", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTLSTAGES", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectactiontaken: column{ Name: "lastinspectactiontaken", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTACTIONTAKEN", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectfieldspecies: column{ Name: "lastinspectfieldspecies", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTFIELDSPECIES", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatdate: column{ Name: "lasttreatdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATDATE", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatproduct: column{ Name: "lasttreatproduct", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATPRODUCT", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatqty: column{ Name: "lasttreatqty", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATQTY", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatqtyunit: column{ Name: "lasttreatqtyunit", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATQTYUNIT", Nullable: true, Generated: false, AutoIncr: false, }, Hectares: column{ Name: "hectares", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is HECTARES", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectactivity: column{ Name: "lastinspectactivity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatactivity: column{ Name: "lasttreatactivity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, LengthMeters: column{ Name: "length_meters", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LENGTH_METERS", Nullable: true, Generated: false, AutoIncr: false, }, WidthMeters: column{ Name: "width_meters", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is WIDTH_METERS", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectconditions: column{ Name: "lastinspectconditions", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTCONDITIONS", Nullable: true, Generated: false, AutoIncr: false, }, Waterorigin: column{ Name: "waterorigin", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WATERORIGIN", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Jurisdiction: column{ Name: "jurisdiction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is JURISDICTION", Nullable: true, Generated: false, AutoIncr: false, }, ShapeLength: column{ Name: "shape__length", DBType: "double precision", Default: "NULL", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerLinelocationIndexes{ LinelocationPkey: index{ Type: "btree", Name: "linelocation_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "linelocation_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerLinelocationForeignKeys{ FieldseekerLinelocationLinelocationOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerLocationtrackings = Table[ fieldseekerLocationtrackingColumns, fieldseekerLocationtrackingIndexes, fieldseekerLocationtrackingForeignKeys, fieldseekerLocationtrackingUniques, fieldseekerLocationtrackingChecks, ]{ Schema: "fieldseeker", Name: "locationtracking", Columns: fieldseekerLocationtrackingColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.locationtracking_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Accuracy: column{ Name: "accuracy", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is Accuracy", Nullable: true, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, Fieldtech: column{ Name: "fieldtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FIELDTECH", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerLocationtrackingIndexes{ LocationtrackingPkey: index{ Type: "btree", Name: "locationtracking_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "locationtracking_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerLocationtrackingForeignKeys{ FieldseekerLocationtrackingLocationtrackingOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerMosquitoinspections = Table[ fieldseekerMosquitoinspectionColumns, fieldseekerMosquitoinspectionIndexes, fieldseekerMosquitoinspectionForeignKeys, fieldseekerMosquitoinspectionUniques, fieldseekerMosquitoinspectionChecks, ]{ Schema: "fieldseeker", Name: "mosquitoinspection", Columns: fieldseekerMosquitoinspectionColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.mosquitoinspection_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Numdips: column{ Name: "numdips", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is NUMDIPS", Nullable: true, Generated: false, AutoIncr: false, }, Activity: column{ Name: "activity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, Breeding: column{ Name: "breeding", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is BREEDING", Nullable: true, Generated: false, AutoIncr: false, }, Totlarvae: column{ Name: "totlarvae", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is TOTLARVAE", Nullable: true, Generated: false, AutoIncr: false, }, Totpupae: column{ Name: "totpupae", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is TOTPUPAE", Nullable: true, Generated: false, AutoIncr: false, }, Eggs: column{ Name: "eggs", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is EGGS", Nullable: true, Generated: false, AutoIncr: false, }, Posdips: column{ Name: "posdips", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is POSDIPS", Nullable: true, Generated: false, AutoIncr: false, }, Adultact: column{ Name: "adultact", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ADULTACT", Nullable: true, Generated: false, AutoIncr: false, }, Lstages: column{ Name: "lstages", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LSTAGES", Nullable: true, Generated: false, AutoIncr: false, }, Domstage: column{ Name: "domstage", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is DOMSTAGE", Nullable: true, Generated: false, AutoIncr: false, }, Actiontaken: column{ Name: "actiontaken", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIONTAKEN", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Avetemp: column{ Name: "avetemp", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is AVETEMP", Nullable: true, Generated: false, AutoIncr: false, }, Windspeed: column{ Name: "windspeed", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is WINDSPEED", Nullable: true, Generated: false, AutoIncr: false, }, Raingauge: column{ Name: "raingauge", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is RAINGAUGE", Nullable: true, Generated: false, AutoIncr: false, }, Startdatetime: column{ Name: "startdatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is STARTDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Enddatetime: column{ Name: "enddatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is ENDDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Winddir: column{ Name: "winddir", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WINDDIR", Nullable: true, Generated: false, AutoIncr: false, }, Avglarvae: column{ Name: "avglarvae", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is AVGLARVAE", Nullable: true, Generated: false, AutoIncr: false, }, Avgpupae: column{ Name: "avgpupae", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is AVGPUPAE", Nullable: true, Generated: false, AutoIncr: false, }, Reviewed: column{ Name: "reviewed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWED", Nullable: true, Generated: false, AutoIncr: false, }, Reviewedby: column{ Name: "reviewedby", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDBY", Nullable: true, Generated: false, AutoIncr: false, }, Revieweddate: column{ Name: "revieweddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Locationname: column{ Name: "locationname", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNAME", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Recordstatus: column{ Name: "recordstatus", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is RECORDSTATUS", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Personalcontact: column{ Name: "personalcontact", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is PERSONALCONTACT", Nullable: true, Generated: false, AutoIncr: false, }, Tirecount: column{ Name: "tirecount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is TIRECOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Cbcount: column{ Name: "cbcount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is CBCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Containercount: column{ Name: "containercount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is CONTAINERCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Fieldspecies: column{ Name: "fieldspecies", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FIELDSPECIES", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Linelocid: column{ Name: "linelocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is LINELOCID", Nullable: true, Generated: false, AutoIncr: false, }, Pointlocid: column{ Name: "pointlocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is POINTLOCID", Nullable: true, Generated: false, AutoIncr: false, }, Polygonlocid: column{ Name: "polygonlocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is POLYGONLOCID", Nullable: true, Generated: false, AutoIncr: false, }, Srid: column{ Name: "srid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is SRID", Nullable: true, Generated: false, AutoIncr: false, }, Fieldtech: column{ Name: "fieldtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FIELDTECH", Nullable: true, Generated: false, AutoIncr: false, }, Larvaepresent: column{ Name: "larvaepresent", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LARVAEPRESENT", Nullable: true, Generated: false, AutoIncr: false, }, Pupaepresent: column{ Name: "pupaepresent", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is PUPAEPRESENT", Nullable: true, Generated: false, AutoIncr: false, }, Sdid: column{ Name: "sdid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is SDID", Nullable: true, Generated: false, AutoIncr: false, }, Sitecond: column{ Name: "sitecond", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SITECOND", Nullable: true, Generated: false, AutoIncr: false, }, Positivecontainercount: column{ Name: "positivecontainercount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is POSITIVECONTAINERCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Jurisdiction: column{ Name: "jurisdiction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is JURISDICTION", Nullable: true, Generated: false, AutoIncr: false, }, Visualmonitoring: column{ Name: "visualmonitoring", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is VISUALMONITORING", Nullable: true, Generated: false, AutoIncr: false, }, Vmcomments: column{ Name: "vmcomments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is VMCOMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Adminaction: column{ Name: "adminaction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is adminAction", Nullable: true, Generated: false, AutoIncr: false, }, Ptaid: column{ Name: "ptaid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is PTAID", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerMosquitoinspectionIndexes{ MosquitoinspectionPkey: index{ Type: "btree", Name: "mosquitoinspection_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "mosquitoinspection_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerMosquitoinspectionForeignKeys{ FieldseekerMosquitoinspectionMosquitoinspectionOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerPointlocations = Table[ fieldseekerPointlocationColumns, fieldseekerPointlocationIndexes, fieldseekerPointlocationForeignKeys, fieldseekerPointlocationUniques, fieldseekerPointlocationChecks, ]{ Schema: "fieldseeker", Name: "pointlocation", Columns: fieldseekerPointlocationColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.pointlocation_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Name: column{ Name: "name", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is NAME", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Habitat: column{ Name: "habitat", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABITAT", Nullable: true, Generated: false, AutoIncr: false, }, Priority: column{ Name: "priority", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is PRIORITY", Nullable: true, Generated: false, AutoIncr: false, }, Usetype: column{ Name: "usetype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is USETYPE", Nullable: true, Generated: false, AutoIncr: false, }, Active: column{ Name: "active", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIVE", Nullable: true, Generated: false, AutoIncr: false, }, Description: column{ Name: "description", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is DESCRIPTION", Nullable: true, Generated: false, AutoIncr: false, }, Accessdesc: column{ Name: "accessdesc", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACCESSDESC", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Symbology: column{ Name: "symbology", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SYMBOLOGY", Nullable: true, Generated: false, AutoIncr: false, }, Externalid: column{ Name: "externalid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is EXTERNALID", Nullable: true, Generated: false, AutoIncr: false, }, Nextactiondatescheduled: column{ Name: "nextactiondatescheduled", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is NEXTACTIONDATESCHEDULED", Nullable: true, Generated: false, AutoIncr: false, }, Larvinspectinterval: column{ Name: "larvinspectinterval", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LARVINSPECTINTERVAL", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Locationnumber: column{ Name: "locationnumber", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNUMBER", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, Stype: column{ Name: "stype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is STYPE", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectdate: column{ Name: "lastinspectdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTDATE", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectbreeding: column{ Name: "lastinspectbreeding", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTBREEDING", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectavglarvae: column{ Name: "lastinspectavglarvae", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTAVGLARVAE", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectavgpupae: column{ Name: "lastinspectavgpupae", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTAVGPUPAE", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectlstages: column{ Name: "lastinspectlstages", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTLSTAGES", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectactiontaken: column{ Name: "lastinspectactiontaken", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTACTIONTAKEN", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectfieldspecies: column{ Name: "lastinspectfieldspecies", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTFIELDSPECIES", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatdate: column{ Name: "lasttreatdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATDATE", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatproduct: column{ Name: "lasttreatproduct", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATPRODUCT", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatqty: column{ Name: "lasttreatqty", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATQTY", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatqtyunit: column{ Name: "lasttreatqtyunit", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATQTYUNIT", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectactivity: column{ Name: "lastinspectactivity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatactivity: column{ Name: "lasttreatactivity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectconditions: column{ Name: "lastinspectconditions", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTCONDITIONS", Nullable: true, Generated: false, AutoIncr: false, }, Waterorigin: column{ Name: "waterorigin", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WATERORIGIN", Nullable: true, Generated: false, AutoIncr: false, }, X: column{ Name: "x", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is X", Nullable: true, Generated: false, AutoIncr: false, }, Y: column{ Name: "y", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is Y", Nullable: true, Generated: false, AutoIncr: false, }, Assignedtech: column{ Name: "assignedtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ASSIGNEDTECH", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Jurisdiction: column{ Name: "jurisdiction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is JURISDICTION", Nullable: true, Generated: false, AutoIncr: false, }, DeactivateReason: column{ Name: "deactivate_reason", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is deactivate_reason", Nullable: true, Generated: false, AutoIncr: false, }, Scalarpriority: column{ Name: "scalarpriority", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is scalarPriority", Nullable: true, Generated: false, AutoIncr: false, }, Sourcestatus: column{ Name: "sourcestatus", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is sourceStatus", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, H3cell: column{ Name: "h3cell", DBType: "h3index", Default: "GENERATED", Comment: "", Nullable: true, Generated: true, AutoIncr: false, }, }, Indexes: fieldseekerPointlocationIndexes{ PointlocationPkey: index{ Type: "btree", Name: "pointlocation_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "pointlocation_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerPointlocationForeignKeys{ FieldseekerPointlocationPointlocationOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerPolygonlocations = Table[ fieldseekerPolygonlocationColumns, fieldseekerPolygonlocationIndexes, fieldseekerPolygonlocationForeignKeys, fieldseekerPolygonlocationUniques, fieldseekerPolygonlocationChecks, ]{ Schema: "fieldseeker", Name: "polygonlocation", Columns: fieldseekerPolygonlocationColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.polygonlocation_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Name: column{ Name: "name", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is NAME", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Habitat: column{ Name: "habitat", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABITAT", Nullable: true, Generated: false, AutoIncr: false, }, Priority: column{ Name: "priority", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is PRIORITY", Nullable: true, Generated: false, AutoIncr: false, }, Usetype: column{ Name: "usetype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is USETYPE", Nullable: true, Generated: false, AutoIncr: false, }, Active: column{ Name: "active", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIVE", Nullable: true, Generated: false, AutoIncr: false, }, Description: column{ Name: "description", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is DESCRIPTION", Nullable: true, Generated: false, AutoIncr: false, }, Accessdesc: column{ Name: "accessdesc", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACCESSDESC", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Symbology: column{ Name: "symbology", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SYMBOLOGY", Nullable: true, Generated: false, AutoIncr: false, }, Externalid: column{ Name: "externalid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is EXTERNALID", Nullable: true, Generated: false, AutoIncr: false, }, Acres: column{ Name: "acres", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACRES", Nullable: true, Generated: false, AutoIncr: false, }, Nextactiondatescheduled: column{ Name: "nextactiondatescheduled", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is NEXTACTIONDATESCHEDULED", Nullable: true, Generated: false, AutoIncr: false, }, Larvinspectinterval: column{ Name: "larvinspectinterval", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LARVINSPECTINTERVAL", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Locationnumber: column{ Name: "locationnumber", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNUMBER", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, Lastinspectdate: column{ Name: "lastinspectdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTDATE", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectbreeding: column{ Name: "lastinspectbreeding", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTBREEDING", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectavglarvae: column{ Name: "lastinspectavglarvae", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTAVGLARVAE", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectavgpupae: column{ Name: "lastinspectavgpupae", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTAVGPUPAE", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectlstages: column{ Name: "lastinspectlstages", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTLSTAGES", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectactiontaken: column{ Name: "lastinspectactiontaken", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTACTIONTAKEN", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectfieldspecies: column{ Name: "lastinspectfieldspecies", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTFIELDSPECIES", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatdate: column{ Name: "lasttreatdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATDATE", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatproduct: column{ Name: "lasttreatproduct", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATPRODUCT", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatqty: column{ Name: "lasttreatqty", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATQTY", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatqtyunit: column{ Name: "lasttreatqtyunit", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATQTYUNIT", Nullable: true, Generated: false, AutoIncr: false, }, Hectares: column{ Name: "hectares", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is HECTARES", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectactivity: column{ Name: "lastinspectactivity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatactivity: column{ Name: "lasttreatactivity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectconditions: column{ Name: "lastinspectconditions", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTCONDITIONS", Nullable: true, Generated: false, AutoIncr: false, }, Waterorigin: column{ Name: "waterorigin", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WATERORIGIN", Nullable: true, Generated: false, AutoIncr: false, }, Filter: column{ Name: "filter", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Filter", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Jurisdiction: column{ Name: "jurisdiction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is JURISDICTION", Nullable: true, Generated: false, AutoIncr: false, }, ShapeArea: column{ Name: "shape__area", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is Shape__Area", Nullable: true, Generated: false, AutoIncr: false, }, ShapeLength: column{ Name: "shape__length", DBType: "double precision", Default: "NULL", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerPolygonlocationIndexes{ PolygonlocationPkey: index{ Type: "btree", Name: "polygonlocation_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "polygonlocation_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerPolygonlocationForeignKeys{ FieldseekerPolygonlocationPolygonlocationOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerPooldetails = Table[ fieldseekerPooldetailColumns, fieldseekerPooldetailIndexes, fieldseekerPooldetailForeignKeys, fieldseekerPooldetailUniques, fieldseekerPooldetailChecks, ]{ Schema: "fieldseeker", Name: "pooldetail", Columns: fieldseekerPooldetailColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.pooldetail_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, TrapdataID: column{ Name: "trapdata_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is TRAPDATA_ID", Nullable: true, Generated: false, AutoIncr: false, }, PoolID: column{ Name: "pool_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is POOL_ID", Nullable: true, Generated: false, AutoIncr: false, }, Species: column{ Name: "species", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SPECIES", Nullable: true, Generated: false, AutoIncr: false, }, Females: column{ Name: "females", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is FEMALES", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerPooldetailIndexes{ PooldetailPkey: index{ Type: "btree", Name: "pooldetail_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "pooldetail_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerPooldetailForeignKeys{ FieldseekerPooldetailPooldetailOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerPools = Table[ fieldseekerPoolColumns, fieldseekerPoolIndexes, fieldseekerPoolForeignKeys, fieldseekerPoolUniques, fieldseekerPoolChecks, ]{ Schema: "fieldseeker", Name: "pool", Columns: fieldseekerPoolColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.pool_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, TrapdataID: column{ Name: "trapdata_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is TRAPDATA_ID", Nullable: true, Generated: false, AutoIncr: false, }, Datesent: column{ Name: "datesent", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is DATESENT", Nullable: true, Generated: false, AutoIncr: false, }, Survtech: column{ Name: "survtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SURVTECH", Nullable: true, Generated: false, AutoIncr: false, }, Datetested: column{ Name: "datetested", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is DATETESTED", Nullable: true, Generated: false, AutoIncr: false, }, Testtech: column{ Name: "testtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TESTTECH", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Sampleid: column{ Name: "sampleid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SAMPLEID", Nullable: true, Generated: false, AutoIncr: false, }, Processed: column{ Name: "processed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is PROCESSED", Nullable: true, Generated: false, AutoIncr: false, }, LabID: column{ Name: "lab_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is LAB_ID", Nullable: true, Generated: false, AutoIncr: false, }, Testmethod: column{ Name: "testmethod", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TESTMETHOD", Nullable: true, Generated: false, AutoIncr: false, }, Diseasetested: column{ Name: "diseasetested", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is DISEASETESTED", Nullable: true, Generated: false, AutoIncr: false, }, Diseasepos: column{ Name: "diseasepos", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is DISEASEPOS", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Lab: column{ Name: "lab", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LAB", Nullable: true, Generated: false, AutoIncr: false, }, Poolyear: column{ Name: "poolyear", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is POOLYEAR", Nullable: true, Generated: false, AutoIncr: false, }, Gatewaysync: column{ Name: "gatewaysync", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is GATEWAYSYNC", Nullable: true, Generated: false, AutoIncr: false, }, Vectorsurvcollectionid: column{ Name: "vectorsurvcollectionid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is VECTORSURVCOLLECTIONID", Nullable: true, Generated: false, AutoIncr: false, }, Vectorsurvpoolid: column{ Name: "vectorsurvpoolid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is VECTORSURVPOOLID", Nullable: true, Generated: false, AutoIncr: false, }, Vectorsurvtrapdataid: column{ Name: "vectorsurvtrapdataid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is VECTORSURVTRAPDATAID", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerPoolIndexes{ PoolPkey: index{ Type: "btree", Name: "pool_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "pool_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerPoolForeignKeys{ FieldseekerPoolPoolOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
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", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is METHOD", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Reviewed: column{ Name: "reviewed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWED", Nullable: true, Generated: false, AutoIncr: false, }, Reviewedby: column{ Name: "reviewedby", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDBY", Nullable: true, Generated: false, AutoIncr: false, }, Revieweddate: column{ Name: "revieweddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Completeddate: column{ Name: "completeddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMPLETEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Completedby: column{ Name: "completedby", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMPLETEDBY", Nullable: true, Generated: false, AutoIncr: false, }, Completed: column{ Name: "completed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMPLETED", Nullable: true, Generated: false, AutoIncr: false, }, Issprayroute: column{ Name: "issprayroute", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is ISSPRAYROUTE", Nullable: true, Generated: false, AutoIncr: false, }, Name: column{ Name: "name", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is NAME", Nullable: true, Generated: false, AutoIncr: false, }, Acres: column{ Name: "acres", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACRES", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, Exported: column{ Name: "exported", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is EXPORTED", Nullable: true, Generated: false, AutoIncr: false, }, Targetproduct: column{ Name: "targetproduct", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TARGETPRODUCT", Nullable: true, Generated: false, AutoIncr: false, }, Targetapprate: column{ Name: "targetapprate", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is TARGETAPPRATE", Nullable: true, Generated: false, AutoIncr: false, }, Hectares: column{ Name: "hectares", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is HECTARES", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatactivity: column{ Name: "lasttreatactivity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatdate: column{ Name: "lasttreatdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATDATE", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatproduct: column{ Name: "lasttreatproduct", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATPRODUCT", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatqty: column{ Name: "lasttreatqty", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATQTY", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatqtyunit: column{ Name: "lasttreatqtyunit", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTTREATQTYUNIT", Nullable: true, Generated: false, AutoIncr: false, }, Priority: column{ Name: "priority", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is PRIORITY", Nullable: true, Generated: false, AutoIncr: false, }, Duedate: column{ Name: "duedate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is DUEDATE", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Targetspecies: column{ Name: "targetspecies", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TARGETSPECIES", Nullable: true, Generated: false, AutoIncr: false, }, ShapeArea: column{ Name: "shape__area", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is Shape__Area", Nullable: true, Generated: false, AutoIncr: false, }, ShapeLength: column{ Name: "shape__length", DBType: "double precision", Default: "NULL", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerProposedtreatmentareaIndexes{ ProposedtreatmentareaPkey: index{ Type: "btree", Name: "proposedtreatmentarea_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "proposedtreatmentarea_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerProposedtreatmentareaForeignKeys{ FieldseekerProposedtreatmentareaProposedtreatmentareaOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerQamosquitoinspections = Table[ fieldseekerQamosquitoinspectionColumns, fieldseekerQamosquitoinspectionIndexes, fieldseekerQamosquitoinspectionForeignKeys, fieldseekerQamosquitoinspectionUniques, fieldseekerQamosquitoinspectionChecks, ]{ Schema: "fieldseeker", Name: "qamosquitoinspection", Columns: fieldseekerQamosquitoinspectionColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.qamosquitoinspection_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Posdips: column{ Name: "posdips", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is POSDIPS", Nullable: true, Generated: false, AutoIncr: false, }, Actiontaken: column{ Name: "actiontaken", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIONTAKEN", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Avetemp: column{ Name: "avetemp", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is AVETEMP", Nullable: true, Generated: false, AutoIncr: false, }, Windspeed: column{ Name: "windspeed", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is WINDSPEED", Nullable: true, Generated: false, AutoIncr: false, }, Raingauge: column{ Name: "raingauge", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is RAINGAUGE", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, Startdatetime: column{ Name: "startdatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is STARTDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Enddatetime: column{ Name: "enddatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is ENDDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Winddir: column{ Name: "winddir", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WINDDIR", Nullable: true, Generated: false, AutoIncr: false, }, Reviewed: column{ Name: "reviewed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWED", Nullable: true, Generated: false, AutoIncr: false, }, Reviewedby: column{ Name: "reviewedby", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDBY", Nullable: true, Generated: false, AutoIncr: false, }, Revieweddate: column{ Name: "revieweddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Locationname: column{ Name: "locationname", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNAME", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Recordstatus: column{ Name: "recordstatus", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is RECORDSTATUS", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, LR: column{ Name: "lr", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LR", Nullable: true, Generated: false, AutoIncr: false, }, Negdips: column{ Name: "negdips", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is NEGDIPS", Nullable: true, Generated: false, AutoIncr: false, }, Totalacres: column{ Name: "totalacres", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is TOTALACRES", Nullable: true, Generated: false, AutoIncr: false, }, Acresbreeding: column{ Name: "acresbreeding", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACRESBREEDING", Nullable: true, Generated: false, AutoIncr: false, }, Fish: column{ Name: "fish", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is FISH", Nullable: true, Generated: false, AutoIncr: false, }, Sitetype: column{ Name: "sitetype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SITETYPE", Nullable: true, Generated: false, AutoIncr: false, }, Breedingpotential: column{ Name: "breedingpotential", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is BREEDINGPOTENTIAL", Nullable: true, Generated: false, AutoIncr: false, }, Movingwater: column{ Name: "movingwater", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is MOVINGWATER", Nullable: true, Generated: false, AutoIncr: false, }, Nowaterever: column{ Name: "nowaterever", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is NOWATEREVER", Nullable: true, Generated: false, AutoIncr: false, }, Mosquitohabitat: column{ Name: "mosquitohabitat", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is MOSQUITOHABITAT", Nullable: true, Generated: false, AutoIncr: false, }, Habvalue1: column{ Name: "habvalue1", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABVALUE1", Nullable: true, Generated: false, AutoIncr: false, }, Habvalue1percent: column{ Name: "habvalue1percent", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABVALUE1PERCENT", Nullable: true, Generated: false, AutoIncr: false, }, Habvalue2: column{ Name: "habvalue2", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABVALUE2", Nullable: true, Generated: false, AutoIncr: false, }, Habvalue2percent: column{ Name: "habvalue2percent", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABVALUE2PERCENT", Nullable: true, Generated: false, AutoIncr: false, }, Potential: column{ Name: "potential", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is POTENTIAL", Nullable: true, Generated: false, AutoIncr: false, }, Larvaepresent: column{ Name: "larvaepresent", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LARVAEPRESENT", Nullable: true, Generated: false, AutoIncr: false, }, Larvaeinsidetreatedarea: column{ Name: "larvaeinsidetreatedarea", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LARVAEINSIDETREATEDAREA", Nullable: true, Generated: false, AutoIncr: false, }, Larvaeoutsidetreatedarea: column{ Name: "larvaeoutsidetreatedarea", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LARVAEOUTSIDETREATEDAREA", Nullable: true, Generated: false, AutoIncr: false, }, Larvaereason: column{ Name: "larvaereason", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LARVAEREASON", Nullable: true, Generated: false, AutoIncr: false, }, Aquaticorganisms: column{ Name: "aquaticorganisms", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is AQUATICORGANISMS", Nullable: true, Generated: false, AutoIncr: false, }, Vegetation: column{ Name: "vegetation", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is VEGETATION", Nullable: true, Generated: false, AutoIncr: false, }, Sourcereduction: column{ Name: "sourcereduction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SOURCEREDUCTION", Nullable: true, Generated: false, AutoIncr: false, }, Waterpresent: column{ Name: "waterpresent", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is WATERPRESENT", Nullable: true, Generated: false, AutoIncr: false, }, Watermovement1: column{ Name: "watermovement1", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WATERMOVEMENT1", Nullable: true, Generated: false, AutoIncr: false, }, Watermovement1percent: column{ Name: "watermovement1percent", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is WATERMOVEMENT1PERCENT", Nullable: true, Generated: false, AutoIncr: false, }, Watermovement2: column{ Name: "watermovement2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WATERMOVEMENT2", Nullable: true, Generated: false, AutoIncr: false, }, Watermovement2percent: column{ Name: "watermovement2percent", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is WATERMOVEMENT2PERCENT", Nullable: true, Generated: false, AutoIncr: false, }, Soilconditions: column{ Name: "soilconditions", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SOILCONDITIONS", Nullable: true, Generated: false, AutoIncr: false, }, Waterduration: column{ Name: "waterduration", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WATERDURATION", Nullable: true, Generated: false, AutoIncr: false, }, Watersource: column{ Name: "watersource", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WATERSOURCE", Nullable: true, Generated: false, AutoIncr: false, }, Waterconditions: column{ Name: "waterconditions", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WATERCONDITIONS", Nullable: true, Generated: false, AutoIncr: false, }, Adultactivity: column{ Name: "adultactivity", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is ADULTACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, Linelocid: column{ Name: "linelocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is LINELOCID", Nullable: true, Generated: false, AutoIncr: false, }, Pointlocid: column{ Name: "pointlocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is POINTLOCID", Nullable: true, Generated: false, AutoIncr: false, }, Polygonlocid: column{ Name: "polygonlocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is POLYGONLOCID", Nullable: true, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Fieldtech: column{ Name: "fieldtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FIELDTECH", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerQamosquitoinspectionIndexes{ QamosquitoinspectionPkey: index{ Type: "btree", Name: "qamosquitoinspection_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "qamosquitoinspection_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerQamosquitoinspectionForeignKeys{ FieldseekerQamosquitoinspectionQamosquitoinspectionOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerRodentlocations = Table[ fieldseekerRodentlocationColumns, fieldseekerRodentlocationIndexes, fieldseekerRodentlocationForeignKeys, fieldseekerRodentlocationUniques, fieldseekerRodentlocationChecks, ]{ Schema: "fieldseeker", Name: "rodentlocation", Columns: fieldseekerRodentlocationColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.rodentlocation_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Locationname: column{ Name: "locationname", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNAME", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Habitat: column{ Name: "habitat", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABITAT", Nullable: true, Generated: false, AutoIncr: false, }, Priority: column{ Name: "priority", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is PRIORITY", Nullable: true, Generated: false, AutoIncr: false, }, Usetype: column{ Name: "usetype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is USETYPE", Nullable: true, Generated: false, AutoIncr: false, }, Active: column{ Name: "active", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIVE", Nullable: true, Generated: false, AutoIncr: false, }, Description: column{ Name: "description", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is DESCRIPTION", Nullable: true, Generated: false, AutoIncr: false, }, Accessdesc: column{ Name: "accessdesc", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACCESSDESC", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Symbology: column{ Name: "symbology", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SYMBOLOGY", Nullable: true, Generated: false, AutoIncr: false, }, Externalid: column{ Name: "externalid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is EXTERNALID", Nullable: true, Generated: false, AutoIncr: false, }, Nextactiondatescheduled: column{ Name: "nextactiondatescheduled", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is NEXTACTIONDATESCHEDULED", Nullable: true, Generated: false, AutoIncr: false, }, Locationnumber: column{ Name: "locationnumber", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNUMBER", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectdate: column{ Name: "lastinspectdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTDATE", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectspecies: column{ Name: "lastinspectspecies", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTSPECIES", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectaction: column{ Name: "lastinspectaction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTACTION", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectconditions: column{ Name: "lastinspectconditions", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTCONDITIONS", Nullable: true, Generated: false, AutoIncr: false, }, Lastinspectrodentevidence: column{ Name: "lastinspectrodentevidence", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LASTINSPECTRODENTEVIDENCE", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Jurisdiction: column{ Name: "jurisdiction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is JURISDICTION", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerRodentlocationIndexes{ RodentlocationPkey: index{ Type: "btree", Name: "rodentlocation_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "rodentlocation_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerRodentlocationForeignKeys{ FieldseekerRodentlocationRodentlocationOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerSamplecollections = Table[ fieldseekerSamplecollectionColumns, fieldseekerSamplecollectionIndexes, fieldseekerSamplecollectionForeignKeys, fieldseekerSamplecollectionUniques, fieldseekerSamplecollectionChecks, ]{ Schema: "fieldseeker", Name: "samplecollection", Columns: fieldseekerSamplecollectionColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.samplecollection_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, LocID: column{ Name: "loc_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOC_ID", Nullable: true, Generated: false, AutoIncr: false, }, Startdatetime: column{ Name: "startdatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is STARTDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Enddatetime: column{ Name: "enddatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is ENDDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Sitecond: column{ Name: "sitecond", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SITECOND", Nullable: true, Generated: false, AutoIncr: false, }, Sampleid: column{ Name: "sampleid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SAMPLEID", Nullable: true, Generated: false, AutoIncr: false, }, Survtech: column{ Name: "survtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SURVTECH", Nullable: true, Generated: false, AutoIncr: false, }, Datesent: column{ Name: "datesent", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is DATESENT", Nullable: true, Generated: false, AutoIncr: false, }, Datetested: column{ Name: "datetested", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is DATETESTED", Nullable: true, Generated: false, AutoIncr: false, }, Testtech: column{ Name: "testtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TESTTECH", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Processed: column{ Name: "processed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is PROCESSED", Nullable: true, Generated: false, AutoIncr: false, }, Sampletype: column{ Name: "sampletype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SAMPLETYPE", Nullable: true, Generated: false, AutoIncr: false, }, Samplecond: column{ Name: "samplecond", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SAMPLECOND", Nullable: true, Generated: false, AutoIncr: false, }, Species: column{ Name: "species", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SPECIES", Nullable: true, Generated: false, AutoIncr: false, }, Sex: column{ Name: "sex", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SEX", Nullable: true, Generated: false, AutoIncr: false, }, Avetemp: column{ Name: "avetemp", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is AVETEMP", Nullable: true, Generated: false, AutoIncr: false, }, Windspeed: column{ Name: "windspeed", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is WINDSPEED", Nullable: true, Generated: false, AutoIncr: false, }, Winddir: column{ Name: "winddir", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WINDDIR", Nullable: true, Generated: false, AutoIncr: false, }, Raingauge: column{ Name: "raingauge", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is RAINGAUGE", Nullable: true, Generated: false, AutoIncr: false, }, Activity: column{ Name: "activity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, Testmethod: column{ Name: "testmethod", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TESTMETHOD", Nullable: true, Generated: false, AutoIncr: false, }, Diseasetested: column{ Name: "diseasetested", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is DISEASETESTED", Nullable: true, Generated: false, AutoIncr: false, }, Diseasepos: column{ Name: "diseasepos", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is DISEASEPOS", Nullable: true, Generated: false, AutoIncr: false, }, Reviewed: column{ Name: "reviewed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWED", Nullable: true, Generated: false, AutoIncr: false, }, Reviewedby: column{ Name: "reviewedby", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDBY", Nullable: true, Generated: false, AutoIncr: false, }, Revieweddate: column{ Name: "revieweddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Locationname: column{ Name: "locationname", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNAME", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Recordstatus: column{ Name: "recordstatus", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is RECORDSTATUS", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Lab: column{ Name: "lab", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LAB", Nullable: true, Generated: false, AutoIncr: false, }, Fieldtech: column{ Name: "fieldtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FIELDTECH", Nullable: true, Generated: false, AutoIncr: false, }, Flockid: column{ Name: "flockid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is FLOCKID", Nullable: true, Generated: false, AutoIncr: false, }, Samplecount: column{ Name: "samplecount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is SAMPLECOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Chickenid: column{ Name: "chickenid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is CHICKENID", Nullable: true, Generated: false, AutoIncr: false, }, Gatewaysync: column{ Name: "gatewaysync", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is GATEWAYSYNC", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerSamplecollectionIndexes{ SamplecollectionPkey: index{ Type: "btree", Name: "samplecollection_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "samplecollection_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerSamplecollectionForeignKeys{ FieldseekerSamplecollectionSamplecollectionOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerSamplelocations = Table[ fieldseekerSamplelocationColumns, fieldseekerSamplelocationIndexes, fieldseekerSamplelocationForeignKeys, fieldseekerSamplelocationUniques, fieldseekerSamplelocationChecks, ]{ Schema: "fieldseeker", Name: "samplelocation", Columns: fieldseekerSamplelocationColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.samplelocation_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Name: column{ Name: "name", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is NAME", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Habitat: column{ Name: "habitat", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABITAT", Nullable: true, Generated: false, AutoIncr: false, }, Priority: column{ Name: "priority", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is PRIORITY", Nullable: true, Generated: false, AutoIncr: false, }, Usetype: column{ Name: "usetype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is USETYPE", Nullable: true, Generated: false, AutoIncr: false, }, Active: column{ Name: "active", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIVE", Nullable: true, Generated: false, AutoIncr: false, }, Description: column{ Name: "description", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is DESCRIPTION", Nullable: true, Generated: false, AutoIncr: false, }, Accessdesc: column{ Name: "accessdesc", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACCESSDESC", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Externalid: column{ Name: "externalid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is EXTERNALID", Nullable: true, Generated: false, AutoIncr: false, }, Nextactiondatescheduled: column{ Name: "nextactiondatescheduled", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is NEXTACTIONDATESCHEDULED", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Locationnumber: column{ Name: "locationnumber", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNUMBER", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Gatewaysync: column{ Name: "gatewaysync", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is GATEWAYSYNC", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerSamplelocationIndexes{ SamplelocationPkey: index{ Type: "btree", Name: "samplelocation_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "samplelocation_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerSamplelocationForeignKeys{ FieldseekerSamplelocationSamplelocationOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerServicerequests = Table[ fieldseekerServicerequestColumns, fieldseekerServicerequestIndexes, fieldseekerServicerequestForeignKeys, fieldseekerServicerequestUniques, fieldseekerServicerequestChecks, ]{ Schema: "fieldseeker", Name: "servicerequest", Columns: fieldseekerServicerequestColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.servicerequest_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Recdatetime: column{ Name: "recdatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is RECDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Source: column{ Name: "source", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SOURCE", Nullable: true, Generated: false, AutoIncr: false, }, Entrytech: column{ Name: "entrytech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ENTRYTECH", Nullable: true, Generated: false, AutoIncr: false, }, Priority: column{ Name: "priority", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is PRIORITY", Nullable: true, Generated: false, AutoIncr: false, }, Supervisor: column{ Name: "supervisor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SUPERVISOR", Nullable: true, Generated: false, AutoIncr: false, }, Assignedtech: column{ Name: "assignedtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ASSIGNEDTECH", Nullable: true, Generated: false, AutoIncr: false, }, Status: column{ Name: "status", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is STATUS", Nullable: true, Generated: false, AutoIncr: false, }, Clranon: column{ Name: "clranon", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLRANON", Nullable: true, Generated: false, AutoIncr: false, }, Clrfname: column{ Name: "clrfname", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLRFNAME", Nullable: true, Generated: false, AutoIncr: false, }, Clrphone1: column{ Name: "clrphone1", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLRPHONE1", Nullable: true, Generated: false, AutoIncr: false, }, Clrphone2: column{ Name: "clrphone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLRPHONE2", Nullable: true, Generated: false, AutoIncr: false, }, Clremail: column{ Name: "clremail", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLREMAIL", Nullable: true, Generated: false, AutoIncr: false, }, Clrcompany: column{ Name: "clrcompany", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLRCOMPANY", Nullable: true, Generated: false, AutoIncr: false, }, Clraddr1: column{ Name: "clraddr1", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLRADDR1", Nullable: true, Generated: false, AutoIncr: false, }, Clraddr2: column{ Name: "clraddr2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLRADDR2", Nullable: true, Generated: false, AutoIncr: false, }, Clrcity: column{ Name: "clrcity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLRCITY", Nullable: true, Generated: false, AutoIncr: false, }, Clrstate: column{ Name: "clrstate", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLRSTATE", Nullable: true, Generated: false, AutoIncr: false, }, Clrzip: column{ Name: "clrzip", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLRZIP", Nullable: true, Generated: false, AutoIncr: false, }, Clrother: column{ Name: "clrother", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLROTHER", Nullable: true, Generated: false, AutoIncr: false, }, Clrcontpref: column{ Name: "clrcontpref", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is CLRCONTPREF", Nullable: true, Generated: false, AutoIncr: false, }, Reqcompany: column{ Name: "reqcompany", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQCOMPANY", Nullable: true, Generated: false, AutoIncr: false, }, Reqaddr1: column{ Name: "reqaddr1", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQADDR1", Nullable: true, Generated: false, AutoIncr: false, }, Reqaddr2: column{ Name: "reqaddr2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQADDR2", Nullable: true, Generated: false, AutoIncr: false, }, Reqcity: column{ Name: "reqcity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQCITY", Nullable: true, Generated: false, AutoIncr: false, }, Reqstate: column{ Name: "reqstate", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQSTATE", Nullable: true, Generated: false, AutoIncr: false, }, Reqzip: column{ Name: "reqzip", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQZIP", Nullable: true, Generated: false, AutoIncr: false, }, Reqcrossst: column{ Name: "reqcrossst", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQCROSSST", Nullable: true, Generated: false, AutoIncr: false, }, Reqsubdiv: column{ Name: "reqsubdiv", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQSUBDIV", Nullable: true, Generated: false, AutoIncr: false, }, Reqmapgrid: column{ Name: "reqmapgrid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQMAPGRID", Nullable: true, Generated: false, AutoIncr: false, }, Reqpermission: column{ Name: "reqpermission", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQPERMISSION", Nullable: true, Generated: false, AutoIncr: false, }, Reqtarget: column{ Name: "reqtarget", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQTARGET", Nullable: true, Generated: false, AutoIncr: false, }, Reqdescr: column{ Name: "reqdescr", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQDESCR", Nullable: true, Generated: false, AutoIncr: false, }, Reqnotesfortech: column{ Name: "reqnotesfortech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQNOTESFORTECH", Nullable: true, Generated: false, AutoIncr: false, }, Reqnotesforcust: column{ Name: "reqnotesforcust", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQNOTESFORCUST", Nullable: true, Generated: false, AutoIncr: false, }, Reqfldnotes: column{ Name: "reqfldnotes", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQFLDNOTES", Nullable: true, Generated: false, AutoIncr: false, }, Reqprogramactions: column{ Name: "reqprogramactions", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REQPROGRAMACTIONS", Nullable: true, Generated: false, AutoIncr: false, }, Datetimeclosed: column{ Name: "datetimeclosed", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is DATETIMECLOSED", Nullable: true, Generated: false, AutoIncr: false, }, Techclosed: column{ Name: "techclosed", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TECHCLOSED", Nullable: true, Generated: false, AutoIncr: false, }, SRNumber: column{ Name: "sr_number", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is SR_NUMBER", Nullable: true, Generated: false, AutoIncr: false, }, Reviewed: column{ Name: "reviewed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWED", Nullable: true, Generated: false, AutoIncr: false, }, Reviewedby: column{ Name: "reviewedby", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDBY", Nullable: true, Generated: false, AutoIncr: false, }, Revieweddate: column{ Name: "revieweddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Accepted: column{ Name: "accepted", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACCEPTED", Nullable: true, Generated: false, AutoIncr: false, }, Accepteddate: column{ Name: "accepteddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACCEPTEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Rejectedby: column{ Name: "rejectedby", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REJECTEDBY", Nullable: true, Generated: false, AutoIncr: false, }, Rejecteddate: column{ Name: "rejecteddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is REJECTEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Rejectedreason: column{ Name: "rejectedreason", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REJECTEDREASON", Nullable: true, Generated: false, AutoIncr: false, }, Duedate: column{ Name: "duedate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is DUEDATE", Nullable: true, Generated: false, AutoIncr: false, }, Acceptedby: column{ Name: "acceptedby", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACCEPTEDBY", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Estcompletedate: column{ Name: "estcompletedate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is ESTCOMPLETEDATE", Nullable: true, Generated: false, AutoIncr: false, }, Nextaction: column{ Name: "nextaction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is NEXTACTION", Nullable: true, Generated: false, AutoIncr: false, }, Recordstatus: column{ Name: "recordstatus", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is RECORDSTATUS", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Firstresponsedate: column{ Name: "firstresponsedate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is FIRSTRESPONSEDATE", Nullable: true, Generated: false, AutoIncr: false, }, Responsedaycount: column{ Name: "responsedaycount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is RESPONSEDAYCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Allowed: column{ Name: "allowed", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ALLOWED", Nullable: true, Generated: false, AutoIncr: false, }, Xvalue: column{ Name: "xvalue", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is XVALUE", Nullable: true, Generated: false, AutoIncr: false, }, Yvalue: column{ Name: "yvalue", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is YVALUE", Nullable: true, Generated: false, AutoIncr: false, }, Validx: column{ Name: "validx", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is VALIDX", Nullable: true, Generated: false, AutoIncr: false, }, Validy: column{ Name: "validy", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is VALIDY", Nullable: true, Generated: false, AutoIncr: false, }, Externalid: column{ Name: "externalid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is EXTERNALID", Nullable: true, Generated: false, AutoIncr: false, }, Externalerror: column{ Name: "externalerror", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is EXTERNALERROR", Nullable: true, Generated: false, AutoIncr: false, }, Pointlocid: column{ Name: "pointlocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is POINTLOCID", Nullable: true, Generated: false, AutoIncr: false, }, Notified: column{ Name: "notified", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is NOTIFIED", Nullable: true, Generated: false, AutoIncr: false, }, Notifieddate: column{ Name: "notifieddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is NOTIFIEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Scheduled: column{ Name: "scheduled", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is SCHEDULED", Nullable: true, Generated: false, AutoIncr: false, }, Scheduleddate: column{ Name: "scheduleddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is SCHEDULEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Dog: column{ Name: "dog", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is DOG", Nullable: true, Generated: false, AutoIncr: false, }, SchedulePeriod: column{ Name: "schedule_period", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is schedule_period", Nullable: true, Generated: false, AutoIncr: false, }, ScheduleNotes: column{ Name: "schedule_notes", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is schedule_notes", Nullable: true, Generated: false, AutoIncr: false, }, Spanish: column{ Name: "spanish", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is Spanish", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Issuesreported: column{ Name: "issuesreported", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ISSUESREPORTED", Nullable: true, Generated: false, AutoIncr: false, }, Jurisdiction: column{ Name: "jurisdiction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is JURISDICTION", Nullable: true, Generated: false, AutoIncr: false, }, Notificationtimestamp: column{ Name: "notificationtimestamp", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is NOTIFICATIONTIMESTAMP", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, H3cell: column{ Name: "h3cell", DBType: "h3index", Default: "GENERATED", Comment: "", Nullable: true, Generated: true, AutoIncr: false, }, }, Indexes: fieldseekerServicerequestIndexes{ ServicerequestPkey: index{ Type: "btree", Name: "servicerequest_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "servicerequest_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerServicerequestForeignKeys{ FieldseekerServicerequestServicerequestOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerSpeciesabundances = Table[ fieldseekerSpeciesabundanceColumns, fieldseekerSpeciesabundanceIndexes, fieldseekerSpeciesabundanceForeignKeys, fieldseekerSpeciesabundanceUniques, fieldseekerSpeciesabundanceChecks, ]{ Schema: "fieldseeker", Name: "speciesabundance", Columns: fieldseekerSpeciesabundanceColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.speciesabundance_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, TrapdataID: column{ Name: "trapdata_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is TRAPDATA_ID", Nullable: true, Generated: false, AutoIncr: false, }, Species: column{ Name: "species", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SPECIES", Nullable: true, Generated: false, AutoIncr: false, }, Males: column{ Name: "males", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is MALES", Nullable: true, Generated: false, AutoIncr: false, }, Unknown: column{ Name: "unknown", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is UNKNOWN", Nullable: true, Generated: false, AutoIncr: false, }, Bloodedfem: column{ Name: "bloodedfem", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is BLOODEDFEM", Nullable: true, Generated: false, AutoIncr: false, }, Gravidfem: column{ Name: "gravidfem", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is GRAVIDFEM", Nullable: true, Generated: false, AutoIncr: false, }, Larvae: column{ Name: "larvae", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LARVAE", Nullable: true, Generated: false, AutoIncr: false, }, Poolstogen: column{ Name: "poolstogen", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is POOLSTOGEN", Nullable: true, Generated: false, AutoIncr: false, }, Processed: column{ Name: "processed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is PROCESSED", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Pupae: column{ Name: "pupae", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is PUPAE", Nullable: true, Generated: false, AutoIncr: false, }, Eggs: column{ Name: "eggs", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is EGGS", Nullable: true, Generated: false, AutoIncr: false, }, Females: column{ Name: "females", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is FEMALES", Nullable: true, Generated: false, AutoIncr: false, }, Total: column{ Name: "total", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is TOTAL", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Yearweek: column{ Name: "yearweek", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is yearWeek", Nullable: true, Generated: false, AutoIncr: false, }, Globalzscore: column{ Name: "globalzscore", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is globalZScore", Nullable: true, Generated: false, AutoIncr: false, }, R7score: column{ Name: "r7score", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is r7Score", Nullable: true, Generated: false, AutoIncr: false, }, R8score: column{ Name: "r8score", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is r8Score", Nullable: true, Generated: false, AutoIncr: false, }, H3R7: column{ Name: "h3r7", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is h3r7", Nullable: true, Generated: false, AutoIncr: false, }, H3R8: column{ Name: "h3r8", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is h3r8", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerSpeciesabundanceIndexes{ SpeciesabundancePkey: index{ Type: "btree", Name: "speciesabundance_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "speciesabundance_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerSpeciesabundanceForeignKeys{ FieldseekerSpeciesabundanceSpeciesabundanceOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerStormdrains = Table[ fieldseekerStormdrainColumns, fieldseekerStormdrainIndexes, fieldseekerStormdrainForeignKeys, fieldseekerStormdrainUniques, fieldseekerStormdrainChecks, ]{ Schema: "fieldseeker", Name: "stormdrain", Columns: fieldseekerStormdrainColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.stormdrain_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Nexttreatmentdate: column{ Name: "nexttreatmentdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is NextTreatmentDate", Nullable: true, Generated: false, AutoIncr: false, }, Lasttreatdate: column{ Name: "lasttreatdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is LastTreatDate", Nullable: true, Generated: false, AutoIncr: false, }, Lastaction: column{ Name: "lastaction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LastAction", Nullable: true, Generated: false, AutoIncr: false, }, Symbology: column{ Name: "symbology", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Symbology", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Laststatus: column{ Name: "laststatus", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LastStatus", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Type: column{ Name: "type", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TYPE", Nullable: true, Generated: false, AutoIncr: false, }, Jurisdiction: column{ Name: "jurisdiction", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is JURISDICTION", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerStormdrainIndexes{ StormdrainPkey: index{ Type: "btree", Name: "stormdrain_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "stormdrain_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerStormdrainForeignKeys{ FieldseekerStormdrainStormdrainOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerSyncs = Table[ fieldseekerSyncColumns, fieldseekerSyncIndexes, fieldseekerSyncForeignKeys, fieldseekerSyncUniques, fieldseekerSyncChecks, ]{ Schema: "", Name: "fieldseeker_sync", Columns: fieldseekerSyncColumns{ ID: column{ Name: "id", DBType: "integer", Default: "nextval('fieldseeker_sync_id_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Created: column{ Name: "created", DBType: "timestamp without time zone", Default: "CURRENT_TIMESTAMP", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, RecordsCreated: column{ Name: "records_created", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, RecordsUpdated: column{ Name: "records_updated", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, RecordsUnchanged: column{ Name: "records_unchanged", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerSyncIndexes{ FieldseekerSyncPkey: index{ Type: "btree", Name: "fieldseeker_sync_pkey", Columns: []indexColumn{ { Name: "id", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "fieldseeker_sync_pkey", Columns: []string{"id"}, Comment: "", }, ForeignKeys: fieldseekerSyncForeignKeys{ FieldseekerSyncFieldseekerSyncOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerTimecards = Table[ fieldseekerTimecardColumns, fieldseekerTimecardIndexes, fieldseekerTimecardForeignKeys, fieldseekerTimecardUniques, fieldseekerTimecardChecks, ]{ Schema: "fieldseeker", Name: "timecard", Columns: fieldseekerTimecardColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.timecard_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Activity: column{ Name: "activity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, Startdatetime: column{ Name: "startdatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is STARTDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Enddatetime: column{ Name: "enddatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is ENDDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Externalid: column{ Name: "externalid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is EXTERNALID", Nullable: true, Generated: false, AutoIncr: false, }, Equiptype: column{ Name: "equiptype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is EQUIPTYPE", Nullable: true, Generated: false, AutoIncr: false, }, Locationname: column{ Name: "locationname", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNAME", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Linelocid: column{ Name: "linelocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is LINELOCID", Nullable: true, Generated: false, AutoIncr: false, }, Pointlocid: column{ Name: "pointlocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is POINTLOCID", Nullable: true, Generated: false, AutoIncr: false, }, Polygonlocid: column{ Name: "polygonlocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is POLYGONLOCID", Nullable: true, Generated: false, AutoIncr: false, }, Lclocid: column{ Name: "lclocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is LCLOCID", Nullable: true, Generated: false, AutoIncr: false, }, Samplelocid: column{ Name: "samplelocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is SAMPLELOCID", Nullable: true, Generated: false, AutoIncr: false, }, Srid: column{ Name: "srid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is SRID", Nullable: true, Generated: false, AutoIncr: false, }, Traplocid: column{ Name: "traplocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is TRAPLOCID", Nullable: true, Generated: false, AutoIncr: false, }, Fieldtech: column{ Name: "fieldtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FIELDTECH", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Rodentlocid: column{ Name: "rodentlocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is RODENTLOCID", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerTimecardIndexes{ TimecardPkey: index{ Type: "btree", Name: "timecard_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "timecard_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerTimecardForeignKeys{ FieldseekerTimecardTimecardOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerTrapdata = Table[ fieldseekerTrapdatumColumns, fieldseekerTrapdatumIndexes, fieldseekerTrapdatumForeignKeys, fieldseekerTrapdatumUniques, fieldseekerTrapdatumChecks, ]{ Schema: "fieldseeker", Name: "trapdata", Columns: fieldseekerTrapdatumColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.trapdata_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Traptype: column{ Name: "traptype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TRAPTYPE", Nullable: true, Generated: false, AutoIncr: false, }, Trapactivitytype: column{ Name: "trapactivitytype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TRAPACTIVITYTYPE", Nullable: true, Generated: false, AutoIncr: false, }, Startdatetime: column{ Name: "startdatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is STARTDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Enddatetime: column{ Name: "enddatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is ENDDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Idbytech: column{ Name: "idbytech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is IDBYTECH", Nullable: true, Generated: false, AutoIncr: false, }, Sortbytech: column{ Name: "sortbytech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SORTBYTECH", Nullable: true, Generated: false, AutoIncr: false, }, Processed: column{ Name: "processed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is PROCESSED", Nullable: true, Generated: false, AutoIncr: false, }, Sitecond: column{ Name: "sitecond", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SITECOND", Nullable: true, Generated: false, AutoIncr: false, }, Locationname: column{ Name: "locationname", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNAME", Nullable: true, Generated: false, AutoIncr: false, }, Recordstatus: column{ Name: "recordstatus", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is RECORDSTATUS", Nullable: true, Generated: false, AutoIncr: false, }, Reviewed: column{ Name: "reviewed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWED", Nullable: true, Generated: false, AutoIncr: false, }, Reviewedby: column{ Name: "reviewedby", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDBY", Nullable: true, Generated: false, AutoIncr: false, }, Revieweddate: column{ Name: "revieweddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Trapcondition: column{ Name: "trapcondition", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TRAPCONDITION", Nullable: true, Generated: false, AutoIncr: false, }, Trapnights: column{ Name: "trapnights", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is TRAPNIGHTS", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Srid: column{ Name: "srid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is SRID", Nullable: true, Generated: false, AutoIncr: false, }, Fieldtech: column{ Name: "fieldtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FIELDTECH", Nullable: true, Generated: false, AutoIncr: false, }, Gatewaysync: column{ Name: "gatewaysync", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is GATEWAYSYNC", Nullable: true, Generated: false, AutoIncr: false, }, LocID: column{ Name: "loc_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOC_ID", Nullable: true, Generated: false, AutoIncr: false, }, Voltage: column{ Name: "voltage", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is VOLTAGE", Nullable: true, Generated: false, AutoIncr: false, }, Winddir: column{ Name: "winddir", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WINDDIR", Nullable: true, Generated: false, AutoIncr: false, }, Windspeed: column{ Name: "windspeed", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is WINDSPEED", Nullable: true, Generated: false, AutoIncr: false, }, Avetemp: column{ Name: "avetemp", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is AVETEMP", Nullable: true, Generated: false, AutoIncr: false, }, Raingauge: column{ Name: "raingauge", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is RAINGAUGE", Nullable: true, Generated: false, AutoIncr: false, }, LR: column{ Name: "lr", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is LR", Nullable: true, Generated: false, AutoIncr: false, }, Field: column{ Name: "field", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is Field", Nullable: true, Generated: false, AutoIncr: false, }, Vectorsurvtrapdataid: column{ Name: "vectorsurvtrapdataid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is VECTORSURVTRAPDATAID", Nullable: true, Generated: false, AutoIncr: false, }, Vectorsurvtraplocationid: column{ Name: "vectorsurvtraplocationid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is VECTORSURVTRAPLOCATIONID", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Lure: column{ Name: "lure", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Lure", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, H3cell: column{ Name: "h3cell", DBType: "h3index", Default: "GENERATED", Comment: "", Nullable: true, Generated: true, AutoIncr: false, }, }, Indexes: fieldseekerTrapdatumIndexes{ TrapdataPkey: index{ Type: "btree", Name: "trapdata_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "trapdata_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerTrapdatumForeignKeys{ FieldseekerTrapdataTrapdataOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerTraplocations = Table[ fieldseekerTraplocationColumns, fieldseekerTraplocationIndexes, fieldseekerTraplocationForeignKeys, fieldseekerTraplocationUniques, fieldseekerTraplocationChecks, ]{ Schema: "fieldseeker", Name: "traplocation", Columns: fieldseekerTraplocationColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.traplocation_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Name: column{ Name: "name", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is NAME", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Habitat: column{ Name: "habitat", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABITAT", Nullable: true, Generated: false, AutoIncr: false, }, Priority: column{ Name: "priority", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is PRIORITY", Nullable: true, Generated: false, AutoIncr: false, }, Usetype: column{ Name: "usetype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is USETYPE", Nullable: true, Generated: false, AutoIncr: false, }, Active: column{ Name: "active", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIVE", Nullable: true, Generated: false, AutoIncr: false, }, Description: column{ Name: "description", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is DESCRIPTION", Nullable: true, Generated: false, AutoIncr: false, }, Accessdesc: column{ Name: "accessdesc", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACCESSDESC", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Externalid: column{ Name: "externalid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is EXTERNALID", Nullable: true, Generated: false, AutoIncr: false, }, Nextactiondatescheduled: column{ Name: "nextactiondatescheduled", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is NEXTACTIONDATESCHEDULED", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Locationnumber: column{ Name: "locationnumber", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNUMBER", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Gatewaysync: column{ Name: "gatewaysync", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is GATEWAYSYNC", Nullable: true, Generated: false, AutoIncr: false, }, Route: column{ Name: "route", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is route", Nullable: true, Generated: false, AutoIncr: false, }, SetDow: column{ Name: "set_dow", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is set_dow", Nullable: true, Generated: false, AutoIncr: false, }, RouteOrder: column{ Name: "route_order", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is route_order", Nullable: true, Generated: false, AutoIncr: false, }, Vectorsurvsiteid: column{ Name: "vectorsurvsiteid", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is VECTORSURVSITEID", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, H3R7: column{ Name: "h3r7", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is h3r7", Nullable: true, Generated: false, AutoIncr: false, }, H3R8: column{ Name: "h3r8", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is h3r8", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerTraplocationIndexes{ TraplocationPkey: index{ Type: "btree", Name: "traplocation_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "traplocation_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerTraplocationForeignKeys{ FieldseekerTraplocationTraplocationOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerTreatmentareas = Table[ fieldseekerTreatmentareaColumns, fieldseekerTreatmentareaIndexes, fieldseekerTreatmentareaForeignKeys, fieldseekerTreatmentareaUniques, fieldseekerTreatmentareaChecks, ]{ Schema: "fieldseeker", Name: "treatmentarea", Columns: fieldseekerTreatmentareaColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.treatmentarea_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, TreatID: column{ Name: "treat_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is TREAT_ID", Nullable: true, Generated: false, AutoIncr: false, }, SessionID: column{ Name: "session_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is SESSION_ID", Nullable: true, Generated: false, AutoIncr: false, }, Treatdate: column{ Name: "treatdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is TREATDATE", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Notified: column{ Name: "notified", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is Notified", Nullable: true, Generated: false, AutoIncr: false, }, Type: column{ Name: "type", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Type", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, ShapeArea: column{ Name: "shape__area", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is Shape__Area", Nullable: true, Generated: false, AutoIncr: false, }, ShapeLength: column{ Name: "shape__length", DBType: "double precision", Default: "NULL", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerTreatmentareaIndexes{ TreatmentareaPkey: index{ Type: "btree", Name: "treatmentarea_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "treatmentarea_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerTreatmentareaForeignKeys{ FieldseekerTreatmentareaTreatmentareaOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerTreatments = Table[ fieldseekerTreatmentColumns, fieldseekerTreatmentIndexes, fieldseekerTreatmentForeignKeys, fieldseekerTreatmentUniques, fieldseekerTreatmentChecks, ]{ Schema: "fieldseeker", Name: "treatment", Columns: fieldseekerTreatmentColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.treatment_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Activity: column{ Name: "activity", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIVITY", Nullable: true, Generated: false, AutoIncr: false, }, Treatarea: column{ Name: "treatarea", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is TREATAREA", Nullable: true, Generated: false, AutoIncr: false, }, Areaunit: column{ Name: "areaunit", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is AREAUNIT", Nullable: true, Generated: false, AutoIncr: false, }, Product: column{ Name: "product", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is PRODUCT", Nullable: true, Generated: false, AutoIncr: false, }, Qty: column{ Name: "qty", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is QTY", Nullable: true, Generated: false, AutoIncr: false, }, Qtyunit: column{ Name: "qtyunit", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is QTYUNIT", Nullable: true, Generated: false, AutoIncr: false, }, Method: column{ Name: "method", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is METHOD", Nullable: true, Generated: false, AutoIncr: false, }, Equiptype: column{ Name: "equiptype", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is EQUIPTYPE", Nullable: true, Generated: false, AutoIncr: false, }, Comments: column{ Name: "comments", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is COMMENTS", Nullable: true, Generated: false, AutoIncr: false, }, Avetemp: column{ Name: "avetemp", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is AVETEMP", Nullable: true, Generated: false, AutoIncr: false, }, Windspeed: column{ Name: "windspeed", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is WINDSPEED", Nullable: true, Generated: false, AutoIncr: false, }, Winddir: column{ Name: "winddir", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is WINDDIR", Nullable: true, Generated: false, AutoIncr: false, }, Raingauge: column{ Name: "raingauge", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is RAINGAUGE", Nullable: true, Generated: false, AutoIncr: false, }, Startdatetime: column{ Name: "startdatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is STARTDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, Enddatetime: column{ Name: "enddatetime", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is ENDDATETIME", Nullable: true, Generated: false, AutoIncr: false, }, InspID: column{ Name: "insp_id", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is INSP_ID", Nullable: true, Generated: false, AutoIncr: false, }, Reviewed: column{ Name: "reviewed", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWED", Nullable: true, Generated: false, AutoIncr: false, }, Reviewedby: column{ Name: "reviewedby", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDBY", Nullable: true, Generated: false, AutoIncr: false, }, Revieweddate: column{ Name: "revieweddate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is REVIEWEDDATE", Nullable: true, Generated: false, AutoIncr: false, }, Locationname: column{ Name: "locationname", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is LOCATIONNAME", Nullable: true, Generated: false, AutoIncr: false, }, Zone: column{ Name: "zone", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE", Nullable: true, Generated: false, AutoIncr: false, }, Warningoverride: column{ Name: "warningoverride", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is WARNINGOVERRIDE", Nullable: true, Generated: false, AutoIncr: false, }, Recordstatus: column{ Name: "recordstatus", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is RECORDSTATUS", Nullable: true, Generated: false, AutoIncr: false, }, Zone2: column{ Name: "zone2", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is ZONE2", Nullable: true, Generated: false, AutoIncr: false, }, Treatacres: column{ Name: "treatacres", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is TREATACRES", Nullable: true, Generated: false, AutoIncr: false, }, Tirecount: column{ Name: "tirecount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is TIRECOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Cbcount: column{ Name: "cbcount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is CBCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Containercount: column{ Name: "containercount", DBType: "smallint", Default: "NULL", Comment: "Original attribute from ArcGIS API is CONTAINERCOUNT", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, Treatmentlength: column{ Name: "treatmentlength", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is TREATMENTLENGTH", Nullable: true, Generated: false, AutoIncr: false, }, Treatmenthours: column{ Name: "treatmenthours", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is TREATMENTHOURS", Nullable: true, Generated: false, AutoIncr: false, }, Treatmentlengthunits: column{ Name: "treatmentlengthunits", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TREATMENTLENGTHUNITS", Nullable: true, Generated: false, AutoIncr: false, }, Linelocid: column{ Name: "linelocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is LINELOCID", Nullable: true, Generated: false, AutoIncr: false, }, Pointlocid: column{ Name: "pointlocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is POINTLOCID", Nullable: true, Generated: false, AutoIncr: false, }, Polygonlocid: column{ Name: "polygonlocid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is POLYGONLOCID", Nullable: true, Generated: false, AutoIncr: false, }, Srid: column{ Name: "srid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is SRID", Nullable: true, Generated: false, AutoIncr: false, }, Sdid: column{ Name: "sdid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is SDID", Nullable: true, Generated: false, AutoIncr: false, }, Barrierrouteid: column{ Name: "barrierrouteid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is BARRIERROUTEID", Nullable: true, Generated: false, AutoIncr: false, }, Ulvrouteid: column{ Name: "ulvrouteid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is ULVROUTEID", Nullable: true, Generated: false, AutoIncr: false, }, Fieldtech: column{ Name: "fieldtech", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is FIELDTECH", Nullable: true, Generated: false, AutoIncr: false, }, Ptaid: column{ Name: "ptaid", DBType: "uuid", Default: "NULL", Comment: "Original attribute from ArcGIS API is PTAID", Nullable: true, Generated: false, AutoIncr: false, }, Flowrate: column{ Name: "flowrate", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is FLOWRATE", Nullable: true, Generated: false, AutoIncr: false, }, Habitat: column{ Name: "habitat", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is HABITAT", Nullable: true, Generated: false, AutoIncr: false, }, Treathectares: column{ Name: "treathectares", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is TREATHECTARES", Nullable: true, Generated: false, AutoIncr: false, }, Invloc: column{ Name: "invloc", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is INVLOC", Nullable: true, Generated: false, AutoIncr: false, }, TempSitecond: column{ Name: "temp_sitecond", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is temp_SITECOND", Nullable: true, Generated: false, AutoIncr: false, }, Sitecond: column{ Name: "sitecond", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is SITECOND", Nullable: true, Generated: false, AutoIncr: false, }, Totalcostprodcut: column{ Name: "totalcostprodcut", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is TotalCostProdcut", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, Targetspecies: column{ Name: "targetspecies", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is TARGETSPECIES", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, H3cell: column{ Name: "h3cell", DBType: "h3index", Default: "GENERATED", Comment: "", Nullable: true, Generated: true, AutoIncr: false, }, }, Indexes: fieldseekerTreatmentIndexes{ TreatmentPkey: index{ Type: "btree", Name: "treatment_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "treatment_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerTreatmentForeignKeys{ FieldseekerTreatmentTreatmentOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerZones = Table[ fieldseekerZoneColumns, fieldseekerZoneIndexes, fieldseekerZoneForeignKeys, fieldseekerZoneUniques, fieldseekerZoneChecks, ]{ Schema: "fieldseeker", Name: "zones", Columns: fieldseekerZoneColumns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.zones_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Name: column{ Name: "name", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is NAME", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Active: column{ Name: "active", DBType: "integer", Default: "NULL", Comment: "Original attribute from ArcGIS API is ACTIVE", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, ShapeArea: column{ Name: "shape__area", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is Shape__Area", Nullable: true, Generated: false, AutoIncr: false, }, ShapeLength: column{ Name: "shape__length", DBType: "double precision", Default: "NULL", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerZoneIndexes{ ZonesPkey: index{ Type: "btree", Name: "zones_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "zones_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerZoneForeignKeys{ FieldseekerZonesZonesOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var FieldseekerZones2s = Table[ fieldseekerZones2Columns, fieldseekerZones2Indexes, fieldseekerZones2ForeignKeys, fieldseekerZones2Uniques, fieldseekerZones2Checks, ]{ Schema: "fieldseeker", Name: "zones2", Columns: fieldseekerZones2Columns{ Objectid: column{ Name: "objectid", DBType: "bigint", Default: "nextval('fieldseeker.zones2_objectid_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Name: column{ Name: "name", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is NAME", Nullable: true, Generated: false, AutoIncr: false, }, Globalid: column{ Name: "globalid", DBType: "uuid", Default: "", Comment: "Original attribute from ArcGIS API is GlobalID", Nullable: false, Generated: false, AutoIncr: false, }, CreatedUser: column{ Name: "created_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_user", Nullable: true, Generated: false, AutoIncr: false, }, CreatedDate: column{ Name: "created_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is created_date", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedUser: column{ Name: "last_edited_user", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_user", Nullable: true, Generated: false, AutoIncr: false, }, LastEditedDate: column{ Name: "last_edited_date", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is last_edited_date", Nullable: true, Generated: false, AutoIncr: false, }, Creationdate: column{ Name: "creationdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is CreationDate", Nullable: true, Generated: false, AutoIncr: false, }, Creator: column{ Name: "creator", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Creator", Nullable: true, Generated: false, AutoIncr: false, }, Editdate: column{ Name: "editdate", DBType: "timestamp without time zone", Default: "NULL", Comment: "Original attribute from ArcGIS API is EditDate", Nullable: true, Generated: false, AutoIncr: false, }, Editor: column{ Name: "editor", DBType: "character varying", Default: "NULL", Comment: "Original attribute from ArcGIS API is Editor", Nullable: true, Generated: false, AutoIncr: false, }, ShapeArea: column{ Name: "shape__area", DBType: "double precision", Default: "NULL", Comment: "Original attribute from ArcGIS API is Shape__Area", Nullable: true, Generated: false, AutoIncr: false, }, ShapeLength: column{ Name: "shape__length", DBType: "double precision", Default: "NULL", 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", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "1", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: fieldseekerZones2Indexes{ Zones2Pkey: index{ Type: "btree", Name: "zones2_pkey", Columns: []indexColumn{ { Name: "objectid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "zones2_pkey", Columns: []string{"objectid", "version"}, Comment: "", }, ForeignKeys: fieldseekerZones2ForeignKeys{ FieldseekerZones2Zones2OrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var GeographyColumns = Table[ geographyColumnColumns, geographyColumnIndexes, geographyColumnForeignKeys, geographyColumnUniques, geographyColumnChecks, ]{ Schema: "", Name: "geography_columns", Columns: geographyColumnColumns{ FTableCatalog: column{ Name: "f_table_catalog", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, FTableSchema: column{ Name: "f_table_schema", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, FTableName: column{ Name: "f_table_name", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, FGeographyColumn: column{ Name: "f_geography_column", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, CoordDimension: column{ Name: "coord_dimension", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Srid: column{ Name: "srid", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Type: column{ Name: "type", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, }, Comment: "", }
View Source
var GeometryColumns = Table[ geometryColumnColumns, geometryColumnIndexes, geometryColumnForeignKeys, geometryColumnUniques, geometryColumnChecks, ]{ Schema: "", Name: "geometry_columns", Columns: geometryColumnColumns{ FTableCatalog: column{ Name: "f_table_catalog", DBType: "character varying", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, FTableSchema: column{ Name: "f_table_schema", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, FTableName: column{ Name: "f_table_name", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, FGeometryColumn: column{ Name: "f_geometry_column", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, CoordDimension: column{ Name: "coord_dimension", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Srid: column{ Name: "srid", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Type: column{ Name: "type", DBType: "character varying", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, }, Comment: "", }
View Source
var GooseDBVersions = Table[ gooseDBVersionColumns, gooseDBVersionIndexes, gooseDBVersionForeignKeys, gooseDBVersionUniques, gooseDBVersionChecks, ]{ Schema: "", Name: "goose_db_version", Columns: gooseDBVersionColumns{ ID: column{ Name: "id", DBType: "integer", Default: "IDENTITY", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, VersionID: column{ Name: "version_id", DBType: "bigint", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, IsApplied: column{ Name: "is_applied", DBType: "boolean", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Tstamp: column{ Name: "tstamp", DBType: "timestamp without time zone", Default: "now()", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: gooseDBVersionIndexes{ GooseDBVersionPkey: index{ Type: "btree", Name: "goose_db_version_pkey", Columns: []indexColumn{ { Name: "id", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "goose_db_version_pkey", Columns: []string{"id"}, Comment: "", }, Comment: "", }
View Source
var H3Aggregations = Table[ h3AggregationColumns, h3AggregationIndexes, h3AggregationForeignKeys, h3AggregationUniques, h3AggregationChecks, ]{ Schema: "", Name: "h3_aggregation", Columns: h3AggregationColumns{ ID: column{ Name: "id", DBType: "integer", Default: "nextval('h3_aggregation_id_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Cell: column{ Name: "cell", DBType: "h3index", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Count: column{ Name: "count_", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Geometry: column{ Name: "geometry", DBType: "geometry", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Resolution: column{ Name: "resolution", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Type: column{ Name: "type_", DBType: "public.h3aggregationtype", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: h3AggregationIndexes{ H3AggregationPkey: index{ Type: "btree", Name: "h3_aggregation_pkey", Columns: []indexColumn{ { Name: "id", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false}, NullsDistinct: false, Where: "", Include: []string{}, }, H3AggregationCellOrganizationIDTypeKey: index{ Type: "btree", Name: "h3_aggregation_cell_organization_id_type__key", Columns: []indexColumn{ { Name: "cell", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "organization_id", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "type_", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "h3_aggregation_pkey", Columns: []string{"id"}, Comment: "", }, ForeignKeys: h3AggregationForeignKeys{ H3AggregationH3AggregationOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Uniques: h3AggregationUniques{ H3AggregationCellOrganizationIDTypeKey: constraint{ Name: "h3_aggregation_cell_organization_id_type__key", Columns: []string{"cell", "organization_id", "type_"}, Comment: "", }, }, Comment: "", }
View Source
var NoteAudioBreadcrumbs = Table[ noteAudioBreadcrumbColumns, noteAudioBreadcrumbIndexes, noteAudioBreadcrumbForeignKeys, noteAudioBreadcrumbUniques, noteAudioBreadcrumbChecks, ]{ Schema: "", Name: "note_audio_breadcrumb", Columns: noteAudioBreadcrumbColumns{ Cell: column{ Name: "cell", DBType: "h3index", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Created: column{ Name: "created", DBType: "timestamp without time zone", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, ManuallySelected: column{ Name: "manually_selected", DBType: "boolean", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, NoteAudioVersion: column{ Name: "note_audio_version", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, NoteAudioUUID: column{ Name: "note_audio_uuid", DBType: "uuid", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Position: column{ Name: "position", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: noteAudioBreadcrumbIndexes{ NoteAudioBreadcrumbPkey: index{ Type: "btree", Name: "note_audio_breadcrumb_pkey", Columns: []indexColumn{ { Name: "note_audio_version", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "note_audio_uuid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "\"position\"", Desc: null.FromCond(false, true), IsExpression: true, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "note_audio_breadcrumb_pkey", Columns: []string{"note_audio_version", "note_audio_uuid", "position"}, Comment: "", }, ForeignKeys: noteAudioBreadcrumbForeignKeys{ NoteAudioBreadcrumbNoteAudioBreadcrumbNoteAudioVersionNoteAudioUUIDFkey: foreignKey{ ForeignTable: "note_audio", ForeignColumns: []string{"version", "uuid"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var NoteAudioData = Table[ noteAudioDatumColumns, noteAudioDatumIndexes, noteAudioDatumForeignKeys, noteAudioDatumUniques, noteAudioDatumChecks, ]{ Schema: "", Name: "note_audio_data", Columns: noteAudioDatumColumns{ Created: column{ Name: "created", DBType: "timestamp without time zone", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, NoteAudioVersion: column{ Name: "note_audio_version", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, NoteAudioUUID: column{ Name: "note_audio_uuid", DBType: "uuid", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Type: column{ Name: "type_", DBType: "public.audiodatatype", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: noteAudioDatumIndexes{ NoteAudioDataPkey: index{ Type: "btree", Name: "note_audio_data_pkey", Columns: []indexColumn{ { Name: "note_audio_version", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "note_audio_uuid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "type_", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "note_audio_data_pkey", Columns: []string{"note_audio_version", "note_audio_uuid", "type_"}, Comment: "", }, ForeignKeys: noteAudioDatumForeignKeys{ NoteAudioDataNoteAudioDataNoteAudioVersionNoteAudioUUIDFkey: foreignKey{ ForeignTable: "note_audio", ForeignColumns: []string{"version", "uuid"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var NoteAudios = Table[ noteAudioColumns, noteAudioIndexes, noteAudioForeignKeys, noteAudioUniques, noteAudioChecks, ]{ Schema: "", Name: "note_audio", Columns: noteAudioColumns{ Created: column{ Name: "created", DBType: "timestamp without time zone", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, CreatorID: column{ Name: "creator_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Deleted: column{ Name: "deleted", DBType: "timestamp without time zone", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, DeletorID: column{ Name: "deletor_id", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Duration: column{ Name: "duration", DBType: "real", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Transcription: column{ Name: "transcription", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, TranscriptionUserEdited: column{ Name: "transcription_user_edited", DBType: "boolean", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, UUID: column{ Name: "uuid", DBType: "uuid", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: noteAudioIndexes{ NoteAudioPkey: index{ Type: "btree", Name: "note_audio_pkey", Columns: []indexColumn{ { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "uuid", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "note_audio_pkey", Columns: []string{"version", "uuid"}, Comment: "", }, ForeignKeys: noteAudioForeignKeys{ NoteAudioNoteAudioCreatorIDFkey: foreignKey{ ForeignTable: "user_", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, NoteAudioNoteAudioDeletorIDFkey: foreignKey{ ForeignTable: "user_", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, NoteAudioNoteAudioOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var NoteImageBreadcrumbs = Table[ noteImageBreadcrumbColumns, noteImageBreadcrumbIndexes, noteImageBreadcrumbForeignKeys, noteImageBreadcrumbUniques, noteImageBreadcrumbChecks, ]{ Schema: "", Name: "note_image_breadcrumb", Columns: noteImageBreadcrumbColumns{ Cell: column{ Name: "cell", DBType: "h3index", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Created: column{ Name: "created", DBType: "timestamp without time zone", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, ManuallySelected: column{ Name: "manually_selected", DBType: "boolean", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, NoteImageVersion: column{ Name: "note_image_version", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, NoteImageUUID: column{ Name: "note_image_uuid", DBType: "uuid", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Position: column{ Name: "position", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: noteImageBreadcrumbIndexes{ NoteImageBreadcrumbPkey: index{ Type: "btree", Name: "note_image_breadcrumb_pkey", Columns: []indexColumn{ { Name: "note_image_version", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "note_image_uuid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "\"position\"", Desc: null.FromCond(false, true), IsExpression: true, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "note_image_breadcrumb_pkey", Columns: []string{"note_image_version", "note_image_uuid", "position"}, Comment: "", }, ForeignKeys: noteImageBreadcrumbForeignKeys{ NoteImageBreadcrumbNoteImageBreadcrumbNoteImageVersionNoteImageUUIDFkey: foreignKey{ ForeignTable: "note_image", ForeignColumns: []string{"version", "uuid"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var NoteImageData = Table[ noteImageDatumColumns, noteImageDatumIndexes, noteImageDatumForeignKeys, noteImageDatumUniques, noteImageDatumChecks, ]{ Schema: "", Name: "note_image_data", Columns: noteImageDatumColumns{ Created: column{ Name: "created", DBType: "timestamp without time zone", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, NoteImageVersion: column{ Name: "note_image_version", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, NoteImageUUID: column{ Name: "note_image_uuid", DBType: "uuid", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Type: column{ Name: "type_", DBType: "public.audiodatatype", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: noteImageDatumIndexes{ NoteImageDataPkey: index{ Type: "btree", Name: "note_image_data_pkey", Columns: []indexColumn{ { Name: "note_image_version", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "note_image_uuid", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "type_", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "note_image_data_pkey", Columns: []string{"note_image_version", "note_image_uuid", "type_"}, Comment: "", }, ForeignKeys: noteImageDatumForeignKeys{ NoteImageDataNoteImageDataNoteImageVersionNoteImageUUIDFkey: foreignKey{ ForeignTable: "note_image", ForeignColumns: []string{"version", "uuid"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var NoteImages = Table[ noteImageColumns, noteImageIndexes, noteImageForeignKeys, noteImageUniques, noteImageChecks, ]{ Schema: "", Name: "note_image", Columns: noteImageColumns{ Created: column{ Name: "created", DBType: "timestamp without time zone", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, CreatorID: column{ Name: "creator_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Deleted: column{ Name: "deleted", DBType: "timestamp without time zone", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, DeletorID: column{ Name: "deletor_id", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Version: column{ Name: "version", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, UUID: column{ Name: "uuid", DBType: "uuid", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: noteImageIndexes{ NoteImagePkey: index{ Type: "btree", Name: "note_image_pkey", Columns: []indexColumn{ { Name: "version", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "uuid", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "note_image_pkey", Columns: []string{"version", "uuid"}, Comment: "", }, ForeignKeys: noteImageForeignKeys{ NoteImageNoteImageCreatorIDFkey: foreignKey{ ForeignTable: "user_", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, NoteImageNoteImageDeletorIDFkey: foreignKey{ ForeignTable: "user_", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, NoteImageNoteImageOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var Notifications = Table[ notificationColumns, notificationIndexes, notificationForeignKeys, notificationUniques, notificationChecks, ]{ Schema: "", Name: "notification", Columns: notificationColumns{ ID: column{ Name: "id", DBType: "integer", Default: "nextval('notification_id_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Created: column{ Name: "created", DBType: "timestamp without time zone", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Link: column{ Name: "link", DBType: "text", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Message: column{ Name: "message", DBType: "text", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Type: column{ Name: "type", DBType: "public.notificationtype", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, UserID: column{ Name: "user_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, ResolvedAt: column{ Name: "resolved_at", DBType: "timestamp without time zone", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, }, Indexes: notificationIndexes{ NotificationPkey: index{ Type: "btree", Name: "notification_pkey", Columns: []indexColumn{ { Name: "id", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false}, NullsDistinct: false, Where: "", Include: []string{}, }, UniqueUserLinkNotResolved: index{ Type: "btree", Name: "unique_user_link_not_resolved", Columns: []indexColumn{ { Name: "user_id", Desc: null.FromCond(false, true), IsExpression: false, }, { Name: "link", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false, false}, NullsDistinct: false, Where: "(resolved_at IS NULL)", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "notification_pkey", Columns: []string{"id"}, Comment: "", }, ForeignKeys: notificationForeignKeys{ NotificationNotificationUserIDFkey: foreignKey{ ForeignTable: "user_", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var OauthTokens = Table[ oauthTokenColumns, oauthTokenIndexes, oauthTokenForeignKeys, oauthTokenUniques, oauthTokenChecks, ]{ Schema: "", Name: "oauth_token", Columns: oauthTokenColumns{ ID: column{ Name: "id", DBType: "integer", Default: "nextval('oauth_token_id_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, AccessToken: column{ Name: "access_token", DBType: "text", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, AccessTokenExpires: column{ Name: "access_token_expires", DBType: "timestamp without time zone", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, RefreshToken: column{ Name: "refresh_token", DBType: "text", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Username: column{ Name: "username", DBType: "text", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, UserID: column{ Name: "user_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, ArcgisID: column{ Name: "arcgis_id", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, ArcgisLicenseTypeID: column{ Name: "arcgis_license_type_id", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, RefreshTokenExpires: column{ Name: "refresh_token_expires", DBType: "timestamp without time zone", Default: "CURRENT_TIMESTAMP", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, InvalidatedAt: column{ Name: "invalidated_at", DBType: "timestamp without time zone", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, }, Indexes: oauthTokenIndexes{ OauthTokenPkey: index{ Type: "btree", Name: "oauth_token_pkey", Columns: []indexColumn{ { Name: "id", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "oauth_token_pkey", Columns: []string{"id"}, Comment: "", }, ForeignKeys: oauthTokenForeignKeys{ OauthTokenOauthTokenUserIDFkey: foreignKey{ ForeignTable: "user_", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
View Source
var Organizations = Table[ organizationColumns, organizationIndexes, organizationForeignKeys, organizationUniques, organizationChecks, ]{ Schema: "", Name: "organization", Columns: organizationColumns{ ID: column{ Name: "id", DBType: "integer", Default: "nextval('organization_id_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Name: column{ Name: "name", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, ArcgisID: column{ Name: "arcgis_id", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, ArcgisName: column{ Name: "arcgis_name", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, FieldseekerURL: column{ Name: "fieldseeker_url", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, }, Indexes: organizationIndexes{ OrganizationPkey: index{ Type: "btree", Name: "organization_pkey", Columns: []indexColumn{ { Name: "id", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "organization_pkey", Columns: []string{"id"}, Comment: "", }, Comment: "", }
View Source
var RasterColumns = Table[ rasterColumnColumns, rasterColumnIndexes, rasterColumnForeignKeys, rasterColumnUniques, rasterColumnChecks, ]{ Schema: "", Name: "raster_columns", Columns: rasterColumnColumns{ RTableCatalog: column{ Name: "r_table_catalog", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, RTableSchema: column{ Name: "r_table_schema", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, RTableName: column{ Name: "r_table_name", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, RRasterColumn: column{ Name: "r_raster_column", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Srid: column{ Name: "srid", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, ScaleX: column{ Name: "scale_x", DBType: "double precision", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, ScaleY: column{ Name: "scale_y", DBType: "double precision", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, BlocksizeX: column{ Name: "blocksize_x", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, BlocksizeY: column{ Name: "blocksize_y", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, SameAlignment: column{ Name: "same_alignment", DBType: "boolean", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, RegularBlocking: column{ Name: "regular_blocking", DBType: "boolean", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, NumBands: column{ Name: "num_bands", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, PixelTypes: column{ Name: "pixel_types", DBType: "text[]", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, NodataValues: column{ Name: "nodata_values", DBType: "double precision[]", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, OutDB: column{ Name: "out_db", DBType: "boolean[]", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Extent: column{ Name: "extent", DBType: "geometry", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, SpatialIndex: column{ Name: "spatial_index", DBType: "boolean", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, }, Comment: "", }
View Source
var RasterOverviews = Table[ rasterOverviewColumns, rasterOverviewIndexes, rasterOverviewForeignKeys, rasterOverviewUniques, rasterOverviewChecks, ]{ Schema: "", Name: "raster_overviews", Columns: rasterOverviewColumns{ OTableCatalog: column{ Name: "o_table_catalog", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, OTableSchema: column{ Name: "o_table_schema", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, OTableName: column{ Name: "o_table_name", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, ORasterColumn: column{ Name: "o_raster_column", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, RTableCatalog: column{ Name: "r_table_catalog", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, RTableSchema: column{ Name: "r_table_schema", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, RTableName: column{ Name: "r_table_name", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, RRasterColumn: column{ Name: "r_raster_column", DBType: "name", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, OverviewFactor: column{ Name: "overview_factor", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, }, Comment: "", }
View Source
var Sessions = Table[ sessionColumns, sessionIndexes, sessionForeignKeys, sessionUniques, sessionChecks, ]{ Schema: "", Name: "sessions", Columns: sessionColumns{ Token: column{ Name: "token", DBType: "text", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Data: column{ Name: "data", DBType: "bytea", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Expiry: column{ Name: "expiry", DBType: "timestamp with time zone", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: sessionIndexes{ SessionsPkey: index{ Type: "btree", Name: "sessions_pkey", Columns: []indexColumn{ { Name: "token", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false}, NullsDistinct: false, Where: "", Include: []string{}, }, SessionsExpiryIdx: index{ Type: "btree", Name: "sessions_expiry_idx", Columns: []indexColumn{ { Name: "expiry", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: false, Comment: "", NullsFirst: []bool{false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "sessions_pkey", Columns: []string{"token"}, Comment: "", }, Comment: "", }
View Source
var SpatialRefSys = Table[ spatialRefSyColumns, spatialRefSyIndexes, spatialRefSyForeignKeys, spatialRefSyUniques, spatialRefSyChecks, ]{ Schema: "", Name: "spatial_ref_sys", Columns: spatialRefSyColumns{ Srid: column{ Name: "srid", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, AuthName: column{ Name: "auth_name", DBType: "character varying", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, AuthSrid: column{ Name: "auth_srid", DBType: "integer", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Srtext: column{ Name: "srtext", DBType: "character varying", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, Proj4text: column{ Name: "proj4text", DBType: "character varying", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, }, Indexes: spatialRefSyIndexes{ SpatialRefSysPkey: index{ Type: "btree", Name: "spatial_ref_sys_pkey", Columns: []indexColumn{ { Name: "srid", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "spatial_ref_sys_pkey", Columns: []string{"srid"}, Comment: "", }, Checks: spatialRefSyChecks{ SpatialRefSysSridCheck: check{ Expression: "((srid > 0) AND (srid <= 998999))", // contains filtered or unexported fields }, }, Comment: "", }
View Source
var Users = Table[ userColumns, userIndexes, userForeignKeys, userUniques, userChecks, ]{ Schema: "", Name: "user_", Columns: userColumns{ ID: column{ Name: "id", DBType: "integer", Default: "nextval('user__id_seq'::regclass)", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, ArcgisAccessToken: column{ Name: "arcgis_access_token", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, ArcgisLicense: column{ Name: "arcgis_license", DBType: "public.arcgislicensetype", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, ArcgisRefreshToken: column{ Name: "arcgis_refresh_token", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, ArcgisRefreshTokenExpires: column{ Name: "arcgis_refresh_token_expires", DBType: "timestamp without time zone", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, ArcgisRole: column{ Name: "arcgis_role", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, DisplayName: column{ Name: "display_name", DBType: "character varying", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Email: column{ Name: "email", DBType: "text", Default: "NULL", Comment: "", Nullable: true, Generated: false, AutoIncr: false, }, OrganizationID: column{ Name: "organization_id", DBType: "integer", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, Username: column{ Name: "username", DBType: "text", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, PasswordHashType: column{ Name: "password_hash_type", DBType: "public.hashtype", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, PasswordHash: column{ Name: "password_hash", DBType: "text", Default: "", Comment: "", Nullable: false, Generated: false, AutoIncr: false, }, }, Indexes: userIndexes{ UserPkey: index{ Type: "btree", Name: "user__pkey", Columns: []indexColumn{ { Name: "id", Desc: null.FromCond(false, true), IsExpression: false, }, }, Unique: true, Comment: "", NullsFirst: []bool{false}, NullsDistinct: false, Where: "", Include: []string{}, }, }, PrimaryKey: &constraint{ Name: "user__pkey", Columns: []string{"id"}, Comment: "", }, ForeignKeys: userForeignKeys{ UserUserOrganizationIDFkey: foreignKey{ ForeignTable: "organization", ForeignColumns: []string{"id"}, // contains filtered or unexported fields }, }, Comment: "", }
Functions ¶
This section is empty.
Types ¶
Source Files
¶
- bob_types.bob.go
- fieldseeker.containerrelate.bob.go
- fieldseeker.fieldscoutinglog.bob.go
- fieldseeker.habitatrelate.bob.go
- fieldseeker.inspectionsample.bob.go
- fieldseeker.inspectionsampledetail.bob.go
- fieldseeker.linelocation.bob.go
- fieldseeker.locationtracking.bob.go
- fieldseeker.mosquitoinspection.bob.go
- fieldseeker.pointlocation.bob.go
- fieldseeker.polygonlocation.bob.go
- fieldseeker.pool.bob.go
- fieldseeker.pooldetail.bob.go
- fieldseeker.proposedtreatmentarea.bob.go
- fieldseeker.qamosquitoinspection.bob.go
- fieldseeker.rodentlocation.bob.go
- fieldseeker.samplecollection.bob.go
- fieldseeker.samplelocation.bob.go
- fieldseeker.servicerequest.bob.go
- fieldseeker.speciesabundance.bob.go
- fieldseeker.stormdrain.bob.go
- fieldseeker.timecard.bob.go
- fieldseeker.trapdata.bob.go
- fieldseeker.traplocation.bob.go
- fieldseeker.treatment.bob.go
- fieldseeker.treatmentarea.bob.go
- fieldseeker.zones.bob.go
- fieldseeker.zones2.bob.go
- fieldseeker_sync.bob.go
- geography_columns.bob.go
- geometry_columns.bob.go
- goose_db_version.bob.go
- h3_aggregation.bob.go
- note_audio.bob.go
- note_audio_breadcrumb.bob.go
- note_audio_data.bob.go
- note_image.bob.go
- note_image_breadcrumb.bob.go
- note_image_data.bob.go
- notification.bob.go
- oauth_token.bob.go
- organization.bob.go
- raster_columns.bob.go
- raster_overviews.bob.go
- sessions.bob.go
- spatial_ref_sys.bob.go
- user_.bob.go
Click to show internal directories.
Click to hide internal directories.