nidus-sync/dbinfo/fs_containerrelate.bob.go
Eli Ribble e48abb09c0
Go to h3 v4, Add initial h3 aggregation work
This calculates the summary information of data in h3 nodes and puts it
in the database for fast lookup.
2025-11-13 23:49:12 +00:00

277 lines
6 KiB
Go

// Code generated by BobGen psql v0.41.1. 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 FSContainerrelates = Table[
fsContainerrelateColumns,
fsContainerrelateIndexes,
fsContainerrelateForeignKeys,
fsContainerrelateUniques,
fsContainerrelateChecks,
]{
Schema: "",
Name: "fs_containerrelate",
Columns: fsContainerrelateColumns{
OrganizationID: column{
Name: "organization_id",
DBType: "integer",
Default: "",
Comment: "",
Nullable: false,
Generated: false,
AutoIncr: false,
},
Containertype: column{
Name: "containertype",
DBType: "text",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
Creationdate: column{
Name: "creationdate",
DBType: "bigint",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
Creator: column{
Name: "creator",
DBType: "text",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
Editdate: column{
Name: "editdate",
DBType: "bigint",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
Editor: column{
Name: "editor",
DBType: "text",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
Globalid: column{
Name: "globalid",
DBType: "text",
Default: "",
Comment: "",
Nullable: false,
Generated: false,
AutoIncr: false,
},
Inspsampleid: column{
Name: "inspsampleid",
DBType: "text",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
Mosquitoinspid: column{
Name: "mosquitoinspid",
DBType: "text",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
Objectid: column{
Name: "objectid",
DBType: "integer",
Default: "",
Comment: "",
Nullable: false,
Generated: false,
AutoIncr: false,
},
Treatmentid: column{
Name: "treatmentid",
DBType: "text",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
CreatedDate: column{
Name: "created_date",
DBType: "bigint",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
CreatedUser: column{
Name: "created_user",
DBType: "text",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
GeometryX: column{
Name: "geometry_x",
DBType: "double precision",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
GeometryY: column{
Name: "geometry_y",
DBType: "double precision",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
LastEditedDate: column{
Name: "last_edited_date",
DBType: "bigint",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
LastEditedUser: column{
Name: "last_edited_user",
DBType: "text",
Default: "NULL",
Comment: "",
Nullable: true,
Generated: false,
AutoIncr: false,
},
Updated: column{
Name: "updated",
DBType: "timestamp without time zone",
Default: "CURRENT_TIMESTAMP",
Comment: "",
Nullable: false,
Generated: false,
AutoIncr: false,
},
},
Indexes: fsContainerrelateIndexes{
FSContainerrelatePkey: index{
Type: "btree",
Name: "fs_containerrelate_pkey",
Columns: []indexColumn{
{
Name: "objectid",
Desc: null.FromCond(false, true),
IsExpression: false,
},
},
Unique: true,
Comment: "",
NullsFirst: []bool{false},
NullsDistinct: false,
Where: "",
Include: []string{},
},
},
PrimaryKey: &constraint{
Name: "fs_containerrelate_pkey",
Columns: []string{"objectid"},
Comment: "",
},
ForeignKeys: fsContainerrelateForeignKeys{
FSContainerrelateFSContainerrelateOrganizationIDFkey: foreignKey{
constraint: constraint{
Name: "fs_containerrelate.fs_containerrelate_organization_id_fkey",
Columns: []string{"organization_id"},
Comment: "",
},
ForeignTable: "organization",
ForeignColumns: []string{"id"},
},
},
Comment: "",
}
type fsContainerrelateColumns struct {
OrganizationID column
Containertype column
Creationdate column
Creator column
Editdate column
Editor column
Globalid column
Inspsampleid column
Mosquitoinspid column
Objectid column
Treatmentid column
CreatedDate column
CreatedUser column
GeometryX column
GeometryY column
LastEditedDate column
LastEditedUser column
Updated column
}
func (c fsContainerrelateColumns) AsSlice() []column {
return []column{
c.OrganizationID, c.Containertype, c.Creationdate, c.Creator, c.Editdate, c.Editor, c.Globalid, c.Inspsampleid, c.Mosquitoinspid, c.Objectid, c.Treatmentid, c.CreatedDate, c.CreatedUser, c.GeometryX, c.GeometryY, c.LastEditedDate, c.LastEditedUser, c.Updated,
}
}
type fsContainerrelateIndexes struct {
FSContainerrelatePkey index
}
func (i fsContainerrelateIndexes) AsSlice() []index {
return []index{
i.FSContainerrelatePkey,
}
}
type fsContainerrelateForeignKeys struct {
FSContainerrelateFSContainerrelateOrganizationIDFkey foreignKey
}
func (f fsContainerrelateForeignKeys) AsSlice() []foreignKey {
return []foreignKey{
f.FSContainerrelateFSContainerrelateOrganizationIDFkey,
}
}
type fsContainerrelateUniques struct{}
func (u fsContainerrelateUniques) AsSlice() []constraint {
return []constraint{}
}
type fsContainerrelateChecks struct{}
func (c fsContainerrelateChecks) AsSlice() []check {
return []check{}
}