pls advise on sugar database

[hoang]

Hi,
I'm trying to understand SugarCRM database to see if it's possible to migrate and intergrate our own Access DB to SugarCRM DB. As i'm fairly new to MySQL and PHP, there seems to be a lot of info to absorb here..so pls bear with my questions..
1. The default engine of Sugar is MyISAM, hence no foreign key support. So how does Sugar insert data and maintain the relationship between the tables?
2. If i am to create a new table, do i have to manually set up all the relationship in vardefs.php and MetaData.php? if not how do i go about doing that? Does Module Builder do that?
Thank you
cheers
Edited: i'm looking at : 5.0 Beta 2 Release

[GameboyRMH]

Module Builder defines tables for new modules when you're creating the module. When you hit Deploy (or install it via the module loader) these tables are created (I'm guessing based on the vardefs.php in custom/modulebuilder/packages/<packagename>/modules/<modulename>). I don't know how you would link a manually created table to a module but you usually shouldn't need to do so.

SugarCRM stores a 36-character id ("id" fields in Studio) for every record, and links to them using 36-character varchar ("text field" in Studio) fields with the format <linkedmodulename>_id. SugarCRM generates these ids on it's own, but I remember seeing something about a tool for generating ids.

Anyone else know about generating ids?