Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
giro
Starting Member
8 Posts |
 Posted - 2003-12-04 : 04:55:47
|
| Hi,I've a question on storing the avatar (image) information. Say the user can select from a pre-defined list of avatars or input a url into a field for the avatar. How should I store this information in a table like profile? My solution is as follows:profile_table-user_id (pk)-avatar_id (fk)-avatar_url (VARCHAR)avatars_table-avatar_id (pk)-avatar_gif (VARCHAR)If the user selects an avatar from a given list (from a web page), the avatar_id is stored with the chosen id in her profile (which means the avatar_url column is left NULL). If she enter a url, then the input is stored in avatar_url (which means the avatar_id column is NULL).What is the best way to store the avatar information given the above scenario?Thanks in advance :) |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-12-04 : 06:27:17
|
| Looks like a good way to me. I think you are on the right track.Damian |
 |
|
|
giro
Starting Member
8 Posts |
Posted - 2003-12-04 : 08:17:27
|
| cool :) thanks! |
|
|
|
|
|
|
Question on fields..