On Tue, Jun 17, 2014 at 5:15 PM, Albert Coder <eralbert9...@gmail.com> wrote: > I tried to implement the current database as such in the MediaWiki > extension that I have made but the current database has some > attributes which seem to be redundant and useless. For eg. userID vs > desc_author and materialID vs table_materialID(in both the cases the > values are exactly the same for both attributes and I tried asking > about this in the mailing list and IRC before). So I have tried to > improve the database with some minor modifications. I have introduced > the categorization of both materials and properties which will help in > better searching and filtering. You can have a look at the enhanced > database design below: > > http://202.164.53.122/~albertcoder/images/fdb.JPG > > Suggestions are welcome for any changes in this database design and I > will be carrying on with this database design henceforth.
You should create one more table to store user information such as: user name, user id, user email, user password, user role(admin or normal user). -- Harmanpreet Singh Blog: http://singhharman.wordpress.com/ ------------------------------------------------------------------------------ HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions Find What Matters Most in Your Big Data with HPCC Systems Open Source. Fast. Scalable. Simple. Ideal for Dirty Data. Leverages Graph Analysis for Fast Processing & Easy Data Exploration http://p.sf.net/sfu/hpccsystems _______________________________________________ BRL-CAD Developer mailing list brlcad-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/brlcad-devel
