Concept
DB design 1
“users” table
[sql]
1 AA
2 BB
[/sql]
“authority_groups” table
[sql]
group_auto name
1 Admin
2 Writer
[/sql]
“authority_group_items” table
[sql]
group_auto item_auto
1 22
1 23
2 11
2 12
2 22
[/sql]
“items” table
[sql]
item_auto page_url
…
11 http://aaa.com/11/
12 http://aaa.com/12/
…
22 http://aaa.com/22/
23 http://aaa.com/23/
…
[/sql]
Leave a Reply