Changes between Initial Version and Version 1 of WebDBModel веб приказ на моделот

Timestamp:

10/27/10 16:35:08 (14 years ago)

Author:

Vangel Ajanovski

Comment:

—

WebDBModel веб приказ на моделот

@@ +1 @@
+{{{
+#!graphviz.dot
+digraph G { 
+
+node [ shape = "record" ]
+
+subgraph clusterEnrollment  {  n1207; n1270; n1262; n1654; bgcolor="gray90"; }
+subgraph clusterMain  {  n1008 n1019 n1027 n1049 n1057 n1064 n1077 n2085 n2096 bgcolor="gray90"; }
+subgraph clusterCurriculum { n1085 n1097 n1109 n1119 n1129 n1166 n1136 n1156 n1173 n1180 bgcolor="gray90";}
+subgraph clusterDocuments { n1575 n1570 n1663 n1671 n1680 n1692 n1607 n1622 n1629 n1645 n1581 n1597  bgcolor="gray90";}
+subgraph clusterAssessment { n1502 n1512 n1519 n1532 n1483 n1478 n1493 n1294 n1304 n1312 n1322 n1336 n1348  bgcolor="gray90";}
+subgraph clusterTerm { n1190 n1214 n1220 n1227 n1234 n1242 n1253 n1281 n2042 n2414 bgcolor="gray90";}
+
+n1008 [ label="{ institution| ♦institution_id\l  code\l  title\l  title_en\l  note\l* parent_institution_id\l* institution_type_id\l }"]
+n1019 [ label="{ institution_type| ♦institution_type_id\l  code\l  title\l  title_en\l  host_programs\l  note\l }"]
+n1027 [ label="{ person| ♦person_id\l  embg\l  first_name\l  middle_name\l  last_name\l  gender\l  birth_date\l  birth_place\l  birth_province\l  birth_country\l  nationality\l  residence_address\l  residence_place\l  residence_province\l  residence_country\l  phone_home\l  phone_mobile\l  email\l  picture\l  public_key\l  username\l }"]
+n1049 [ label="{ student| ♦student_id\l  status_2\l* institution_id\l* person_id\l }"]
+n1057 [ label="{ instructor| ♦instructor_id\l  from_date\l  to_date\l* person_id\l* institution_id\l }"]
+n1064 [ label="{ facility| ♦facility_id\l  code\l  title\l  title_en\l  note\l* parent_facility_id\l* institution_id\l* facility_type_id\l }"]
+n1077 [ label="{ facility_type| ♦facility_type_id\l  code\l  title\l  title_en\l  host_event\l  note\l }"]
+n1085 [ label="{ plan| ♦plan_id\l  code\l  title\l  title_en\l  start_term\l  end_term\l  note\l* institution_id\l }"]
+n1097 [ label="{ program| ♦program_id\l  code\l  title\l  title_en\l  terms\l  note\l* plan_id\l }"]
+n1109 [ label="{ degree| ♦degree_id\l  code\l  title\l  title_en\l  terms\l  note\l* institution_id\l }"]
+n1119 [ label="{ subject| ♦subject_id\l  code\l  title\l  title_en\l  abstract\l  note\l* institution_id\l }"]
+n1129 [ label="{ program_degree| ♦program_degree_id\l* program_id\l* degree_id\l }"]
+n1136 [ label="{ curriculum| ♦curriculum_id\l  term\l  term_ordinal\l  subject_title\l  lecture\l  tutorial\l  laboratory\l  instruction\l  individual\l  credits\l* program_id\l* subject_id\l* module_type_id\l* exam_type_id\l }"]
+n1156 [ label="{ curriculum_link| ♦curriculum_link_id\l* curriculum_id\l* link_type_id\l }"]
+n1166 [ label="{ link_type| ♦link_type_id\l  code\l  title\l  title_en\l  note\l }"]
+n1173 [ label="{ module_type| ♦module_type_id\l  code\l  title\l  title_en\l  note\l }"]
+n1180 [ label="{ exam_type| ♦exam_type_id\l  code\l  title\l  title_en\l  writen\l  oral\l  practical\l  note\l }"]
+n1190 [ label="{ curriculum_instruction| ♦curriculum_instruction_id\l  per_week\l  hours\l* instruction_type_id\l* curriculum_id\l }"]
+n1200 [ label="{ instruction_type| ♦instruction_type_id\l  code\l  title\l  title_en\l  note\l }"]
+n1207 [ label="{ program_enrollment| ♦program_enrollment_id\l* program_id\l* student_id\l }"]
+n1214 [ label="{ term| ♦term_id\l  term_year\l  term_from\l  term_to\l  note\l  belowminimum_credits\l  minimum_credits\l  maximum_credits\l* term_type_id\l* institution_id\l }"]
+n1220 [ label="{ term_program| ♦term_program_id\l* term_id\l* program_id\l }"]
+n1227 [ label="{ term_subject| ♦term_subject_id\l  enroll_deadline\l  cancel_deadline\l* subject_id\l* term_id\l }"]
+n1234 [ label="{ course| ♦course_id\l  url\l  moodle\l }"]
+n1242 [ label="{ course_curriculum| ♦course_curriculum_id\l  grade_allow\l* curriculum_link_id\l* course_id\l* term_program_id\l }"]
+n1253 [ label="{ course_instructor| ♦course_instructor_id\l* course_id\l* instructor_id\l }"]
+n1262 [ label="{ term_enrollment| ♦term_enrollment_id\l  enrollment_status\l  note\l* term_program_id\l* program_enrollment_id\l }"]
+n1270 [ label="{ course_enrollment| ♦course_enrollment_id\l  grade\l* subject_enrollment_id\l* course_curriculum_id\l }"]
+n1281 [ label="{ course_curriculum_instruction| ♦coursecurr_instruction_id\l* curriculum_instruction_id\l* course_curriculum_id\l* course_instructor_id\l }"]
+n1294 [ label="{ assessment| ♦assessment_id\l  grade\l  points\l  credit\l  description\l  note\l* assessment_type_id\l }"]
+n1304 [ label="{ student_assessment| ♦student_assessment_id\l* program_enrollment_id\l* assessment_id\l }"]
+n1312 [ label="{ curriculum_assessment| ♦curriculum_assessment_id\l* curriculum_link_id\l* student_assessment_id\l }"]
+n1322 [ label="{ course_assessment| ♦course_assessment_id\l* activity_assessment_id\l* curriculum_assessment_id\l* student_activity_id\l }"]
+n1336 [ label="{ student_activity| ♦student_activity_id\l* course_activity_id\l* course_enrollment_id\l }"]
+n1348 [ label="{ activity_type| ♦activity_type_id\l  code\l  title\l  title_en\l  note\l }"]
+n1355 [ label="{ schedule| ♦schedule_id\l* institution_id\l }"]
+n1361 [ label="{ formation| ♦formation_id\l* instruction_schedule_id\l }"]
+n1369 [ label="{ slot| ♦slot_id\l* schedule_id\l* facility_id\l }"]
+n1378 [ label="{ formation_student| ♦formation_student_id\l* formation_id\l* term_enrollment_id\l }"]
+n1388 [ label="{ event| ♦event_id\l* schedule_id\l* event_type_id\l }"]
+n1397 [ label="{ event_type| ♦event_type_id\l  code\l  title\l  title_en\l  note\l }"]
+n1404 [ label="{ event_formation| ♦event_formation_id\l* event_id\l* formation_id\l }"]
+n1413 [ label="{ event_slot| ♦event_slod_id\l* event_id\l* slot_id\l }"]
+n1422 [ label="{ subject_event| ♦subject_event_id\l* subject_id\l* event_id\l }"]
+n1430 [ label="{ instruction_schedule| ♦instruction_schedule_id\l* schedule_id\l* term_id\l }"]
+n1437 [ label="{ course_event| ♦course_event_id\l* course_id\l* instruction_event_id\l* subject_event_id\l }"]
+n1448 [ label="{ instruction_event| ♦instruction_event_id\l* event_id\l* instruction_schedule_id\l* instruction_type_id\l* instructor_id\l }"]
+n1460 [ label="{ session_schedule| ♦exam_session_schedule_id\l* exam_session_id\l* schedule_id\l }"]
+n1467 [ label="{ exam_event| ♦exam_event_id\l* exam_id\l* subject_event_id\l* exam_session_schedule_id\l }"]
+n1478 [ label="{ activity| ♦activity_id\l* activity_type_id\l }"]
+n1483 [ label="{ assessment_type| ♦assessment_type_id\l  code\l  title\l  title_en\l  grade\l  points\l  credit\l  note\l }"]
+n1493 [ label="{ course_activity| ♦course_activity_id\l* activity_id\l* course_id\l }"]
+n1502 [ label="{ exam| ♦exam_id\l* activity_id\l* exam_session_id\l* subject_id\l }"]
+n1512 [ label="{ exam_session| ♦exam_session_id\l* term_id\l }"]
+n1519 [ label="{ exam_application| ♦exam_application_id\l* exam_id\l* student_activity_id\l }"]
+n1532 [ label="{ activity_assessment| ♦activity_assessment_id\l* assessment_id\l* course_activity_id\l }"]
+n1542 [ label="{ country| ♦country_id\l  code\l  code_short\l  title\l  title_en\l }"]
+n1549 [ label="{ language| ♦language_id\l  code\l  title\l  title_en\l }"]
+n1555 [ label="{ country_language| ♦country_language_id\l  official\l* country_id\l* language_id\l }"]
+n1562 [ label="{ province| ♦province_id\l  code\l  title\l  title_en\l* country_id\l }"]
+n1570 [ label="{ payment_type| ♦payment_type_id\l  title\l  note\l }"]
+n1575 [ label="{ document_type| ♦document_type_id\l  title\l  title_en\l  note\l }"]
+n1581 [ label="{ account| ♦account_id\l  code\l  title\l  active\l  valid_from\l  valid_to\l  note\l* institution_id\l* payment_type_id\l* pay_institution_id\l }"]
+n1597 [ label="{ document_type_account| ♦document_type_account_id\l  active\l  valid_from\l  valid_to\l* document_type_id\l* account_id\l }"]
+n1607 [ label="{ document| ♦document_id\l  created\l  archive_number\l  doc_content\l  note\l  hash\l  signature\l* institution_id\l* document_type_id\l* author_person_id\l }"]
+n1622 [ label="{ document_student| ♦document_student_id\l* document_id\l* student_id\l }"]
+n1629 [ label="{ ledger| ♦ledger_id\l  state\l  created\l  effective\l  debit_amount\l  credit_amount\l  debit_point\l  credit_point\l* document_student_id\l* account_id\l }"]
+n1645 [ label="{ attachment| ♦attachment_id\l  note\l  attach_content\l* document_id\l }"]
+n1654 [ label="{ subject_enrollment| ♦subject_enrollment_id\l* termsubject_currlink_id\l* term_enrollment_id\l }"]
+n1663 [ label="{ document_program| ♦document_program_id\l* program_enrollment_id\l* document_student_id\l }"]
+n1671 [ label="{ document_term| ♦document_term_id\l* term_enrollment_id\l* document_program_id\l }"]
+n1680 [ label="{ document_course| ♦document_course_id\l* document_term_id\l* course_enrollment_id\l }"]
+n1692 [ label="{ ledger_link| ♦ledger_link_id\l  amount\l  points\l* ledger_id\l* link_ledger_id\l }"]
+n2042 [ label="{ term_subject_curriculum_link| ♦termsubject_currlink_id\l* curriculum_link_id\l* term_subject_id\l }"]
+n2085 [ label="{ staff| ♦staff_id\l  from_date\l  to_date\l* person_id\l* role_type_id\l* institution_id\l }"]
+n2096 [ label="{ role_type| ♦role_type_id\l  code\l  title\l  title_en\l  abstract\l  note\l }"]
+n2116 [ label="{ term_type| ♦term_type_id\l  code\l  title\l  title_en\l  abstract\l  note\l }"]
+n2414 [ label="{ course_term_subject_curriculum_link| * termsubject_currlink_id\l* course_id\l }"]
+n1008 -> n1008 [ len=0.1]
+n1008 -> n1019
+n1049 -> n1008
+n1049 -> n1027
+n1057 -> n1027
+n1064 -> n1008
+n1064 -> n1064
+n1064 -> n1077
+n1085 -> n1008
+n1097 -> n1085
+n1109 -> n1008
+n1119 -> n1008
+n1129 -> n1109
+n1129 -> n1097
+n1136 -> n1097
+n1136 -> n1119
+n1156 -> n1136
+n1156 -> n1136
+n1057 -> n1008
+n1156 -> n1166 [len 0.1]
+n1136 -> n1173
+n1136 -> n1180
+n1190 -> n1136
+n1190 -> n1200
+n1207 -> n1049
+n1207 -> n1097
+n1214 -> n1008
+n1220 -> n1214
+n1220 -> n1097
+n1227 -> n1214
+n1227 -> n1119
+n1242 -> n1234
+n1242 -> n1220
+n1242 -> n1156
+n1253 -> n1234
+n1253 -> n1057
+n1262 -> n1207
+n1262 -> n1220
+n1270 -> n1242
+n1281 -> n1242
+n1281 -> n1190
+n1281 -> n1253
+n1304 -> n1294
+n1304 -> n1207
+n1369 -> n1064
+n1378 -> n1262
+n1388 -> n1397 [ len=0.2]
+n1422 -> n1119
+n1355 -> n1008
+n1430 -> n1214
+n1361 -> n1430
+n1437 -> n1422
+n1437 -> n1234
+n1448 -> n1388
+n1437 -> n1448
+n1460 -> n1355
+n1448 -> n1200
+n1448 -> n1057
+n1467 -> n1422
+n1478 -> n1348
+n1294 -> n1483
+n1336 -> n1493
+n1502 -> n1119
+n1512 -> n1214
+n1502 -> n1512
+n1502 -> n1478
+n1532 -> n1294
+n1312 -> n1156
+n1532 -> n1493
+n1493 -> n1478
+n1493 -> n1234
+n1369 -> n1355
+n1448 -> n1430
+n1430 -> n1355
+n1388 -> n1355
+n1413 -> n1388
+n1413 -> n1369
+n1422 -> n1388
+n1404 -> n1388
+n1404 -> n1361
+n1378 -> n1361
+n1312 -> n1304
+n1322 -> n1312
+n1519 -> n1336
+n1336 -> n1270
+n1322 -> n1532
+n1322 -> n1336
+n1460 -> n1512
+n1467 -> n1460
+n1519 -> n1502
+n1467 -> n1502
+n1555 -> n1542
+n1555 -> n1549
+n1562 -> n1542
+n1581 -> n1008
+n1581 -> n1570
+n1581 -> n1008
+n1597 -> n1575
+n1597 -> n1581
+n1607 -> n1008
+n1622 -> n1049
+n1607 -> n1575
+n1622 -> n1607
+n1629 -> n1622
+n1629 -> n1581
+n1607 -> n1027
+n1645 -> n1607
+n1654 -> n1262
+n1270 -> n1654
+n1663 -> n1622
+n1663 -> n1207
+n1671 -> n1663
+n1671 -> n1262
+n1680 -> n1671
+n1680 -> n1270
+n1692 -> n1629
+n1692 -> n1629
+n2042 -> n1227
+n2042 -> n1156
+n1654 -> n2042
+n2085 -> n1008
+n2085 -> n2096 [len=0.1]
+n2085 -> n1027
+n1214 -> n2116 [len=0.1]
+n2414 -> n1234
+n2414 -> n2042
+
+}
+}}}