sql

type DataModel struct {
	ID          string
	WorkspaceID string `gorm:"type:varchar(32);not null;uniqueIndex:data_ws"`
	Name        string `gorm:"type:varchar(50) CHARACTER SET gbk COLLATE gbk_bin;not null;uniqueIndex:data_ws"`
	Type        string `gorm:"type:varchar(32);not null"`
	CreatedAt   time.Time
	UpdatedAt   time.Time
}

type EntityGrid struct {
	RowID       string `gorm:"primaryKey;type:varchar(100) CHARACTER SET gbk COLLATE gbk_bin;not null"`
	ColumnIndex int    `gorm:"primaryKey;not null"`
	DataModelID string `gorm:"primaryKey;type:varchar(32);not null;index"`
	Value       string `gorm:"type:longtext CHARACTER SET gbk COLLATE gbk_bin;not null"`
}

type EntityHeader struct {
	ColumnIndex int    `gorm:"primaryKey;not null"`
	DataModelID string `gorm:"primaryKey;type:varchar(32);not null;index"`
	Name        string `gorm:"type:varchar(100) CHARACTER SET gbk COLLATE gbk_bin;not null"`
	Type        string `gorm:"type:varchar(32);not null"`
}

type EntitySetRow struct {
	ID          uint
	RowID       string `gorm:"type:varchar(100) CHARACTER SET gbk COLLATE gbk_bin;not null"`
	DataModelID string `gorm:"type:varchar(32);not null;index"`
	RefRowID    string `gorm:"type:varchar(100) CHARACTER SET gbk COLLATE gbk_bin;not null"`
}

type WorkspaceRow struct {
	Key         string `gorm:"primaryKey;type:varchar(100) CHARACTER SET gbk COLLATE gbk_bin;not null"`
	DataModelID string `gorm:"primaryKey;type:varchar(32);not null;index"`
	Value       string `gorm:"type:longtext CHARACTER SET gbk COLLATE gbk_bin;not null"`
	Type        string `gorm:"type:varchar(32);not null"`
}