CASE Studio 2 - HTML Report

Relationship 'accesslog'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	sessions
Child entity	accesslog

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
sid	sid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'accesslog'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	accesslog

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'aggregator_category_feed'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	aggregator_category
Child entity	aggregator_category_feed

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
cid	cid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'aggregator_category_item'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	aggregator_category
Child entity	aggregator_category_item

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
cid	cid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'aggregator_category_item'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	aggregator_item
Child entity	aggregator_category_item

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
iid	iid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'aggregator_feed'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	aggregator_feed
Child entity	aggregator_category_feed

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
fid	fid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'aggregator_item'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	aggregator_feed
Child entity	aggregator_item

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
fid	fid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'authmap'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	access
Child entity	authmap

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
aid	aid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'authmap'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	authmap

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'blocks_roles'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	role
Child entity	blocks_roles

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
rid	rid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'book'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	book
Child entity	book

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
vid	parent

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'book'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node
Child entity	book

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'book'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node_revisions
Child entity	book

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
vid	vid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'boxes'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	filter_formats
Child entity	boxes

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
format	format

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'client_system'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	client
Child entity	client_system

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
cid	cid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'comment(parent)'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	comments
Child entity	comments

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
cid	pid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'comments'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	filter_formats
Child entity	comments

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
format	format

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'comments'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	comments

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'comments'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node
Child entity	comments

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'file_revisions'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node_revisions
Child entity	file_revisions

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
vid	vid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'file_revisions'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	files
Child entity	file_revisions

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
fid	fid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'files'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node
Child entity	files

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'filters'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	filter_formats
Child entity	filters

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
format	format

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'forum'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node
Child entity	forum

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'forum'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node_revisions
Child entity	forum

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
vid	vid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'forum'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	term_data
Child entity	forum

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
tid	tid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'history'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	history

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'history'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node
Child entity	history

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'locales_target'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	locales_meta
Child entity	locales_target

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
locale	locale

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'locales_target'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	locales_source
Child entity	locales_target

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
lid	lid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'menu'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	menu
Child entity	menu

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
mid	pid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'node'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	node

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'node'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node_revisions
Child entity	node

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
vid	vid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'node_access'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node
Child entity	node_access

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'node_comment_statistics'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	node_comment_statistics

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	last_comment_uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'node_comment_statistics'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node
Child entity	node_comment_statistics

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'node_counter'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node
Child entity	node_counter

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'node_revision'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node
Child entity	node_revisions

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'node_revisions'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	filter_formats
Child entity	node_revisions

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
format	format

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'node_revisions'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	node_revisions

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'permission'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	term_data
Child entity	permission

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
tid	tid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'permission'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	role
Child entity	permission

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
rid	rid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'poll'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node
Child entity	poll

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'poll_choices'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	poll
Child entity	poll_choices

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'poll_votes'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	poll_votes

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'poll_votes'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	poll
Child entity	poll_votes

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'profile_values'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	profile_fields
Child entity	profile_values

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
fid	fid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'profile_values'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	profile_values

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'search_index'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	search_total
Child entity	search_index

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
word	word

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'session'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	sessions

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'term_data'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	vocabulary
Child entity	term_data

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
vid	vid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'term_heirarchy'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	term_data
Child entity	term_hierarchy

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
tid	tid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'term_node'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	node
Child entity	term_node

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
nid	nid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'term_node'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	term_data
Child entity	term_node

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
tid	tid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'term_relation1'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	term_data
Child entity	term_relation

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
tid	tid1

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'term_relation2'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	term_data
Child entity	term_relation

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
tid	tid2

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'term_synonym'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	term_data
Child entity	term_synonym

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
tid	tid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'users_roles'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	users_roles

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'users_roles'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	role
Child entity	users_roles

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
rid	rid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'vocabulary_node_types'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	vocabulary
Child entity	vocabulary_node_types

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
vid	vid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No

Relationship 'watchdog'

General info

Relationship type	non-identifying	Cardinality	1:N
Parent entity	users
Child entity	watchdog

Partiality

Parent	mandatory
Child	mandatory

Referential integrity

	Insert	Update	Delete
Parent	----	RESTRICT	RESTRICT
Child	NONE	NONE	----

Keys

Parent key	Child key
uid	uid

User-defined variables

Name	Value
Generate Index to Foreign key automatically	No