table

type ColumnInfo struct {
	No                string
	ColumnLogicalName string
	ColumnName        string
	Type              string
	JsonItem          []JsonItemInfo
	Length            int
	LengthEx          int
	PK                bool
	NotNull           bool
	Default           string
	Description       string
	Remark            string
	IsJson            bool
	Data              string
}

type JsonItemInfo struct {
	ItemNo          string
	ItemLogicalName string
	ItemName        string
	ItemType        string
	ItemLength      int
	ItemLengthEx    int
}

type TableData struct {
	TableLogicalName string
	TableName        string
	DataList         [][]ColumnInfo
	ExInfo           string
}

type TableDefine struct {
	TableLogicalName string
	TableName        string
	Column           []ColumnInfo
	ExInfo           string
	HasJsonColumn    bool
}

type TableDesineConfig struct {
	SheetNameTableDefine []string `yaml:"sheetNameTableDefine"`
	ColNo                string   `yaml:"colNo"`
	ColColumnLogicalName string   `yaml:"colColumnLogicalName"`
	ColColumnName        string   `yaml:"colColumnName"`
	ColPK                string   `yaml:"colPK"`
	ColType              string   `yaml:"colType"`
	ColLength            string   `yaml:"colLength"`
	ColItemLogicalName   string   `yaml:"colItemLogicalName"`
	ColItemName          string   `yaml:"colItemName"`
	ColItemType          string   `yaml:"colItemType"`
	ColItemLength        string   `yaml:"colItemLength"`
	ColNotNull           string   `yaml:"colNotNull"`
	ColDefault           string   `yaml:"colDefault"`
	ColDescription       string   `yaml:"colDescription"`
	ColRemark            string   `yaml:"colRemark"`
	StartRow             int      `yaml:"startRow"`
	LastRow              int
}

type TableIn struct {
	// 表设计文件（XLSX）
	TableDesineFile []string `yaml:"tableDesineFile"`
	// 表设计 配置文件
	TableDesineConfigFile string `yaml:"tableDesineConfigFile"`

	// 表定义文件（JSON）
	TableDefineFile string `yaml:"tableDefineFile"`

	// 数据模板 配置文件
	TemplateConfigFile string `yaml:"templateConfigFile"`
	// 数据模板输出对象表
	TemplateOutTargetTable []string `yaml:"templateOutTargetTable"`
	// 数据模板输出文件
	TemplateFile string `yaml:"templateFile"`

	// 测试数据文件
	TestDataFile string `yaml:"testDataFile"`
	// 数据库类型
	DatabaseType int `yaml:"databaseType"`
	// CSV目录
	CsvPath string `yaml:"csvPath"`
}

type TemplateConfig struct {
	IsMultiSheet     bool   `yaml:"isMultiSheet"`
	SingleSheetName  string `yaml:"singleSheetName"`
	CountDefaultdata int    `yaml:"countDefaultdata"`
	CountSeparateRow int    `yaml:"countSeparateRow"`

	ColTableLogicalName string `yaml:"colTableLogicalName"`
	ColTableName        string `yaml:"colTableName"`
	RowTableLogicalName int    `yaml:"rowTableLogicalName"`
	RowTableName        int    `yaml:"rowTableName"`

	RowColumnLogicalName int `yaml:"rowColumnLogicalName"`
	RowColumnName        int `yaml:"rowColumnName"`
	RowType              int `yaml:"rowType"`
	RowLength            int `yaml:"rowLength"`

	RowJsonColumnLogicalName int `yaml:"rowJsonColumnLogicalName"`
	RowJsonColumnName        int `yaml:"rowJsonColumnName"`
	RowJsonType              int `yaml:"rowJsonType"`

	RowItemLogicalName int `yaml:"rowItemLogicalName"`
	RowItemName        int `yaml:"rowItemName"`
	RowItemType        int `yaml:"rowItemType"`
	RowItemLength      int `yaml:"rowItemLength"`

	StartColData string `yaml:"startColData"`

	CellFont                  string `yaml:"cellFont"`
	TableLogicalNameBackColor string `yaml:"tableLogicalNameBackColor"`
	TableNameBackColor        string `yaml:"tableNameBackColor"`
	ColumnHeadBackColor       string `yaml:"columnHeadBackColor"`
	JsonHeadItemBackColor     string `yaml:"jsonHeadItemBackColor"`
}