schema

type DataModel struct {
	ID          string     `validate:"required" json:"id"`
	Name        string     `validate:"required" json:"name"`
	TableName   string     `json:"tableName"`
	Properties  []Property `validate:"required" json:"properties"`
	PrimaryKeys []string   `validate:"required" json:"-"`
}

type Property struct {
	// ID is used to identify this property, which will be used as the name of this column
	// should follow pattern ^[a-z_][a-z0-9_]*$
	ID string `json:"id" validate:"required"`
	// Name is used for business observers
	Name string `json:"name" validate:"required"`
	// Type can be any of "string", "text", "number", "boolean", "date"
	// string must have a max length, while text does not require this
	// string => VARCHAR
	// text => TEXT
	Type     string                 `json:"type" validate:"required"`
	Options  map[string]interface{} `json:"options"`
	Comments string                 `json:"comments"`
	Required bool                   `json:"required" validate:"required"`
}

type VarCharOptions struct {
	MaxLength int `json:"maxLength"`
}