yaml model

yaml_model.py

class Database(Schema):
    class Meta:
        ordered = True
    name = fields.String()
    id = fields.Integer()
    tables = fields.Nested(Table, many=True)

class Table(Schema):
    class Meta:
        ordered = True
    name = fields.String()
    id = fields.Integer()
    description = fields.String()
    columns = fields.Nested(Column, many=True)
    primary_key = fields.Nested(PrimaryKey)
    indexes = fields.Nested(Index, many=True)
    constraints = fields.Nested(Constraint, many=True)
    foreign_keys = fields.Nested(DatabaseIndex, many=True)

class Column(Schema):
    class Meta:
        ordered = True
    name = fields.String()
    id = fields.Integer()
    ordinal = fields.Integer()
    datatype = fields.String()
    nullable = fields.Boolean()
    default = fields.String()
    length = fields.Integer()
    scale = fields.Integer()
    precision = fields.Integer()
    description = fields.String()
    utype = fields.String()	
    ucd = fields.String()
    unit = fields.String()
    arraysize = fields.Integer()


class Constraint(Schema):
    class Meta:
        ordered = True
    name = fields.String() # optional
    type = fields.String()  # (unique, primary, foreign, check)
    columns = fields.List(fields.String())
    expression = fields.String()  # if check constraint
    refcolumns = fields.List(fields.String()) # if foreign key