|HomeAbout SSDMBusiness BenefitsSSDM = Methodology + Technology + Assistance|| Developer's Corner|
- Requirements Capture
- UML Static Data Model
- Application Design
- Sibilo Software Development Environment (Sibilo.SDE)
- Sibilo.DBL Programming
- Core Objects
4.1 Database (UML-DB Mapping)
Although Sibilo.SDE generates and updated the database automatically, it is useful to know the mapping it uses.
i. Object to Table
The C prefix is removed from the object name and saved to the database with a tbl_ prefix. For each attribute a database field is created with a fld_ prefix.
ii. 1-n as Foreign Key
A foreign key field is created in the table with the primary key (ID) of the n object
iii. n-n as Link Table
A link table is created with the tbl_link_ prefix and the two table names it links. (e.g. tbl_link_user_photo) This table has the primary keys (IDs) of the 2 tables as foreign keys.
iv. 1-1 & Inheritance tables
A foreign key field is created in the main table. For example when CPhoto inherits CFile, a fld_fileID foreign key is created in tbl_photo.