4 ms·

I've begun a data model at yuml, you can see it here: http://yuml.me/diagram/dir:lr/class/%5BActions|id%3bShellCompany%3bSubject%3bMessage%3bparentActions%3bcr

by fnid2 17y ago

I've begun a data model at yuml, you can see it here: http://yuml.me/diagram/dir:lr/class/%5BActions|id%3bShellCompany%3bSubject%3bMessage%3bparentActions%3bcreatedate%3bcreateid%3b%5D%2c%5BComments|id%3bShellCompany%3bSubject%3bComment%3bReplyToComment%3bcreatedate%3bcreateid%3b%5D%2c%5BRelatedCompanies|id%3bCompanyOne%3bCompanyTwo%3bcreatedate%3bcreateid%3b%5D%2c%5BShellCompanies|id%3bName%3bAddress%3bWebsite%3bDateFounded%3bcreatedate%3bcreateid%3b%5D%2c%5BVotes|id%3bShellCompany%3bIsShell%3bcreatedate%3bcreateid%3b%5D%2c%5BShellCompanies%5D%2b%2b1-ShellCompany+%3E%5BActions%5D%2c%5BActions%5D%2b%2b1-parentActions+%3E%5BActions%5D%2c%5BShellCompanies%5D%2b%2b1-ShellCompany+%3E%5BComments%5D%2c%5BComments%5D%2b%2b1-ReplyToComment+%3E%5BComments%5D%2c%5BShellCompanies%5D%2b%2b1-CompanyOne+%3E%5BRelatedCompanies%5D%2c%5BShellCompanies%5D%2b%2b1-CompanyTwo+%3E%5BRelatedCompanies%5D%2c%5BShellCompanies%5D%2b%2b1-ShellCompany+%3E%5BVotes%5D%2c%5Byesno%5D%2b%2b1-IsShell+%3E%5BVotes%5D%2c http://yuml.me/diagram/dir:lr/class/%5BActions|id%3bShellCom...

noblethrasher 17y ago
The schema looks good. I'm a web developer and would like to help, what do you need?
- fnid2 17y ago
  Awesome! I'll get the website up soon and post a link. We can modify it over the web with html/css/js/sql with the web platform I'm going to use. keep checking http://www.shellcompanyfinder.com http://www.shellcompanyfinder.com Should be up ... hopefully soon.
  - noblethrasher 17y ago
    OK, I see it. If you'd like to communicate over email you can reach me at noblethrasher@gmail.com
    - fnid2 17y ago
      I created an account for you. Should see the email soon.
abolibibelot 17y ago
What's the point of the createid fields? And why do you hardcode two related companies instead of going for a N-N relationship?
- fnid2 17y ago
  The createid is the unique id of the user who created the record. There is an N-N relationship between companies persisted in the RelatedCompanies table. Perhaps I should add a field to the RelatedCompanies table that is a description of the relationship: Subsidiary, Partnership, Spin-off. When we start, we are probably going to start listing companies without really knowing how they are related. They are just a group of companies. I considered a self-join, but we may not know who the parent is and a company may be related to more than one company through some mechanisms I don't understand yet.

by fnid2 17y ago

noblethrasher 17y ago

The schema looks good. I'm a web developer and would like to help, what do you need?

fnid2 17y ago
Awesome! I'll get the website up soon and post a link. We can modify it over the web with html/css/js/sql with the web platform I'm going to use. keep checking http://www.shellcompanyfinder.com http://www.shellcompanyfinder.com Should be up ... hopefully soon.
- noblethrasher 17y ago
  OK, I see it. If you'd like to communicate over email you can reach me at noblethrasher@gmail.com
  - fnid2 17y ago
    I created an account for you. Should see the email soon.

abolibibelot 17y ago

What's the point of the createid fields? And why do you hardcode two related companies instead of going for a N-N relationship?

fnid2 17y ago
The createid is the unique id of the user who created the record. There is an N-N relationship between companies persisted in the RelatedCompanies table. Perhaps I should add a field to the RelatedCompanies table that is a description of the relationship: Subsidiary, Partnership, Spin-off. When we start, we are probably going to start listing companies without really knowing how they are related. They are just a group of companies. I considered a self-join, but we may not know who the parent is and a company may be related to more than one company through some mechanisms I don't understand yet.