CGLIB Developer |
|
Joined: Thu Aug 28, 2003 1:44 pm Posts: 1217 Location: Vilnius, Lithuania
|
It is better not have one to one relationships in database for very simple reasons, It needs join to select dependant entities and it needs to maintain integraty. You can avoid it by moving data to single table (the same is about herarchies) It is just optimization, phisical schema doe's not need to look nice, you can make it better with views. Databases can optimize disk usage if you declare nullable fields last, it is not a problem to have more fielts in single table.
|
|