List:General Discussion« Previous MessageNext Message »
From:Mihamina Rakotomandimby Date:January 13 2010 1:41pm
Subject:describe relation between LDAP entries
View as plain text  
Manao ahoana, Hello, Bonjour,

I have LDAP entries, and SQL tables are the relation between them.
There are only relations between 2 entries.

There are "modem" and "customers" entries in the LDAP directory

I need advice on optimizing the way I store relations.
For example

  SELECT * FROM customer_has_modem;
  +-----------------+----------------+
  | customer        | modem          |
  +-----------------+----------------+
  | a=aa,b=bb,c=ccc | d=dd,e=ee,f=ff | 
  +-----------------+----------------+

Is it OK?

Have you another way to do it? 
 - splitting the comma separated fields?
 - whatever?

There might later be be a "date" field in this table to trace the modem
movements.

Misaotra, Thanks, Merci.

-- 
       Architecte Informatique chez Blueline/Gulfsat:
    Administration Systeme, Recherche & Developpement
                +261 34 29 155 34 / +261 33 11 207 36
Thread
describe relation between LDAP entriesMihamina Rakotomandimby13 Jan
  • Re: describe relation between LDAP entriesMihamina Rakotomandimby13 Jan