SchemaSpy - drupal - Anomalies

Generated by
SchemaSpy


Things that might not be 'quite right' about your schema:	Please support this project

Columns whose name and type imply a relationship to another table's primary key:

Child Column	Implied Parent Column
blocks_roles.rid	role.rid
boxes.format	filter_formats.format
cache.cid	cache_page.cid
cache_filter.cid	cache_page.cid
cache_menu.cid	cache_page.cid
comments.format	filter_formats.format
comments.nid	node_counter.nid
file_revisions.fid	files.fid
file_revisions.vid	vocabulary.vid
files.filename	system.filename
files.nid	node_comment_statistics.nid
filter_formats.name	sequences.name
filters.format	filter_formats.format
history.nid	node_counter.nid
menu.pid	url_alias.pid
node.nid	node_comment_statistics.nid
node.type	node_type.type
node.vid	vocabulary.vid
node_access.nid	node_comment_statistics.nid
node_revisions.format	filter_formats.format
node_revisions.nid	node_comment_statistics.nid
node_revisions.vid	vocabulary.vid
node_type.name	sequences.name
permission.rid	role.rid
permission.tid	term_data.tid
sessions.uid	users.uid
system.name	sequences.name
term_data.name	sequences.name
term_data.vid	vocabulary.vid
term_hierarchy.tid	term_data.tid
term_node.nid	node_comment_statistics.nid
term_node.tid	term_data.tid
term_synonym.name	sequences.name
term_synonym.tid	term_data.tid
users_roles.rid	role.rid
users_roles.uid	users.uid
vocabulary.name	sequences.name
vocabulary_node_types.type	node_type.type
vocabulary_node_types.vid	vocabulary.vid

39 instances of anomaly detected

Tables without indexes:

Table Rows

blocks 2

flood 0

2 instances of anomaly detected
Columns that are flagged as both 'nullable' and 'must be unique':
Anomaly not detected
Tables that contain a single column:
Anomaly not detected
Tables with incrementing column names, potentially indicating denormalization:

Table

term_relation

1 instance of anomaly detected
Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
Anomaly not detected