By defining the index on the columns and as a unique key, the table is created with the CreateTable function, but the keys are not. ```py users = Table( 'users', metadata, Column('id', Integer, primary_key=True), Column('name', String(length=255)), Column('email', String(length=255), unique=True, index=True) ) ``` ```py for table in metadata.tables.values(): schema = sqlalchemy.schema.CreateTable(table, if_not_exists=True) query = schema.compile(dialect=postgresql.dialect()) await database.execute(query=str(query)) ```
By defining the index on the columns and as a unique key, the table is created with the CreateTable function, but the keys are not.