dbinfo

package
v0.0.3 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Apr 3, 2026 License: Apache-2.0 Imports: 1 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source
var DeviceLocations = Table[
	deviceLocationColumns,
	deviceLocationIndexes,
	deviceLocationForeignKeys,
	deviceLocationUniques,
	deviceLocationChecks,
]{
	Schema: "",
	Name:   "device_locations",
	Columns: deviceLocationColumns{
		Time: column{
			Name:      "time",
			DBType:    "timestamp with time zone",
			Default:   "",
			Comment:   "",
			Nullable:  false,
			Generated: false,
			AutoIncr:  false,
		},
		DeviceID: column{
			Name:      "device_id",
			DBType:    "character varying",
			Default:   "",
			Comment:   "",
			Nullable:  false,
			Generated: false,
			AutoIncr:  false,
		},
		SpaceSlug: column{
			Name:      "space_slug",
			DBType:    "character varying",
			Default:   "",
			Comment:   "",
			Nullable:  false,
			Generated: false,
			AutoIncr:  false,
		},
		Latitude: column{
			Name:      "latitude",
			DBType:    "double precision",
			Default:   "",
			Comment:   "",
			Nullable:  false,
			Generated: false,
			AutoIncr:  false,
		},
		Longitude: column{
			Name:      "longitude",
			DBType:    "double precision",
			Default:   "",
			Comment:   "",
			Nullable:  false,
			Generated: false,
			AutoIncr:  false,
		},
		Accuracy: column{
			Name:      "accuracy",
			DBType:    "double precision",
			Default:   "",
			Comment:   "",
			Nullable:  false,
			Generated: false,
			AutoIncr:  false,
		},
	},
	Indexes: deviceLocationIndexes{
		DeviceLocationsPK: index{
			Type: "btree",
			Name: "device_locations_pk",
			Columns: []indexColumn{
				{
					Name:         "\"time\"",
					Desc:         null.FromCond(false, true),
					IsExpression: true,
				},
				{
					Name:         "device_id",
					Desc:         null.FromCond(false, true),
					IsExpression: false,
				},
			},
			Unique:        true,
			Comment:       "",
			NullsFirst:    []bool{false, false},
			NullsDistinct: false,
			Where:         "",
			Include:       []string{},
		},
		DeviceLocationsTimeIdx: index{
			Type: "btree",
			Name: "device_locations_time_idx",
			Columns: []indexColumn{
				{
					Name:         "\"time\"",
					Desc:         null.FromCond(true, true),
					IsExpression: true,
				},
			},
			Unique:        false,
			Comment:       "",
			NullsFirst:    []bool{true},
			NullsDistinct: false,
			Where:         "",
			Include:       []string{},
		},
		IdxDeviceLocationsOrgDeviceTime: index{
			Type: "btree",
			Name: "idx_device_locations_org_device_time",
			Columns: []indexColumn{
				{
					Name:         "space_slug",
					Desc:         null.FromCond(false, true),
					IsExpression: false,
				},
				{
					Name:         "device_id",
					Desc:         null.FromCond(false, true),
					IsExpression: false,
				},
				{
					Name:         "\"time\"",
					Desc:         null.FromCond(true, true),
					IsExpression: true,
				},
			},
			Unique:        false,
			Comment:       "",
			NullsFirst:    []bool{false, false, true},
			NullsDistinct: false,
			Where:         "",
			Include:       []string{},
		},
	},
	PrimaryKey: &constraint{
		Name:    "device_locations_pk",
		Columns: []string{"time", "device_id"},
		Comment: "",
	},

	Comment: "",
}
View Source
var SchemaMigrations = Table[
	schemaMigrationColumns,
	schemaMigrationIndexes,
	schemaMigrationForeignKeys,
	schemaMigrationUniques,
	schemaMigrationChecks,
]{
	Schema: "",
	Name:   "schema_migrations",
	Columns: schemaMigrationColumns{
		Version: column{
			Name:      "version",
			DBType:    "character varying",
			Default:   "",
			Comment:   "",
			Nullable:  false,
			Generated: false,
			AutoIncr:  false,
		},
	},
	Indexes: schemaMigrationIndexes{
		SchemaMigrationsPkey: index{
			Type: "btree",
			Name: "schema_migrations_pkey",
			Columns: []indexColumn{
				{
					Name:         "version",
					Desc:         null.FromCond(false, true),
					IsExpression: false,
				},
			},
			Unique:        true,
			Comment:       "",
			NullsFirst:    []bool{false},
			NullsDistinct: false,
			Where:         "",
			Include:       []string{},
		},
	},
	PrimaryKey: &constraint{
		Name:    "schema_migrations_pkey",
		Columns: []string{"version"},
		Comment: "",
	},

	Comment: "",
}

Functions

This section is empty.

Types

type Table

type Table[Cols columns, Idxs indexes, FKs foreignKeys, U uniques, C checks] struct {
	Schema      string
	Name        string
	Columns     Cols
	Indexes     Idxs
	PrimaryKey  *constraint
	ForeignKeys FKs
	Uniques     U
	Checks      C
	Comment     string
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL