Productgroup:
    columns:
        productgroupname:
            type: string
            length: 255
        productgroupdesc:
            type: string
            length: 4000
Product:
    columns:
        productgroup_id:
            type: integer
            length: 2
        productnum:
            type: float
        productname:
            type: string
            length: 255
        productdesc:
            type: string
            length: 4000
        productprice:
            type: float
        hasicon:
            type: boolean
        hasimage:
            type: boolean
        tax_id:
            type: integer
            length: 11
    relations:
        Tax:
            foreignType: one
        Productgroup:
            type: one
            local: productgroup_id
            foreign: id

Tax:
    columns:
        taxname:
            type: string
            length: 255
        taxpercent:
            type: float