network profile
| bio | website | twitter.com/apinsard |
|---|---|---|
| location | France | |
| age | 21 | |
| visits | member for | 3 months |
| seen | May 12 at 9:21 | |
| stats | profile views | 0 |
|
Feb 28 |
awarded | Citizen Patrol |
|
Feb 24 |
awarded | Scholar |
|
Feb 24 |
accepted | Choice- or ids-list- field representation |
|
Feb 24 |
answered | Choice- or ids-list- field representation |
|
Feb 24 |
revised |
Choice- or ids-list- field representation Remove the answer to post it as an answer. |
|
Feb 24 |
awarded | Benefactor |
|
Feb 19 |
comment |
Choice- or ids-list- field representation No, it points to a specific known table. My question is quite general, it is not for a specific project. But if it's clearer for you, just assume it points to the User table (which makes sense if the user wants to grant access to his profile page to "Everybody", "Friends", "Nobody" or a specific set of users for instance). |
|
Feb 19 |
comment |
Choice- or ids-list- field representation Actually I can't see how table inheritance solves the issue. I edited my question. Maybe it will remove any misunderstanding? |
|
Feb 19 |
awarded | Editor |
|
Feb 19 |
revised |
Choice- or ids-list- field representation Tried to make my question clearer and bring out the solution I personally found yet. |
|
Feb 19 |
comment |
Choice- or ids-list- field representation Sorry if I didn't make myself clear but I don't think the data stored in the other table matters. This could be users, products or bananas. What is important is that if I don't have a "generic" or pre-defined value in the field, the custom value is a LIST of rows from the other table. So basically a comma-separated list of IDs. I will rewrite my question, it might not be well-expressed. |
|
Feb 18 |
awarded | Promoter |
|
Feb 8 |
comment |
Choice- or ids-list- field representation So to put in a nutshell, there is no common solution, it highly depends on one's needs. However the second solution I raised looks better and more scalable than the former. Do I well understood ? |
|
Feb 5 |
awarded | Student |
|
Feb 5 |
asked | Choice- or ids-list- field representation |
|
Feb 5 |
awarded | Autobiographer |
