Database schema for large scale project (338092)

The project is for a database schema for large scale classified listing project. Only the schema for this stage. The key requirements are: Scaleable Full text searching Multilingual - many languages Revision history (wiki like) All edits are to be retained and identified by User, time, etc, so that all updates can be individually rolled back to a previous state. The overall structure is to organize data objects - Listings - Comments - Ratings - Notes - Other Sections - approximately 10 sections - organize topics - topics are repeated in each section Topics - many topics - topics organize listings - listings are unique for each Section and Topic combination Listings - many listings - listings contain many attribute values (fields), including some with text - may be translated into multiple languages Users - many users - user profiles and details Comments - users may comment on anything ??" Sections/Topics/Listings/Users Ratings - users may rate Topics Notes and Bookmarks - users may have notes and bookmarks on anything We are looking for the optimum solution, but we do have a prototype in PostgreSQL to evaluate against where all the data is in the same table. The table has a minimal number of specific fields relating to the record specifically, plus 100 text, 20 date, 20 numeric, and 10 blob. Templates, based on Section, Topic and record type point to the actual data field location. A certain number of these fields are indexed for performance. Once the schema is accepted, we are planning on adapting an open source CMS as a partial frontend solution, and are leaning to Drupal. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform linux