How to discover table properties from SQLAlchemy mapped object

Information you need you can get from Table object:

• Ship.__table__.columns will provide you with columns information
• Ship.__table__.foreign_keys will list foreign keys
• Ship.__table__.constraints, Ship.__table__.indexes are other properties you might find useful