Changes between Version 37 and Version 38 of DBModel

Timestamp:

02/20/10 04:34:35 (15 years ago)

Author:

Vangel Ajanovski

Comment:

—

DBModel

@@ -21 +21 @@
 subgraph clusterCurriculum { n1085; n1097; n1109; n1119; n1129; n1166; n1136; n1156; n1173; n1180; bgcolor="gray90";}
 
-n1008 [ label="{ <<entity>>\linstitution| #institution_id\lcode\ltitle\ltitle_en\lnote\l*parent_institution_id\l*institution_type_id\l }"]
-n1019 [ label="{ <<entity>>\linstitution_type| #institution_type_id\lcode\ltitle\ltitle_en\lhost_programs\lnote\l }"]
-n1027 [ label="{ <<entity>>\lperson| #person_id\lembg\lfirst_name\lmiddle_name\llast_name\lgender\lbirth_date\lbirth_place\lbirth_province\lbirth_country\lnationality\lresidence_address\lresidence_place\lresidence_province\lresidence_country\lphone_home\lphone_mobile\lemail\lpicture\lpublic_key\lusername\l }"]
-n1049 [ label="{ <<entity>>\lstudent| #student_id\lstatus_2\l*institution_id\l*person_id\l }"]
-n1057 [ label="{ <<entity>>\linstructor| #instructor_id\lfrom_date\lto_date\l*person_id\l*institution_id\l }"]
-n1064 [ label="{ <<entity>>\lfacility| #facility_id\lcode\ltitle\ltitle_en\lnote\l*parent_facility_id\l*institution_id\l*facility_type_id\l }"]
-n1077 [ label="{ <<entity>>\lfacility_type| #facility_type_id\lcode\ltitle\ltitle_en\lhost_event\lnote\l }"]
-n1085 [ label="{ <<entity>>\lplan| #plan_id\lcode\ltitle\ltitle_en\lstart_term\lend_term\lnote\l*institution_id\l }"]
-n1097 [ label="{ <<entity>>\lprogram| #program_id\lcode\ltitle\ltitle_en\lterms\lnote\l*plan_id\l }"]
-n1109 [ label="{ <<entity>>\ldegree| #degree_id\lcode\ltitle\ltitle_en\lterms\lnote\l*institution_id\l }"]
-n1119 [ label="{ <<entity>>\lsubject| #subject_id\lcode\ltitle\ltitle_en\labstract\lnote\l*institution_id\l }"]
-n1129 [ label="{ <<entity>>\lprogram_degree| #program_degree_id\l*program_id\l*degree_id\l }"]
-n1136 [ label="{ <<entity>>\lcurriculum| #curriculum_id\lterm\lterm_ordinal\lsubject_title\llecture\ltutorial\llaboratory\linstruction\lindividual\lcredits\l*program_id\l*subject_id\l*module_type_id\l*exam_type_id\l }"]
-n1156 [ label="{ <<entity>>\lcurriculum_link| #curriculum_link_id\l*curriculum_id\l*link_type_id\l }"]
-n1166 [ label="{ <<entity>>\llink_type| #link_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1173 [ label="{ <<entity>>\lmodule_type| #module_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1180 [ label="{ <<entity>>\lexam_type| #exam_type_id\lcode\ltitle\ltitle_en\lwriten\loral\lpractical\lnote\l }"]
-n1190 [ label="{ <<entity>>\lcurriculum_instruction| #curriculum_instruction_id\lper_week\lhours\l*instruction_type_id\l*curriculum_id\l }"]
-n1200 [ label="{ <<entity>>\linstruction_type| #instruction_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1207 [ label="{ <<entity>>\lprogram_enrollment| #program_enrollment_id\l*program_id\l*student_id\l }"]
-n1214 [ label="{ <<entity>>\lterm| #term_id\lterm_year\lterm_from\lterm_to\lnote\lbelowminimum_credits\lminimum_credits\lmaximum_credits\l*term_type_id\l*institution_id\l }"]
-n1220 [ label="{ <<entity>>\lterm_program| #term_program_id\l*term_id\l*program_id\l }"]
-n1227 [ label="{ <<entity>>\lterm_subject| #term_subject_id\lenroll_deadline\lcancel_deadline\l*subject_id\l*term_id\l }"]
-n1234 [ label="{ <<entity>>\lcourse| #course_id\lurl\lmoodle\l }"]
-n1242 [ label="{ <<entity>>\lcourse_curriculum| #course_curriculum_id\lgrade_allow\l*curriculum_link_id\l*course_id\l*term_program_id\l }"]
-n1253 [ label="{ <<entity>>\lcourse_instructor| #course_instructor_id\l*course_id\l*instructor_id\l }"]
-n1262 [ label="{ <<entity>>\lterm_enrollment| #term_enrollment_id\lenrollment_status\lnote\l*term_program_id\l*program_enrollment_id\l }"]
-n1270 [ label="{ <<entity>>\lcourse_enrollment| #course_enrollment_id\lgrade\l*subject_enrollment_id\l*course_curriculum_id\l }"]
-n1281 [ label="{ <<entity>>\lcourse_curriculum_instruction| #coursecurr_instruction_id\l*curriculum_instruction_id\l*course_curriculum_id\l*course_instructor_id\l }"]
-n1294 [ label="{ <<entity>>\lassessment| #assessment_id\lgrade\lpoints\lcredit\ldescription\lnote\l*assessment_type_id\l }"]
-n1304 [ label="{ <<entity>>\lstudent_assessment| #student_assessment_id\l*program_enrollment_id\l*assessment_id\l }"]
-n1312 [ label="{ <<entity>>\lcurriculum_assessment| #curriculum_assessment_id\l*curriculum_link_id\l*student_assessment_id\l }"]
-n1322 [ label="{ <<entity>>\lcourse_assessment| #course_assessment_id\l*activity_assessment_id\l*curriculum_assessment_id\l*student_activity_id\l }"]
-n1336 [ label="{ <<entity>>\lstudent_activity| #student_activity_id\l*course_activity_id\l*course_enrollment_id\l }"]
-n1348 [ label="{ <<entity>>\lactivity_type| #activity_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1355 [ label="{ <<entity>>\lschedule| #schedule_id\l*institution_id\l }"]
-n1361 [ label="{ <<entity>>\lformation| #formation_id\l*instruction_schedule_id\l }"]
-n1369 [ label="{ <<entity>>\lslot| #slot_id\l*schedule_id\l*facility_id\l }"]
-n1378 [ label="{ <<entity>>\lformation_student| #formation_student_id\l*formation_id\l*term_enrollment_id\l }"]
-n1388 [ label="{ <<entity>>\levent| #event_id\l*schedule_id\l*event_type_id\l }"]
-n1397 [ label="{ <<entity>>\levent_type| #event_type_id\lcode\ltitle\ltitle_en\lnote\l }"]
-n1404 [ label="{ <<entity>>\levent_formation| #event_formation_id\l*event_id\l*formation_id\l }"]
-n1413 [ label="{ <<entity>>\levent_slot| #event_slod_id\l*event_id\l*slot_id\l }"]
-n1422 [ label="{ <<entity>>\lsubject_event| #subject_event_id\l*subject_id\l*event_id\l }"]
-n1430 [ label="{ <<entity>>\linstruction_schedule| #instruction_schedule_id\l*schedule_id\l*term_id\l }"]
-n1437 [ label="{ <<entity>>\lcourse_event| #course_event_id\l*course_id\l*instruction_event_id\l*subject_event_id\l }"]
-n1448 [ label="{ <<entity>>\linstruction_event| #instruction_event_id\l*event_id\l*instruction_schedule_id\l*instruction_type_id\l*instructor_id\l }"]
-n1460 [ label="{ <<entity>>\lsession_schedule| #exam_session_schedule_id\l*exam_session_id\l*schedule_id\l }"]
-n1467 [ label="{ <<entity>>\lexam_event| #exam_event_id\l*exam_id\l*subject_event_id\l*exam_session_schedule_id\l }"]
-n1478 [ label="{ <<entity>>\lactivity| #activity_id\l*activity_type_id\l }"]
-n1483 [ label="{ <<entity>>\lassessment_type| #assessment_type_id\lcode\ltitle\ltitle_en\lgrade\lpoints\lcredit\lnote\l }"]
-n1493 [ label="{ <<entity>>\lcourse_activity| #course_activity_id\l*activity_id\l*course_id\l }"]
-n1502 [ label="{ <<entity>>\lexam| #exam_id\l*activity_id\l*exam_session_id\l*subject_id\l }"]
-n1512 [ label="{ <<entity>>\lexam_session| #exam_session_id\l*term_id\l }"]
-n1519 [ label="{ <<entity>>\lexam_application| #exam_application_id\l*exam_id\l*student_activity_id\l }"]
-n1532 [ label="{ <<entity>>\lactivity_assessment| #activity_assessment_id\l*assessment_id\l*course_activity_id\l }"]
-n1542 [ label="{ <<entity>>\lcountry| #country_id\lcode\lcode_short\ltitle\ltitle_en\l }"]
-n1549 [ label="{ <<entity>>\llanguage| #language_id\lcode\ltitle\ltitle_en\l }"]
-n1555 [ label="{ <<entity>>\lcountry_language| #country_language_id\lofficial\l*country_id\l*language_id\l }"]
-n1562 [ label="{ <<entity>>\lprovince| #province_id\lcode\ltitle\ltitle_en\l*country_id\l }"]
-n1570 [ label="{ <<entity>>\lpayment_type| #payment_type_id\ltitle\lnote\l }"]
-n1575 [ label="{ <<entity>>\ldocument_type| #document_type_id\ltitle\ltitle_en\lnote\l }"]
-n1581 [ label="{ <<entity>>\laccount| #account_id\lcode\ltitle\lactive\lvalid_from\lvalid_to\lnote\l*institution_id\l*payment_type_id\l*pay_institution_id\l }"]
-n1597 [ label="{ <<entity>>\ldocument_type_account| #document_type_account_id\lactive\lvalid_from\lvalid_to\l*document_type_id\l*account_id\l }"]
-n1607 [ label="{ <<entity>>\ldocument| #document_id\lcreated\larchive_number\ldoc_content\lnote\lhash\lsignature\l*institution_id\l*document_type_id\l*author_person_id\l }"]
-n1622 [ label="{ <<entity>>\ldocument_student| #document_student_id\l*document_id\l*student_id\l }"]
-n1629 [ label="{ <<entity>>\lledger| #ledger_id\lstate\lcreated\leffective\ldebit_amount\lcredit_amount\ldebit_point\lcredit_point\l*document_student_id\l*account_id\l }"]
-n1645 [ label="{ <<entity>>\lattachment| #attachment_id\lnote\lattach_content\l*document_id\l }"]
-n1654 [ label="{ <<entity>>\lsubject_enrollment| #subject_enrollment_id\l*termsubject_currlink_id\l*term_enrollment_id\l }"]
-n1663 [ label="{ <<entity>>\ldocument_program| #document_program_id\l*program_enrollment_id\l*document_student_id\l }"]
-n1671 [ label="{ <<entity>>\ldocument_term| #document_term_id\l*term_enrollment_id\l*document_program_id\l }"]
-n1680 [ label="{ <<entity>>\ldocument_course| #document_course_id\l*document_term_id\l*course_enrollment_id\l }"]
-n1692 [ label="{ <<entity>>\lledger_link| #ledger_link_id\lamount\lpoints\l*ledger_id\l*link_ledger_id\l }"]
-n2042 [ label="{ <<entity>>\lterm_subject_curriculum_link| #termsubject_currlink_id\l*curriculum_link_id\l*term_subject_id\l }"]
-n2085 [ label="{ <<entity>>\lstaff| #staff_id\lfrom_date\lto_date\l*person_id\l*role_type_id\l*institution_id\l }"]
-n2096 [ label="{ <<entity>>\lrole_type| #role_type_id\lcode\ltitle\ltitle_en\labstract\lnote\l }"]
-n2116 [ label="{ <<entity>>\lterm_type| #term_type_id\lcode\ltitle\ltitle_en\labstract\lnote\l }"]
-n2414 [ label="{ <<entity>>\lcourse_term_subject_curriculum_link| *termsubject_currlink_id\l*course_id\l }"]
+n1008 [ label="{ institution| ♦institution_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;note\l*&nbsp;parent_institution_id\l*&nbsp;institution_type_id\l }"]
+n1019 [ label="{ institution_type| ♦institution_type_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;host_programs\l&nbsp;&nbsp;note\l }"]
+n1027 [ label="{ person| ♦person_id\l&nbsp;&nbsp;embg\l&nbsp;&nbsp;first_name\l&nbsp;&nbsp;middle_name\l&nbsp;&nbsp;last_name\l&nbsp;&nbsp;gender\l&nbsp;&nbsp;birth_date\l&nbsp;&nbsp;birth_place\l&nbsp;&nbsp;birth_province\l&nbsp;&nbsp;birth_country\l&nbsp;&nbsp;nationality\l&nbsp;&nbsp;residence_address\l&nbsp;&nbsp;residence_place\l&nbsp;&nbsp;residence_province\l&nbsp;&nbsp;residence_country\l&nbsp;&nbsp;phone_home\l&nbsp;&nbsp;phone_mobile\l&nbsp;&nbsp;email\l&nbsp;&nbsp;picture\l&nbsp;&nbsp;public_key\l&nbsp;&nbsp;username\l }"]
+n1049 [ label="{ student| ♦student_id\l&nbsp;&nbsp;status_2\l*&nbsp;institution_id\l*&nbsp;person_id\l }"]
+n1057 [ label="{ instructor| ♦instructor_id\l&nbsp;&nbsp;from_date\l&nbsp;&nbsp;to_date\l*&nbsp;person_id\l*&nbsp;institution_id\l }"]
+n1064 [ label="{ facility| ♦facility_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;note\l*&nbsp;parent_facility_id\l*&nbsp;institution_id\l*&nbsp;facility_type_id\l }"]
+n1077 [ label="{ facility_type| ♦facility_type_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;host_event\l&nbsp;&nbsp;note\l }"]
+n1085 [ label="{ plan| ♦plan_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;start_term\l&nbsp;&nbsp;end_term\l&nbsp;&nbsp;note\l*&nbsp;institution_id\l }"]
+n1097 [ label="{ program| ♦program_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;terms\l&nbsp;&nbsp;note\l*&nbsp;plan_id\l }"]
+n1109 [ label="{ degree| ♦degree_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;terms\l&nbsp;&nbsp;note\l*&nbsp;institution_id\l }"]
+n1119 [ label="{ subject| ♦subject_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;abstract\l&nbsp;&nbsp;note\l*&nbsp;institution_id\l }"]
+n1129 [ label="{ program_degree| ♦program_degree_id\l*&nbsp;program_id\l*&nbsp;degree_id\l }"]
+n1136 [ label="{ curriculum| ♦curriculum_id\l&nbsp;&nbsp;term\l&nbsp;&nbsp;term_ordinal\l&nbsp;&nbsp;subject_title\l&nbsp;&nbsp;lecture\l&nbsp;&nbsp;tutorial\l&nbsp;&nbsp;laboratory\l&nbsp;&nbsp;instruction\l&nbsp;&nbsp;individual\l&nbsp;&nbsp;credits\l*&nbsp;program_id\l*&nbsp;subject_id\l*&nbsp;module_type_id\l*&nbsp;exam_type_id\l }"]
+n1156 [ label="{ curriculum_link| ♦curriculum_link_id\l*&nbsp;curriculum_id\l*&nbsp;link_type_id\l }"]
+n1166 [ label="{ link_type| ♦link_type_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;note\l }"]
+n1173 [ label="{ module_type| ♦module_type_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;note\l }"]
+n1180 [ label="{ exam_type| ♦exam_type_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;writen\l&nbsp;&nbsp;oral\l&nbsp;&nbsp;practical\l&nbsp;&nbsp;note\l }"]
+n1190 [ label="{ curriculum_instruction| ♦curriculum_instruction_id\l&nbsp;&nbsp;per_week\l&nbsp;&nbsp;hours\l*&nbsp;instruction_type_id\l*&nbsp;curriculum_id\l }"]
+n1200 [ label="{ instruction_type| ♦instruction_type_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;note\l }"]
+n1207 [ label="{ program_enrollment| ♦program_enrollment_id\l*&nbsp;program_id\l*&nbsp;student_id\l }"]
+n1214 [ label="{ term| ♦term_id\l&nbsp;&nbsp;term_year\l&nbsp;&nbsp;term_from\l&nbsp;&nbsp;term_to\l&nbsp;&nbsp;note\l&nbsp;&nbsp;belowminimum_credits\l&nbsp;&nbsp;minimum_credits\l&nbsp;&nbsp;maximum_credits\l*&nbsp;term_type_id\l*&nbsp;institution_id\l }"]
+n1220 [ label="{ term_program| ♦term_program_id\l*&nbsp;term_id\l*&nbsp;program_id\l }"]
+n1227 [ label="{ term_subject| ♦term_subject_id\l&nbsp;&nbsp;enroll_deadline\l&nbsp;&nbsp;cancel_deadline\l*&nbsp;subject_id\l*&nbsp;term_id\l }"]
+n1234 [ label="{ course| ♦course_id\l&nbsp;&nbsp;url\l&nbsp;&nbsp;moodle\l }"]
+n1242 [ label="{ course_curriculum| ♦course_curriculum_id\l&nbsp;&nbsp;grade_allow\l*&nbsp;curriculum_link_id\l*&nbsp;course_id\l*&nbsp;term_program_id\l }"]
+n1253 [ label="{ course_instructor| ♦course_instructor_id\l*&nbsp;course_id\l*&nbsp;instructor_id\l }"]
+n1262 [ label="{ term_enrollment| ♦term_enrollment_id\l&nbsp;&nbsp;enrollment_status\l&nbsp;&nbsp;note\l*&nbsp;term_program_id\l*&nbsp;program_enrollment_id\l }"]
+n1270 [ label="{ course_enrollment| ♦course_enrollment_id\l&nbsp;&nbsp;grade\l*&nbsp;subject_enrollment_id\l*&nbsp;course_curriculum_id\l }"]
+n1281 [ label="{ course_curriculum_instruction| ♦coursecurr_instruction_id\l*&nbsp;curriculum_instruction_id\l*&nbsp;course_curriculum_id\l*&nbsp;course_instructor_id\l }"]
+n1294 [ label="{ assessment| ♦assessment_id\l&nbsp;&nbsp;grade\l&nbsp;&nbsp;points\l&nbsp;&nbsp;credit\l&nbsp;&nbsp;description\l&nbsp;&nbsp;note\l*&nbsp;assessment_type_id\l }"]
+n1304 [ label="{ student_assessment| ♦student_assessment_id\l*&nbsp;program_enrollment_id\l*&nbsp;assessment_id\l }"]
+n1312 [ label="{ curriculum_assessment| ♦curriculum_assessment_id\l*&nbsp;curriculum_link_id\l*&nbsp;student_assessment_id\l }"]
+n1322 [ label="{ course_assessment| ♦course_assessment_id\l*&nbsp;activity_assessment_id\l*&nbsp;curriculum_assessment_id\l*&nbsp;student_activity_id\l }"]
+n1336 [ label="{ student_activity| ♦student_activity_id\l*&nbsp;course_activity_id\l*&nbsp;course_enrollment_id\l }"]
+n1348 [ label="{ activity_type| ♦activity_type_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;note\l }"]
+n1355 [ label="{ schedule| ♦schedule_id\l*&nbsp;institution_id\l }"]
+n1361 [ label="{ formation| ♦formation_id\l*&nbsp;instruction_schedule_id\l }"]
+n1369 [ label="{ slot| ♦slot_id\l*&nbsp;schedule_id\l*&nbsp;facility_id\l }"]
+n1378 [ label="{ formation_student| ♦formation_student_id\l*&nbsp;formation_id\l*&nbsp;term_enrollment_id\l }"]
+n1388 [ label="{ event| ♦event_id\l*&nbsp;schedule_id\l*&nbsp;event_type_id\l }"]
+n1397 [ label="{ event_type| ♦event_type_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;note\l }"]
+n1404 [ label="{ event_formation| ♦event_formation_id\l*&nbsp;event_id\l*&nbsp;formation_id\l }"]
+n1413 [ label="{ event_slot| ♦event_slod_id\l*&nbsp;event_id\l*&nbsp;slot_id\l }"]
+n1422 [ label="{ subject_event| ♦subject_event_id\l*&nbsp;subject_id\l*&nbsp;event_id\l }"]
+n1430 [ label="{ instruction_schedule| ♦instruction_schedule_id\l*&nbsp;schedule_id\l*&nbsp;term_id\l }"]
+n1437 [ label="{ course_event| ♦course_event_id\l*&nbsp;course_id\l*&nbsp;instruction_event_id\l*&nbsp;subject_event_id\l }"]
+n1448 [ label="{ instruction_event| ♦instruction_event_id\l*&nbsp;event_id\l*&nbsp;instruction_schedule_id\l*&nbsp;instruction_type_id\l*&nbsp;instructor_id\l }"]
+n1460 [ label="{ session_schedule| ♦exam_session_schedule_id\l*&nbsp;exam_session_id\l*&nbsp;schedule_id\l }"]
+n1467 [ label="{ exam_event| ♦exam_event_id\l*&nbsp;exam_id\l*&nbsp;subject_event_id\l*&nbsp;exam_session_schedule_id\l }"]
+n1478 [ label="{ activity| ♦activity_id\l*&nbsp;activity_type_id\l }"]
+n1483 [ label="{ assessment_type| ♦assessment_type_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;grade\l&nbsp;&nbsp;points\l&nbsp;&nbsp;credit\l&nbsp;&nbsp;note\l }"]
+n1493 [ label="{ course_activity| ♦course_activity_id\l*&nbsp;activity_id\l*&nbsp;course_id\l }"]
+n1502 [ label="{ exam| ♦exam_id\l*&nbsp;activity_id\l*&nbsp;exam_session_id\l*&nbsp;subject_id\l }"]
+n1512 [ label="{ exam_session| ♦exam_session_id\l*&nbsp;term_id\l }"]
+n1519 [ label="{ exam_application| ♦exam_application_id\l*&nbsp;exam_id\l*&nbsp;student_activity_id\l }"]
+n1532 [ label="{ activity_assessment| ♦activity_assessment_id\l*&nbsp;assessment_id\l*&nbsp;course_activity_id\l }"]
+n1542 [ label="{ country| ♦country_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;code_short\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l }"]
+n1549 [ label="{ language| ♦language_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l }"]
+n1555 [ label="{ country_language| ♦country_language_id\l&nbsp;&nbsp;official\l*&nbsp;country_id\l*&nbsp;language_id\l }"]
+n1562 [ label="{ province| ♦province_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l*&nbsp;country_id\l }"]
+n1570 [ label="{ payment_type| ♦payment_type_id\l&nbsp;&nbsp;title\l&nbsp;&nbsp;note\l }"]
+n1575 [ label="{ document_type| ♦document_type_id\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;note\l }"]
+n1581 [ label="{ account| ♦account_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;active\l&nbsp;&nbsp;valid_from\l&nbsp;&nbsp;valid_to\l&nbsp;&nbsp;note\l*&nbsp;institution_id\l*&nbsp;payment_type_id\l*&nbsp;pay_institution_id\l }"]
+n1597 [ label="{ document_type_account| ♦document_type_account_id\l&nbsp;&nbsp;active\l&nbsp;&nbsp;valid_from\l&nbsp;&nbsp;valid_to\l*&nbsp;document_type_id\l*&nbsp;account_id\l }"]
+n1607 [ label="{ document| ♦document_id\l&nbsp;&nbsp;created\l&nbsp;&nbsp;archive_number\l&nbsp;&nbsp;doc_content\l&nbsp;&nbsp;note\l&nbsp;&nbsp;hash\l&nbsp;&nbsp;signature\l*&nbsp;institution_id\l*&nbsp;document_type_id\l*&nbsp;author_person_id\l }"]
+n1622 [ label="{ document_student| ♦document_student_id\l*&nbsp;document_id\l*&nbsp;student_id\l }"]
+n1629 [ label="{ ledger| ♦ledger_id\l&nbsp;&nbsp;state\l&nbsp;&nbsp;created\l&nbsp;&nbsp;effective\l&nbsp;&nbsp;debit_amount\l&nbsp;&nbsp;credit_amount\l&nbsp;&nbsp;debit_point\l&nbsp;&nbsp;credit_point\l*&nbsp;document_student_id\l*&nbsp;account_id\l }"]
+n1645 [ label="{ attachment| ♦attachment_id\l&nbsp;&nbsp;note\l&nbsp;&nbsp;attach_content\l*&nbsp;document_id\l }"]
+n1654 [ label="{ subject_enrollment| ♦subject_enrollment_id\l*&nbsp;termsubject_currlink_id\l*&nbsp;term_enrollment_id\l }"]
+n1663 [ label="{ document_program| ♦document_program_id\l*&nbsp;program_enrollment_id\l*&nbsp;document_student_id\l }"]
+n1671 [ label="{ document_term| ♦document_term_id\l*&nbsp;term_enrollment_id\l*&nbsp;document_program_id\l }"]
+n1680 [ label="{ document_course| ♦document_course_id\l*&nbsp;document_term_id\l*&nbsp;course_enrollment_id\l }"]
+n1692 [ label="{ ledger_link| ♦ledger_link_id\l&nbsp;&nbsp;amount\l&nbsp;&nbsp;points\l*&nbsp;ledger_id\l*&nbsp;link_ledger_id\l }"]
+n2042 [ label="{ term_subject_curriculum_link| ♦termsubject_currlink_id\l*&nbsp;curriculum_link_id\l*&nbsp;term_subject_id\l }"]
+n2085 [ label="{ staff| ♦staff_id\l&nbsp;&nbsp;from_date\l&nbsp;&nbsp;to_date\l*&nbsp;person_id\l*&nbsp;role_type_id\l*&nbsp;institution_id\l }"]
+n2096 [ label="{ role_type| ♦role_type_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;abstract\l&nbsp;&nbsp;note\l }"]
+n2116 [ label="{ term_type| ♦term_type_id\l&nbsp;&nbsp;code\l&nbsp;&nbsp;title\l&nbsp;&nbsp;title_en\l&nbsp;&nbsp;abstract\l&nbsp;&nbsp;note\l }"]
+n2414 [ label="{ course_term_subject_curriculum_link| *&nbsp;termsubject_currlink_id\l*&nbsp;course_id\l }"]
 n1008 -> n1008
 n1008 -> n1019
@@ -225 +225 @@
 n2414 -> n1234
 n2414 -> n2042
+
+
+
 }
 }}}