database

type Column struct {
	ColumnName    string `db:"COLUMN_NAME"`
	IsNullable    string `db:"IS_NULLABLE"`
	ColumnDefault string `db:"COLUMN_DEFAULT"`
	DataType      string `db:"DATA_TYPE"`
}

type Database struct {
	Name     string `json:"name,omitempty"`
	Hostname string `json:"hostname,omitempty"`
	Port     int    `json:"port,omitempty"`
	Driver   string `json:"driver,omitempty"`
	Database string `json:"database,omitempty"`
	Username string `json:"username,omitempty"`
	Password string `json:"password,omitempty"`
	URI      string `json:"uri,omitempty"`
	*sqlx.DB
}

type Index struct {
	Schema     string `db:"schemaname"`
	Table      string `db:"tablename"`
	Name       string `db:"indexname"`
	Columns    string `db:"indexcolumns"`
	Definition string `db:"indexdef"`
}

type IndexList struct {
	Name string `db:"indexname"`
}

type PKey struct {
	PKey string `db:"CL"`
}

type Routine struct {
	Name             string `db:"ROUTINE_NAME"`
	Type             string `db:"ROUTINE_TYPE"`
	Definition       string `db:"ROUTINE_DEFINITION"`
	DataType         string `db:"DATA_TYPE"`
	ExternalLanguage string `db:"EXTERNAL_LANGUAGE"`
}

type RoutineList struct {
	Name string `db:"ROUTINE_NAME"`
}

type Schema struct {
	Name string `db:"SCHEMA_NAME"`
}

type Table struct {
	Name string `db:"TABLE_NAME"`
}

type View struct {
	Name       string `db:"TABLE_NAME"`
	Definition string `db:"VIEW_DEFINITION"`
}

type ViewList struct {
	Name string `db:"TABLE_NAME"`
}