Database schema for large scale project
$100-300 USD
Dibayar saat pengiriman
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.
ID Proyek: #64639