Well I have a site where i hav to keep a photo album and as obvious profile pic .. should i add both in the same table in database ?

Question

0.00/5 (No votes)

See more:

, +

If yes how do i differentiate between the profile pic and pics of photo album .. my database table design for profile pic is

Column Name Data Type Allow Nulls
PhotoId bigint No
PhotoPath nvarchar(150) Yes
CandidateId bigint No
IsDefault bit Yes
IsDeleted bit Yes
CreatedUser int Yes
CreatedDt datetime Yes
LastModUser int Yes
LastModDt datetime Yes

Posted 2-Apr-11 17:29pm

Member 7764639

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2011-04-02T22:26:00

Solution 2

One or two tables depends how different the requirements for those tables are. When adding the profile picture if you need different kind of information than with photo album rows, then it could be better to separate those tables. If the data is similar then just add a descriptive column as Abhinav suggested.

Posted 2-Apr-11 22:26pm

Wendelius

Comments

Member 7764639 5-Apr-11 22:04pm

okay . but i hav already live site .. so may be i need to take a different table .. also how do i put constrain of max 5 photos in photo album.

Wendelius 6-Apr-11 15:37pm

If the database is live, adding the table may be necessary. Although if you add columns which allow null values, the existing programs may not be affected as long as they don't fetch everything (SELECT * ...) and so on. SO to be on the safe side (if you don't have the control over the applications), add a new table.

Just wondering, why the vote 2 for this answer if it was helpful?

Member 7764639 7-Apr-11 6:42am

so how should my new table design be
a user can upload max of 5 photos in his album.and only 1 album per user

Wendelius 7-Apr-11 13:57pm

Dpeends on the overall situation. If you already have a user table then you could simply create a table having columns:
- userid
- picture
Now the tricky part is that you cannot directly restrict the table having more than 5 rows per user so you should check how many picture the user has (like: SELECT COUNT(*) from Pictures WHERE UserID = @UserId) and if the count is 5 then don't allow any more pictures in the user interface.

Member 7764639 7-Apr-11 23:16pm

but then if a user wants to delete a photo on wt condition i remove it ?

Wendelius 8-Apr-11 1:27am

Define a proper primary key on this table. Have a look at: http://msdn.microsoft.com/en-us/library/ms174979.aspx and especially the IDENTITY definition. With that you can have a surrogate key and when deleting (or updating) a record you can use the value of this auto-generated value

Abhinav S · Answer 2 · 2011-04-02T18:26:00

Solution 1

I would recommend adding another boolean for IsProfile picture.
You should not need to create another table unless there is some other specific solution you are looking for.

Posted 2-Apr-11 18:26pm

Abhinav S

Comments

Member 7764639 3-Apr-11 1:10am

okie .. but how to change bit value for IsProfile pic while uploading profile pic
i have two different pages for uploading profile pic and photo album

Member 7764639 · Answer 3 · 2011-04-29T18:06:00

Solution 3

if the database is live it is preferable to add another table

Posted 29-Apr-11 18:06pm

Member 7764639