Re: [phplib] OT: Database Design From: Chris Padfield (chris <email protected>)
Date: 05/04/01

Personally i would do 3 tables:

DomainID | Doman Name

CompanyID | Address | Blah | Blah 2 etc.

and then the all important permissions table:

ComapanyID | DomainID

so if a company is allowed to view domains 5, 6 and 10 you have 3 rows

1 | 5
1 | 6
1 | 10

a good place for asking these sorts of questions is www.sitepointforums.com

chris padfield
http://www.ascifi.com

----- Original Message -----
From: <HurricaneIndy <email protected>>
To: <phplib <email protected>>
Sent: Friday, May 04, 2001 3:55 PM
Subject: [phplib] OT: Database Design

> Hey all,
> This is definitely off topic so I apologize but this has been killing me.
I am using mySQL. And I would like to create a table that holds a list of
domains. Let's say 50 domain names.
> Then there is going to be a company table with the typical address
information but depending on what company you are from you will be allowed
to see certain domains in the table.
> This way on the website you get a drop down list of the only available
domains you are allowed to see...
>
> example: Company_A
> allowed domains in the drop down list: Domain1.com, Domain2.com and
Domain3.com
>
> example: Company_B
> allowed domains in the drop down list: Domain1.com
>
> So thats what I am shooting for. I figure that the database should be
able to give me this information without PHP involved if the database is
designed correctly. I have tried to built one-to-many relationships and
many-to-many relationship tables with no success...
> Again I apologize for the OT please email me directly:
> hurricaneindy <email protected> if you have any suggestions for me.
> Thanks very much....
>
> Indy
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: phplib-unsubscribe <email protected>
> For additional commands, e-mail: phplib-help <email protected>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>