Skip to topic | Skip to bottom
Home
Stac
Stac.StAcDataModelr1.1 - 20 Nov 2004 - 17:51 - TWikiGuesttopic end

Start of topic | Skip to actions

Data is separated in projects and users.

Since single user can be involved in many projects, it made sense to reference users from projects and keep their data separate, so that user data has to be updated in one place only. Also, for the sake of beter efficiency, UI on-demand data loading is made easier by keeping list of all projects (project list) in a separate storage which keeps only names and id's of projects, enough to be able to display the project name in the UI and to be able to load all data by using its id.

Current Data Model already changed, with the discussions about what kind of data about projects openmute needs. However, this could be amended later, since missing fields might not be important to have the beta version of StAc running (have to think about it still, data model may change slightly again in next few meetings).

user

  • id
  • city
  • emails
  • first_name
  • last_name
  • organization
  • phone
  • source

project

  • id
  • name
  • organization
  • contact_userid
  • tools
  • users

project list

  • id
  • name

note: this will change according to the data we agreed we need from users and projects, but probably has to stay like this for first beta launch.
to top


You are here: Stac > StAc > StAcMain > StAcArchitecture > StAcDataModel

to top

Copyright © 1999-2012 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Open-org? Send feedback