427 lines
10 KiB
Go
427 lines
10 KiB
Go
// Code generated by BobGen psql v0.0.3-0.20251202003046-49148fc66a73+dirty. DO NOT EDIT.
|
|
// This file is meant to be re-generated in place and/or deleted at any time.
|
|
|
|
package dbinfo
|
|
|
|
import "github.com/aarondl/opt/null"
|
|
|
|
var FieldseekerProposedtreatmentareas = Table[
|
|
fieldseekerProposedtreatmentareaColumns,
|
|
fieldseekerProposedtreatmentareaIndexes,
|
|
fieldseekerProposedtreatmentareaForeignKeys,
|
|
fieldseekerProposedtreatmentareaUniques,
|
|
fieldseekerProposedtreatmentareaChecks,
|
|
]{
|
|
Schema: "fieldseeker",
|
|
Name: "proposedtreatmentarea",
|
|
Columns: fieldseekerProposedtreatmentareaColumns{
|
|
Objectid: column{
|
|
Name: "objectid",
|
|
DBType: "bigint",
|
|
Default: "nextval('fieldseeker.proposedtreatmentarea_objectid_seq'::regclass)",
|
|
Comment: "",
|
|
Nullable: false,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Method: column{
|
|
Name: "method",
|
|
DBType: "fieldseeker.proposedtreatmentarea_mosquitotreatmentmethod_enum",
|
|
Default: "NULL",
|
|
Comment: "Method",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Comments: column{
|
|
Name: "comments",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Comments",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Zone: column{
|
|
Name: "zone",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Zone",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Reviewed: column{
|
|
Name: "reviewed",
|
|
DBType: "fieldseeker.proposedtreatmentarea_notinuit_f_enum",
|
|
Default: "NULL",
|
|
Comment: "Reviewed",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Reviewedby: column{
|
|
Name: "reviewedby",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Reviewed By",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Revieweddate: column{
|
|
Name: "revieweddate",
|
|
DBType: "timestamp without time zone",
|
|
Default: "NULL",
|
|
Comment: "Reviewed Date",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Zone2: column{
|
|
Name: "zone2",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Zone2",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Completeddate: column{
|
|
Name: "completeddate",
|
|
DBType: "timestamp without time zone",
|
|
Default: "NULL",
|
|
Comment: "Completed Date",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Completedby: column{
|
|
Name: "completedby",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Completed By",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Completed: column{
|
|
Name: "completed",
|
|
DBType: "fieldseeker.proposedtreatmentarea_notinuit_f_enum",
|
|
Default: "NULL",
|
|
Comment: "Completed",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Issprayroute: column{
|
|
Name: "issprayroute",
|
|
DBType: "fieldseeker.proposedtreatmentarea_notinuit_f_enum",
|
|
Default: "NULL",
|
|
Comment: "Is Spray Route",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Name: column{
|
|
Name: "name",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Name",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Acres: column{
|
|
Name: "acres",
|
|
DBType: "double precision",
|
|
Default: "NULL",
|
|
Comment: "Acres",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Globalid: column{
|
|
Name: "globalid",
|
|
DBType: "uuid",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Exported: column{
|
|
Name: "exported",
|
|
DBType: "fieldseeker.proposedtreatmentarea_notinuit_f_enum",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Targetproduct: column{
|
|
Name: "targetproduct",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Target Product",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Targetapprate: column{
|
|
Name: "targetapprate",
|
|
DBType: "double precision",
|
|
Default: "NULL",
|
|
Comment: "Target App Rate",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Hectares: column{
|
|
Name: "hectares",
|
|
DBType: "double precision",
|
|
Default: "NULL",
|
|
Comment: "Hectares",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Lasttreatactivity: column{
|
|
Name: "lasttreatactivity",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Last Treatment Activity",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Lasttreatdate: column{
|
|
Name: "lasttreatdate",
|
|
DBType: "timestamp without time zone",
|
|
Default: "NULL",
|
|
Comment: "Last Treatment Date",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Lasttreatproduct: column{
|
|
Name: "lasttreatproduct",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Last Treatment Product",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Lasttreatqty: column{
|
|
Name: "lasttreatqty",
|
|
DBType: "double precision",
|
|
Default: "NULL",
|
|
Comment: "Last Treatment Quantity",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Lasttreatqtyunit: column{
|
|
Name: "lasttreatqtyunit",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Last Treatment Quantity Unit",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Priority: column{
|
|
Name: "priority",
|
|
DBType: "fieldseeker.proposedtreatmentarea_locationpriority_enum",
|
|
Default: "NULL",
|
|
Comment: "Priority",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Duedate: column{
|
|
Name: "duedate",
|
|
DBType: "timestamp without time zone",
|
|
Default: "NULL",
|
|
Comment: "Due Date",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Creationdate: column{
|
|
Name: "creationdate",
|
|
DBType: "timestamp without time zone",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Creator: column{
|
|
Name: "creator",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Editdate: column{
|
|
Name: "editdate",
|
|
DBType: "timestamp without time zone",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Editor: column{
|
|
Name: "editor",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Targetspecies: column{
|
|
Name: "targetspecies",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Target Species",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
ShapeArea: column{
|
|
Name: "shape__area",
|
|
DBType: "double precision",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
ShapeLength: column{
|
|
Name: "shape__length",
|
|
DBType: "double precision",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Version: column{
|
|
Name: "version",
|
|
DBType: "integer",
|
|
Default: "1",
|
|
Comment: "Tracks version changes to the row. Increases when data is modified.",
|
|
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: "",
|
|
},
|
|
|
|
Comment: "",
|
|
}
|
|
|
|
type fieldseekerProposedtreatmentareaColumns struct {
|
|
Objectid column
|
|
Method column
|
|
Comments column
|
|
Zone column
|
|
Reviewed column
|
|
Reviewedby column
|
|
Revieweddate column
|
|
Zone2 column
|
|
Completeddate column
|
|
Completedby column
|
|
Completed column
|
|
Issprayroute column
|
|
Name column
|
|
Acres column
|
|
Globalid column
|
|
Exported column
|
|
Targetproduct column
|
|
Targetapprate column
|
|
Hectares column
|
|
Lasttreatactivity column
|
|
Lasttreatdate column
|
|
Lasttreatproduct column
|
|
Lasttreatqty column
|
|
Lasttreatqtyunit column
|
|
Priority column
|
|
Duedate column
|
|
Creationdate column
|
|
Creator column
|
|
Editdate column
|
|
Editor column
|
|
Targetspecies column
|
|
ShapeArea column
|
|
ShapeLength column
|
|
Version column
|
|
}
|
|
|
|
func (c fieldseekerProposedtreatmentareaColumns) AsSlice() []column {
|
|
return []column{
|
|
c.Objectid, c.Method, c.Comments, c.Zone, c.Reviewed, c.Reviewedby, c.Revieweddate, c.Zone2, c.Completeddate, c.Completedby, c.Completed, c.Issprayroute, c.Name, c.Acres, c.Globalid, c.Exported, c.Targetproduct, c.Targetapprate, c.Hectares, c.Lasttreatactivity, c.Lasttreatdate, c.Lasttreatproduct, c.Lasttreatqty, c.Lasttreatqtyunit, c.Priority, c.Duedate, c.Creationdate, c.Creator, c.Editdate, c.Editor, c.Targetspecies, c.ShapeArea, c.ShapeLength, c.Version,
|
|
}
|
|
}
|
|
|
|
type fieldseekerProposedtreatmentareaIndexes struct {
|
|
ProposedtreatmentareaPkey index
|
|
}
|
|
|
|
func (i fieldseekerProposedtreatmentareaIndexes) AsSlice() []index {
|
|
return []index{
|
|
i.ProposedtreatmentareaPkey,
|
|
}
|
|
}
|
|
|
|
type fieldseekerProposedtreatmentareaForeignKeys struct{}
|
|
|
|
func (f fieldseekerProposedtreatmentareaForeignKeys) AsSlice() []foreignKey {
|
|
return []foreignKey{}
|
|
}
|
|
|
|
type fieldseekerProposedtreatmentareaUniques struct{}
|
|
|
|
func (u fieldseekerProposedtreatmentareaUniques) AsSlice() []constraint {
|
|
return []constraint{}
|
|
}
|
|
|
|
type fieldseekerProposedtreatmentareaChecks struct{}
|
|
|
|
func (c fieldseekerProposedtreatmentareaChecks) AsSlice() []check {
|
|
return []check{}
|
|
}
|