Table custom re-ordering

When I re-order rows in my table it re-assigns numbers starting from one, like for example if I have a table with records ordered by the

number

number

column and numbers are between

and

and when I drag the row with number

to first position it re-assigns the numbering of entire table from

overriding the previous values of other columns as well. Check the following images for example.

I have a

Novel

Novel

model which has many

Series

Series

and each series has many

Chapters

Chapters

the

Chapters

Chapters

are associated with distinct numbers linked with grand parent

Novel

Novel

adjacent chapters can be in two separate

Series

Series

like Chapter

can be in Series 1 and Chapter

can be in Series 2

Filament•3y ago