Schema

Core Tables

System Table

Module Specific Tables

Modules can implement hook_schema() to create and drop tables. Usually located in modulename.install, hook_scheme returns an array (called a Drupal Schema Definition) that has a key for each table the module defines, defining each table's fields, key, and indexes.  For more information, see Schema API and Schema API (2).