397 lines
9.8 KiB
Go
397 lines
9.8 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 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: "Location Name",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Zone: column{
|
|
Name: "zone",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Zone2: column{
|
|
Name: "zone2",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Habitat: column{
|
|
Name: "habitat",
|
|
DBType: "fieldseeker.rodentlocation_rodentlocationhabitat_enum",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Priority: column{
|
|
Name: "priority",
|
|
DBType: "fieldseeker.rodentlocation_locationpriority_1_enum",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Usetype: column{
|
|
Name: "usetype",
|
|
DBType: "fieldseeker.rodentlocation_locationusetype_1_enum",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Active: column{
|
|
Name: "active",
|
|
DBType: "fieldseeker.rodentlocation_notinuit_f_1_enum",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Description: column{
|
|
Name: "description",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Accessdesc: column{
|
|
Name: "accessdesc",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Comments: column{
|
|
Name: "comments",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Symbology: column{
|
|
Name: "symbology",
|
|
DBType: "fieldseeker.rodentlocation_rodentlocation_symbology_enum",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Externalid: column{
|
|
Name: "externalid",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "External ID",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Nextactiondatescheduled: column{
|
|
Name: "nextactiondatescheduled",
|
|
DBType: "timestamp without time zone",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Locationnumber: column{
|
|
Name: "locationnumber",
|
|
DBType: "integer",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Lastinspectdate: column{
|
|
Name: "lastinspectdate",
|
|
DBType: "timestamp without time zone",
|
|
Default: "NULL",
|
|
Comment: "Last Inspection Date",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Lastinspectspecies: column{
|
|
Name: "lastinspectspecies",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Last Inspection Species",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Lastinspectaction: column{
|
|
Name: "lastinspectaction",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Last Inspection Action",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Lastinspectconditions: column{
|
|
Name: "lastinspectconditions",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Last Inspection Conditions",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Lastinspectrodentevidence: column{
|
|
Name: "lastinspectrodentevidence",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Last Inspection Rodent Evidence",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
Globalid: column{
|
|
Name: "globalid",
|
|
DBType: "uuid",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
CreatedUser: column{
|
|
Name: "created_user",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
CreatedDate: column{
|
|
Name: "created_date",
|
|
DBType: "timestamp without time zone",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
LastEditedUser: column{
|
|
Name: "last_edited_user",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
Nullable: true,
|
|
Generated: false,
|
|
AutoIncr: false,
|
|
},
|
|
LastEditedDate: column{
|
|
Name: "last_edited_date",
|
|
DBType: "timestamp without time zone",
|
|
Default: "NULL",
|
|
Comment: "",
|
|
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,
|
|
},
|
|
Jurisdiction: column{
|
|
Name: "jurisdiction",
|
|
DBType: "character varying",
|
|
Default: "NULL",
|
|
Comment: "Jurisdiction",
|
|
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: 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: "",
|
|
},
|
|
|
|
Comment: "",
|
|
}
|
|
|
|
type fieldseekerRodentlocationColumns struct {
|
|
Objectid column
|
|
Locationname column
|
|
Zone column
|
|
Zone2 column
|
|
Habitat column
|
|
Priority column
|
|
Usetype column
|
|
Active column
|
|
Description column
|
|
Accessdesc column
|
|
Comments column
|
|
Symbology column
|
|
Externalid column
|
|
Nextactiondatescheduled column
|
|
Locationnumber column
|
|
Lastinspectdate column
|
|
Lastinspectspecies column
|
|
Lastinspectaction column
|
|
Lastinspectconditions column
|
|
Lastinspectrodentevidence column
|
|
Globalid column
|
|
CreatedUser column
|
|
CreatedDate column
|
|
LastEditedUser column
|
|
LastEditedDate column
|
|
Creationdate column
|
|
Creator column
|
|
Editdate column
|
|
Editor column
|
|
Jurisdiction column
|
|
Version column
|
|
}
|
|
|
|
func (c fieldseekerRodentlocationColumns) AsSlice() []column {
|
|
return []column{
|
|
c.Objectid, c.Locationname, c.Zone, c.Zone2, c.Habitat, c.Priority, c.Usetype, c.Active, c.Description, c.Accessdesc, c.Comments, c.Symbology, c.Externalid, c.Nextactiondatescheduled, c.Locationnumber, c.Lastinspectdate, c.Lastinspectspecies, c.Lastinspectaction, c.Lastinspectconditions, c.Lastinspectrodentevidence, c.Globalid, c.CreatedUser, c.CreatedDate, c.LastEditedUser, c.LastEditedDate, c.Creationdate, c.Creator, c.Editdate, c.Editor, c.Jurisdiction, c.Version,
|
|
}
|
|
}
|
|
|
|
type fieldseekerRodentlocationIndexes struct {
|
|
RodentlocationPkey index
|
|
}
|
|
|
|
func (i fieldseekerRodentlocationIndexes) AsSlice() []index {
|
|
return []index{
|
|
i.RodentlocationPkey,
|
|
}
|
|
}
|
|
|
|
type fieldseekerRodentlocationForeignKeys struct{}
|
|
|
|
func (f fieldseekerRodentlocationForeignKeys) AsSlice() []foreignKey {
|
|
return []foreignKey{}
|
|
}
|
|
|
|
type fieldseekerRodentlocationUniques struct{}
|
|
|
|
func (u fieldseekerRodentlocationUniques) AsSlice() []constraint {
|
|
return []constraint{}
|
|
}
|
|
|
|
type fieldseekerRodentlocationChecks struct{}
|
|
|
|
func (c fieldseekerRodentlocationChecks) AsSlice() []check {
|
|
return []check{}
|
|
}
|