Jump to content

help with designing my database


Recommended Posts

Hey guys,

Hoping you could help with designing my db. Very new to sql and databases so a bit confused.

 

What I have so far is a users table with everything in it...i dont feel as though keeping everything in one table is a good idea.

Heres how my app should work:

 

- Two types of users: normal user, organization

- normal user can setup a profile with this info [name,birthday,hometown,occupation,interests, can upload music,vids and pics]

- an organization has this info in their profile[point of contact,location,state,phone, can also upload music,vids and pics]

- an organization can post events and normal users cannot

- a normal user can click a button to confirm them coming to the event

- a way to list all events per state

- a commenting system where registered users can comment on both types of users pages

 

So im thinking these tables: users, events, profile, videos, pics, music

I just dont know how everything would work together. More specifically which fields go under each table so that they are linked correctly

 

Any advice?

Thanks

Link to comment
Share on other sites

  • 2 weeks later...

Read a bit about database normalization.

 

Some hints for you:

 

1. If a user only has one profile then this should be contained in the user table. 1 to 1 joins are not best practice.

2. If there will be only 2 types of users for the lifetime of the app then this can be an ENUM field in the users table. If more will be added then a userTypes table is best with the typeId a foreign key in the users table.

3. If users are allocated to events then you will need a join table such as usersToEvents where the userId and the eventId are foreign keys to events and users.

4. If users can add many videos, music and pictures then these should be tables using a userId as a foreign key

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.