dbmeta

type DbmetaColumn struct {
	basedto.BaseEntity

	GoType        string `json:"goType",gorm:"-"`
	TableName     string `json:"tableName",gorm:"column:table_name"`
	TableSchema   string `json:"tableSchema",gorm:"column:table_schema"`
	ColumnName    string `json:"columnName",gorm:"column:column_name"`
	DbTypeName    string `json:"dbTypeName,"gorm:"column:dbTypeName"` // varchar
	PrimaryKey    bool   `json:"primaryKey",gorm:"column:primary_key"`
	AutoIncrement bool   `json:"autoIncrement",gorm:"column:auto_increment"`
	Nullable      bool   `json:"nullable",gorm:"column:nullable"`
	Unique        bool   `json:"unique",gorm:"column:unique"`
	ColumnType    string `json:"columnType",gorm:"column:column_type"` // varchar(64)
	Length        int64  `json:"length",gorm:"column:length"`
	Comment       string `json:"comment" ,gorm:"column:comment"`
	DefaultValue  string `json:"defaultValue" ,gorm:"column:default_value"`

	DecimalSize DecimalSize `json:"decimalSize",gorm:"column:decimal_size"`
}

type DbmetaFacade struct {
	basedto.BaseEntitySingle
	Dbtables
}

type DbmetaTable struct {
	basedto.BaseEntity

	TableExist  bool   `json:"tableExist"`
	TableType   string `json:"tableType"`
	TableSchema string `json:"tableSchema"`
	TableName   string `json:"tableName"`
	Comment     string `json:"comment"`

	IndexName  string `json:"indexName"`
	FieldsName string `json:"fieldsName"`

	Columns   []*DbmetaColumn `json:"columns"`
	PkColumns []*DbmetaColumn `json:"pkColumns"`
}

type Dbtables struct {
	basedto.BaseEntitySingle
	TableList  []string                     `json:"tableList"`
	ColumnsMap map[string][]gorm.ColumnType `json:"columnsMap"`

	Columns   []gorm.ColumnType `json:"columns"`
	TableName string            `json:"tableName"`
}

type DecimalSize struct {
	Precision int64
	Scale     int64
}