Relationships

It appears that you are using AdBlocking software. The cost of running this website is covered by advertisements. If you like it please feel free to a small amount of money to secure the future of this website.

Relationship ‘rel_answer_logs’

General info

Relationship typeidentifyingCardinality1:N
Parent entitytce_answers
Child entitytce_tests_logs_answers

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONERESTRICT
ChildNONENONE—-

Keys

Parent keyChild key
answer_idlogansw_answer_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_group_test’

General info

Relationship typeidentifyingCardinality1:N
Parent entitytce_user_groups
Child entitytce_testgroups

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
group_idtstgrp_group_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_group_user’

General info

Relationship typeidentifyingCardinality1:N
Parent entitytce_user_groups
Child entitytce_usrgroups

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
group_idusrgrp_group_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_module_author’

General info

Relationship typenon-identifyingCardinality1:N
Parent entitytce_users
Child entitytce_modules

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
module_idmodule_user_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_module_subjects’

General info

Relationship typenon-identifyingCardinality1:N
Parent entitytce_modules
Child entitytce_subjects

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
module_idsubject_module_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_question_answers’

General info

Relationship typenon-identifyingCardinality1:N
Parent entitytce_questions
Child entitytce_answers

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
question_idanswer_question_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_question_logs’

General info

Relationship typenon-identifyingCardinality1:N
Parent entitytce_questions
Child entitytce_tests_logs

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONERESTRICT
ChildNONENONE—-

Keys

Parent keyChild key
question_idtestlog_question_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_set_subjects’

General info

Relationship typeidentifyingCardinality1:N
Parent entitytce_test_subject_set
Child entitytce_test_subjects

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-RESTRICTRESTRICT
ChildNONENONE—-

Keys

Parent keyChild key
tsubset_idsubjset_tsubset_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_subject_author’

General info

Relationship typenon-identifyingCardinality1:N
Parent entitytce_users
Child entitytce_subjects

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
module_idsubject_user_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_subject_questions’

General info

Relationship typenon-identifyingCardinality1:N
Parent entitytce_subjects
Child entitytce_questions

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
subject_idquestion_subject_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_subject_set’

General info

Relationship typeidentifyingCardinality1:N
Parent entitytce_subjects
Child entitytce_test_subjects

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONERESTRICT
ChildNONENONE—-

Keys

Parent keyChild key
subject_idsubjset_subject_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_test_author’

General info

Relationship typenon-identifyingCardinality1:N
Parent entitytce_users
Child entitytce_tests

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
module_idtest_user_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_test_group’

General info

Relationship typeidentifyingCardinality1:N
Parent entitytce_tests
Child entitytce_testgroups

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
test_idtstgrp_test_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_test_subjset’

General info

Relationship typenon-identifyingCardinality1:N
Parent entitytce_tests
Child entitytce_test_subject_set

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
test_idtsubset_test_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_test_users’

General info

Relationship typenon-identifyingCardinality1:N
Parent entitytce_tests
Child entitytce_tests_users

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-RESTRICTCASCADE
ChildNONENONE—-

Keys

Parent keyChild key
test_idtestuser_test_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_testlog_answers’

General info

Relationship typeidentifyingCardinality1:N
Parent entitytce_tests_logs
Child entitytce_tests_logs_answers

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
testlog_idlogansw_testlog_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_testuser_logs’

General info

Relationship typenon-identifyingCardinality1:N
Parent entitytce_tests_users
Child entitytce_tests_logs

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
testuser_idtestlog_testuser_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_user_group’

General info

Relationship typeidentifyingCardinality1:N
Parent entitytce_users
Child entitytce_usrgroups

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
module_idusrgrp_user_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘rel_user_tests’

General info

Relationship typenon-identifyingCardinality1:N
Parent entitytce_users
Child entitytce_tests_users

Partiality

Parentmandatory
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-NONECASCADE
ChildNONENONE—-

Keys

Parent keyChild key
module_idtestuser_user_id

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No



Relationship ‘session_data’

General info

Relationship typeinformativeCardinality1:N
Parent entitytce_users
Child entitytce_sessions

Partiality

Parentoptional
Childoptional

Referential integrity

InsertUpdateDelete
Parent—-RESTRICTRESTRICT
ChildNONENONE—-

Keys

Parent keyChild key
module_id???

User-defined variables

NameValue
Match TypeDefault
Deferrable (Deferre constraint to the end of the transaction)No
Deferred (Check constraint at the end of the transaction)No

 

© 2004-2017 – Nicola Asuni - Tecnick.com - All rights reserved.
about - disclaimer - privacy