By Hawkcode on

Hi,

New to Drupal and have to write some scripts to import data.

Can anyone tell me if there is a complete Schema for the Database and all the fields. Like keys and foreign keys in tables and how they all relate.

I've got some figured out but would like to see the overall picture.

I'm also going to have to write something that will import my xcart data into Ubercart, but thats a little later.

Thanks

Richard S Albrecht

⋅ Categories: Drupal 6.x

Comments

danielb’s picture

danielb commented

Use drupal_get_schema() to get drupal's data about a table.

If you're looking for info on how tables are related to each other then your only option is to pretty much use Views relationships as Drupal doesn't track this information. Only modules that implement Views hooks will reveal information about their tables.

coreyp_1’s picture

coreyp_1 commented

Have you tried the Schema module?

-Corey