Thinking about multi reply table in oracle~!
Pc resolution is very high. so it is very readable in short time.
Mobile resolution size is smaller than PC. so paradigm of design is simple.
It seems that people like if something is so simple.
what I want to say is multi reply system is not many used in these days.
but I have to know how to think and make table for multi reply in board.
one way :
column : id
subcolumn : parent id, title
Id is unique value
and parent id indicate Id
and more and more
this architecture can make limitless depth replies.
query can express by using oracle grammer connect by
In my opinion
advantage : formal and readable
disadvantage : many article, connect by spend much time to query
the other recommendable way :
column : id
subcolumn : order_id, title, root_comment_id, depth
I want to show you ex)..
id title, depth depth_order root_comment_id
00000000001 root title 0 1 00000000001
00000000002 title 1 1 00000000001
00000000003 title 2 1 00000000001
00000000004 title 2 2 00000000001
00000000005 root title 0 1 00000000002
select * from table order by root_comment_id desc, depth asc, depth_order desc
Anyway there are lots of way you can make.
what kind of way to choose is up to you~!