The Drupal database

A portion of the Drupal is shown below.

Abstraction hierarchy:

Drupal datamodel

The DDL statements for construction of this portion of a Drupal database:

database drupal.

base name (A60).
base pass (A32).
type user (A32) = name, pass.

base node type (A32).
type node (I9) = node type.

base title (A128).
base body (A65535).
base teaser (A65535).
type node revisions (I9) = node, user, title, body, teaser.

base subject (A64).
base comment (A65535).
type comments (I9) = node, user, subject, comment.

base description (A512).
type vocabulary (I9) = name, description.
type vocabulary node type (I9) = vocabulary, node type.
type term data (I9) = vocabulary.
type term node (I9) = node, term data.

end.