gistfile1.py

import datetime

from pony.orm import *

db = Database('sqlite', 'data.sqlite', create_db=True)

class Base(db.Entity):
	created = Optional(datetime.datetime, default=datetime.datetime.now)


class X(Base):
	x = Optional(int)


class Y(Base):
	y = Optional(int)


class Z(Base):
	z = Optional(int)


class A(X, Y):
	pass


class B(Y, Z):
	pass
	

db.generate_mapping(create_tables=True)