schema

type Commander struct {
	ConnUrl        string
	Database       string
	Tables         []string
	Without        []string
	ReadOnly       []string
	Tags           []string
	Scheme         string
	Host           string
	User           string
	Password       string
	Charset        string
	OutDir         string
	Prefix         string
	Suffix         string
	PackageName    string
	Protobuf       bool
	DisableDecimal bool
	OneFile        bool
	GogoOptions    []string
}

type TableColumn struct {
	Name         string `json:"COLUMN_NAME" db:"COLUMN_NAME"`
	DataType     string `json:"DATA_TYPE" db:"DATA_TYPE"`
	Key          string `json:"COLUMN_KEY" db:"COLUMN_KEY"`
	Extra        string `json:"EXTRA" db:"EXTRA"`
	Comment      string `json:"COLUMN_COMMENT" db:"COLUMN_COMMENT"`
	IsPrimaryKey bool   // is primary key
	IsDecimal    bool   // is decimal type
	IsReadOnly   bool   // is read only
	GoName       string //column name in golang
	GoType       string //column type in golang
}

type TableSchema struct {
	SchemeName   string        `json:"TABLE_SCHEMA" db:"TABLE_SCHEMA"`   //database name
	TableName    string        `json:"TABLE_NAME" db:"TABLE_NAME"`       //table name
	TableEngine  string        `json:"ENGINE" db:"ENGINE"`               //database engine
	TableComment string        `json:"TABLE_COMMENT" db:"TABLE_COMMENT"` //comment of table schema
	SchemeDir    string        `json:"SCHEMA_DIR" db:"SCHEMA_DIR"`       //output path
	PkName       string        `json:"PK_NAME" db:"PK_NAME"`             //primary key column name
	StructName   string        `json:"STRUCT_NAME" db:"STRUCT_NAME"`     //struct name
	OutDir       string        `json:"OUT_DIR" db:"OUT_DIR"`             //output directory
	FileName     string        `json:"FILE_NAME" db:"FILE_NAME"`         //output directory
	Columns      []TableColumn `json:"TABLE_COLUMNS" db:"TABLE_COLUMNS"` //columns with database and golang
}