You need a table person, with all common fields, and a persona, prsonb,
personc and persond tables with their respective fields and foreign keys
of the person table (it will make your database and software easier to
modify in a future), but sometimes is better to simply put null values...
El 16/01/15 a las 06:12, António Ramos escribió:
Hello i need some advice
I have a table company and a table person .a person belongs to a company.
Now i´m told that not all person needs the same fields.
i will have 4 types of companies. So a person from company type a has
10 fields, a person from company type b has 5 fields, etc.
Also some fields are mandatory.
what is more efficient ?
I create table persona,personb,personc,persond
or i create a table person with all needed fields for all companies
types.in <http://types.in> this case a lot of fields will be empty.
I´d like to hear your experience on this
Thank you
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google
Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
Este mensaje le ha llegado mediante el servicio de correo electronico que
ofrece Infomed para respaldar el cumplimiento de las misiones del Sistema
Nacional de Salud. La persona que envia este correo asume el compromiso de usar
el servicio a tales fines y cumplir con las regulaciones establecidas
Infomed: http://www.sld.cu/
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
