nidus-sync/db/dbinfo/fieldseeker.proposedtreatmentarea.bob.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{}
}