def downgrade()

in src/Backend/migrations/versions/2023_06_06_001301-a37ce1b170bd_refactoring_result_table.py [0:0]


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('exams_users_questions',
    sa.Column('user_id', sa.UUID(), autoincrement=False, nullable=False),
    sa.Column('exam_id', sa.UUID(), autoincrement=False, nullable=False),
    sa.Column('question_id', sa.UUID(), autoincrement=False, nullable=False),
    sa.Column('group_id', sa.UUID(), autoincrement=False, nullable=False),
    sa.Column('organization_id', sa.UUID(), autoincrement=False, nullable=False),
    sa.Column('result', postgresql.JSONB(astext_type=sa.Text()), autoincrement=False, nullable=False),
    sa.Column('right_count', sa.INTEGER(), autoincrement=False, nullable=False),
    sa.Column('created_at', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=False),
    sa.Column('updated_at', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=False),
    sa.Column('status', postgresql.ENUM('NOT_STARTED', 'IN_PROGRESS', 'FINISHED', name='examstatus'), autoincrement=False, nullable=False),
    sa.ForeignKeyConstraint(['exam_id'], ['exams.id'], name='exams_users_questions_exam_id_fkey'),
    sa.ForeignKeyConstraint(['group_id'], ['groups.id'], name='exams_users_questions_group_id_fkey', ondelete='RESTRICT'),
    sa.ForeignKeyConstraint(['organization_id'], ['organizations.id'], name='exams_users_questions_organization_id_fkey', ondelete='RESTRICT'),
    sa.ForeignKeyConstraint(['question_id'], ['questions.id'], name='exams_users_questions_question_id_fkey'),
    sa.ForeignKeyConstraint(['user_id'], ['users.id'], name='exams_users_questions_user_id_fkey'),
    sa.PrimaryKeyConstraint('user_id', 'exam_id', 'question_id', name='exams_users_questions_pkey')
    )