db

Documentation

Index

• type TestAddress
  • func (TestAddress) Enum() map[string][]string
  • func (TestAddress) Index() map[string]string
  • func (TestAddress) UniqueKey() []string
• type TestAdminUser
  • func (TestAdminUser) Index() map[string]string
  • func (TestAdminUser) UniqueKey() []string
• type TestUser
  • func (TestUser) Enum() map[string][]string
  • func (TestUser) Index() map[string]string
  • func (TestUser) UniqueKey() []string

Types

type TestAddress

type TestAddress struct {
	AddressID int       `json:"address_id,omitempty" sql:"address_id,type:serial PRIMARY KEY"`
	City      string    `json:"city" sql:"city,type:varchar(25) UNIQUE"`
	Status    string    `json:"status,omitempty" sql:"status,type:address_status"`
	CreatedBy int       `json:"created_by" sql:"created_by,type:int NOT NULL UNIQUE REFERENCES test_user(user_id)"`
	CreatedAt time.Time `json:"-" sql:"created_at,type:time NOT NULL DEFAULT NOW()"`
	UpdatedAt time.Time `json:"-" sql:"updated_at,type:timetz NOT NULL DEFAULT NOW()"`
	// contains filtered or unexported fields
}

TestAddress Table structure as in DB

func (TestAddress) Enum

func (TestAddress) Enum() map[string][]string

Enum of the table.

func (TestAddress) Index

func (TestAddress) Index() map[string]string

Index of the table. For composite index use , Default index type is btree. For gin index use gin

func (TestAddress) UniqueKey

func (TestAddress) UniqueKey() []string

UniqueKey of the table. This is for composite unique keys

type TestAdminUser

type TestAdminUser struct {
	AdminUserID int       `json:"admin_user_id" sql:"admin_user_id,type:serial PRIMARY KEY"`
	FkUserID    int       `json:"user_id" sql:"fk_user_id,type:int NOT NULL REFERENCES test_user(user_id) ON DELETE RESTRICT ON UPDATE CASCADE"`
	CreatedBy   int       `json:"-" sql:"created_by,type:int NOT NULL REFERENCES test_user(user_id) ON DELETE RESTRICT ON UPDATE CASCADE"`
	CreatedAt   time.Time `json:"-" sql:"created_at,type:timestamp NOT NULL DEFAULT NOW()"`
	UpdatedAt   time.Time `json:"-" sql:"updated_at,type:timestamp NOT NULL DEFAULT NOW()"`
	MyAdminID   int       `json:"-" sql:"mysql_admin_id,type:int NULL UNIQUE"`
	// contains filtered or unexported fields
}

TestAdminUser Table structure as in DB

func (TestAdminUser) Index

func (TestAdminUser) Index() map[string]string

Index of the table. For composite index use , Default index type is btree. For gin index use gin value

func (TestAdminUser) UniqueKey

func (TestAdminUser) UniqueKey() []string

UniqueKey of the table. This is for composite unique keys

type TestUser

type TestUser struct {
	UserID           int                    `json:"user_id" sql:"user_id,type:serial PRIMARY KEY"`
	Username         string                 `json:"username" sql:"username,type:varchar(255)"`
	Password         string                 `json:"-" sql:"password,type:varchar(255) NULL"`
	PassSalt         string                 `json:"-" sql:"pass_salt,type:varchar(255) NULL"`
	Email            string                 `json:"email" sql:"email,type:varchar(255) UNIQUE"`
	Name             string                 `json:"name" sql:"name,type:varchar(255)"`
	AltContactNo     string                 `json:"alt_contact_no" default:"true" sql:"alt_contact_no,type:varchar(20)"`
	AltPhoneCode     string                 `json:"alt_phonecode" default:"true" sql:"alt_phonecode,type:varchar(20)"`
	Landline         string                 `json:"landline" default:"null" sql:"landline,type:text NULL DEFAULT NULL"`
	Department       string                 `json:"department" default:"null" sql:"department,type:varchar(100)"`
	Designation      string                 `json:"designation" default:"null" sql:"designation,type:varchar(100)"`
	EmailVerified    string                 `json:"email_verified,omitempty" sql:"email_verified,type:user_yesno_type NOT NULL DEFAULT 'no'"`
	PhoneVerified    string                 `json:"phone_verified,omitempty" sql:"phone_verified,type:user_yesno_type NOT NULL DEFAULT 'no'"`
	WhatsappVerified string                 `json:"whatsapp_verified,omitempty" sql:"whatsapp_verified,type:user_yesno_type NOT NULL DEFAULT 'no'"`
	Attribute        map[string]interface{} `json:"attribute,omitempty" sql:"attribute,type:jsonb NOT NULL DEFAULT '{}'::jsonb"`
	Status           string                 `json:"status" sql:"status,type:test_user_status_type DEFAULT 'notverified'"`
	LastLogin        time.Time              `json:"last_login" sql:"last_login,type:timestamp"`
	CreatedBy        int                    `` /* 140-byte string literal not displayed */
	CreatedAt        time.Time              `json:"-" sql:"created_at,type:timestamp NOT NULL DEFAULT NOW()"`
	UpdatedAt        time.Time              `json:"-" sql:"updated_at,type:timestamp NOT NULL DEFAULT NOW()"`
	// contains filtered or unexported fields
}

TestUser Table structure as in DB

func (TestUser) Enum

func (TestUser) Enum() map[string][]string

Enum of the table.

func (TestUser) Index

func (TestUser) Index() map[string]string

Index of the table. For composite index use , Default index type is btree. For gin index use gin value

func (TestUser) UniqueKey

func (TestUser) UniqueKey() []string

UniqueKey of the table. This is for composite unique keys