Jump to content

Recommended Posts

Hi,

I have been thinking of writing an web application for a member based system. I have come up with an initial DB design and would like some feedback advise next step's etc as this is the first time I am doing this.

 

Concept

To hold information about its members and what roles they do, it needs to be simple, fast and functional.

There are many aspects of this system for future development for building information, availability information etc so this needs to be thought about in the initial stages so a re-design will not be necessary.

 

Thanks.

Link to comment
https://forums.phpfreaks.com/topic/127979-member-plus-application-concept/
Share on other sites

WARNING: This is my personal preference.

 

One this i would say about your database naming convention is the way you name primary/foreign keys seems a little weird to me.  For primary keys, i think it is cleaner to use a standard name globally like id.  For primary keys i think it is cleaner to use the singular versions if the table name is plural(so the foreign key to the users table would be user_id) becuase something like u_id is going to be confusing and you will run into conflict is you have another table that begins with u and it one word and you need a foreign key to both another table.

well the int is going to store and give you the unix timestamp(or the number of second from 1970 or something) where and datatime/timestamp with return you the date like 2008-02-02 23:23:23.  I would recommend the datatime/timestamp as i find it easier to work.

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.