Database Properties
Database Type: Oracle - Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options
Tables
Table / View | Children | Parents | Columns | Rows | Type | Comments |
---|---|---|---|---|---|---|
TRAINING_FACILITY_DOCUMENT | 0 | 3 | 9 | 237 | Table | This is a table for Training Facility with Documents. Stores the relation between of Documents and the Training Facility. |
MET_PROGRAMM | 4 | 5 | 16 | 1855 | Table | This is a table for Met Programms. Stores Structure of the courses in Met Institution. |
RECOGNISED_COUNTRY | 0 | 3 | 10 | 524 | Table | This is a table for Recognised Countries. Stores Countries that recognize other countries. |
PROCESS_PROCESS_COLLECTION | 0 | 2 | 8 | 121 | Table | This is a table for Process with Collection of Process. Stores Assignment of multiple processes to a collection. |
CERT_ENDORSEMENT_DOCUMENT | 0 | 3 | 9 | 5 | Table | This is a table for Certificates and Endorsements with Documents. Stores the relation between certificates and documents. |
QUALITY_SYSTEM_DOCUMENT | 0 | 3 | 9 | 134 | Table | This is a table for Quality System with Documents. Stores Documents that certificate the Quality Standart System. |
COUNTRY | 48 | 5 | 18 | 249 | Table | This is a table for Country. Stores countries and their information. |
PROCESS | 12 | 2 | 12 | 120 | Table | This is a table for Process. Stores Inspection Processes. |
FINDING | 10 | 4 | 16 | 2643 | Table | This is a table for Finding. Stores Inspection findings. |
DOCUMENT | 14 | 0 | 11 | 1052 | Table | This is a table for Documents. Stores Documents/Files for all needed tables. Save BLOB binary, content type, extension and other information. |
TRAINING_FACILITY | 1 | 2 | 10 | 1932 | Table | This is a table for Training Facility. Stores Training Facilities of a Met Institution. |
ENUM_COUNTRY_GROUP | 1 | 0 | 8 | 3 | Table | This is a table for Country Group enumeration. Stores Group that the country belong. |
DISPENSATION | 0 | 3 | 11 | 292 | Table | This is a table for Dispensations. Stores list of Dispensations issued by the country. |
INSPECTION | 15 | 3 | 14 | 122 | Table | This is a table for Inspections. Stores Inspections. |
ENUM_ACTION_TAKEN | 1 | 0 | 8 | 5 | Table | This is a table for Action Taken enumeration. Stores Type of Action in the Fraudulent Certificate. |
COUNTRY_EXTERNAL_LINK | 0 | 2 | 11 | 91 | Table | This is a table for Country External Link. Stores External links relating to more info about each country. |
PROCESS_ENUM_LEGAL_ENTITY | 0 | 3 | 9 | 52 | Table | This is a table for Process with Legal Entity enumeration. Stores Type of Legal Entity in a Process. |
LEGAL_REQUIREMENT_PROCESS | 1 | 2 | 8 | 4896 | Table | This is a table for Legal Requirements with Processes. Stores Legal requirements of a Process. |
INSPECTION_LEGAL_ENTITY | 1 | 2 | 8 | 411 | Table | This is a table for Inspection with Legal Entity. Stores wich Entities are inspected in a Inspection. |
LEGAL_DOCUMENT | 2 | 2 | 11 | 33 | Table | This is a table for Legal Documents. Stores Legal documents. |
CERTIFICATE_ENDORSEMENT | 1 | 6 | 14 | 549 | Table | This is a table for Certificates and Endorsements. Stores the Certificates of a Entity. |
ENUM_TIMEZONE | 1 | 0 | 8 | 598 | Table | This is a table for Timezone enumeration. Stores Timezone of the countries. |
ENUM_STATUS | 24 | 1 | 9 | 6 | Table | This is a table for Status enumeration. Stores Status of the Countries, Entities and Legal Documents. |
ENUM_CURRENCY | 1 | 0 | 8 | 157 | Table | This is a table for Currency enumeration. Stores Currency used in the country. |
ENUM_CERTIFICATE_TYPE | 2 | 0 | 9 | 7 | Table | This is a table for Certificate Type enumeration. Stores Type of the Certificate in the Fraudulent Certificate. |
ENUM_LEGAL_ENTITY | 4 | 0 | 8 | 4 | Table | This is a table for Legal Entity enumeration. Stores Type of Entities. |
ENUM_UNIT | 1 | 0 | 8 | 6 | Table | This is a table for Unit enumeration. Stores Units for Met Programs. |
ENUM_FACILITY_TYPE | 1 | 0 | 8 | 11 | Table | This is a table for Facility Type enumeration. Stores Type of Training. |
LEGAL_REQUIREMENT | 12 | 4 | 14 | 2089 | Table | This is a table for Legal Requirements. Stores Legal requirements of a document. |
PROCESS_COLLECTION | 3 | 2 | 12 | 37 | Table | This is a table for Collection of Process. Stores Collection of Processes. |
FRAUDULENT_CERTIFICATE | 1 | 7 | 18 | 93 | Table | This is a table for Fraudulent Certificate. Stores Fraudulent Certificates issued by the Administration Authorities of the country. |
LEGAL_ENTITY | 17 | 3 | 26 | 622 | Table | This is a table for Legal Entities. Stores Administration entities and Met Instituions of a country. |
LEGISLATION | 0 | 2 | 10 | 325 | Table | This is a table for Legislation. Stores the legislation of a country. |
STCW_REFERENCE | 12 | 1 | 11 | 76 | Table | This is a table for Stcw References. Stores Certificates of competency for officers according with STCW convention. |
STUDENT | 0 | 2 | 12 | 1227 | Table | This is a table for Students. Stores Number of admitted and graduated students per MET Program. |
ENUM_FRAUD_TYPE | 1 | 0 | 8 | 9 | Table | This is a table for Fraud Type enumeration. Stores Type of Fraudulent Certificate. |
MET_PROGRAMM_DOCUMENT | 0 | 3 | 9 | 35 | Table | This is a table for Met Programms with Documents. Stores the relation between the documents and the programms. |
ENUM_STCW_REFERENCE_TYPE | 1 | 0 | 8 | 19 | Table | This is a table for Stcw Reference Type enumeration. Stores type of Certificates of competency. |
ENUM_FINDING_TYPE | 1 | 0 | 8 | 2 | Table | This is a table for Finding Type enumeration. Stores Type of each inspection findings. |
STRUCTURE | 0 | 1 | 14 | 235 | Table | This is a table for Structure. Stores Structure of Met Institutions(area, departments, persons, etc..). |
ENUM_RECORD_TYPE | 1 | 0 | 8 | 2 | Table | This is a table for Record Type enumeration. Stores type of the records for Status table. |
LEGAL_ENTITY_DOCUMENT | 0 | 3 | 9 | 16 | Table | This is a table for Legal Entities Documents. Stores Administration entities and Met Instituions with documents. |
LEGAL_REQUIREMENT_TYPE | 1 | 0 | 3 | 0 | Table | This is a table for Legal Requirements Types. Stores Type of the legal requirement. |
METC_SYSTEM | 0 | 3 | 10 | 81 | Table | This is a table for Metc System. Stores Metc System of a country. |
QUALITY_SYSTEM | 1 | 1 | 12 | 205 | Table | This is a table for Quality System. Stores Quality Certification of MET Entity and Administration Entity. |
FINDING_LEGAL_REQUIREMENT | 0 | 2 | 8 | 63 | Table | This is a table for Finding Legal Requirement. Stores Relation between a finding and its legal requirement. |
FRAUDULENT_CERTIFICATE_DOC | 0 | 3 | 9 | 3 | Table | This is a table for Fraudulent Certificate Documents. Stores relation between Fraudulent Certificates and Documents. |
LEGAL_REQUIREMENT_ASSOCIATION | 0 | 2 | 3 | 0 | Table | This is a table for Legal Requirements with Associations. Stores Association of a legal requirement with another one. |
LEGAL_REQUIREMENT_CORRELATION | 0 | 2 | 8 | 906 | Table | This is a table for Legal Requirements with Correlations. Stores Correlation of a legal requirement with another one. |
ENUM_METHOD_DETECTION | 1 | 0 | 8 | 4 | Table | This is a table for Method of Detection enumeration. Stores Method used in the Detection of a Fraudulent Certificate. |
INSPECTION_TEAM | 0 | 2 | 8 | 267 | Table | This is a table for Inspection with Team. Stores wich Team makes the Inspection. |
TEAM | 1 | 0 | 8 | 15 | Table | This is a table for Teams. Stores List of users that belong to an inspection team. |
VIEW_STATISTICS_MET_PROGRAMANS | 0 | 3 | 13 | 0 | View | |
FINDINGS_DIRECT_VIEW | 0 | 1 | 20 | 0 | View | |
VIEW_LEGAL_REQUIREMENT | 0 | 1 | 10 | 0 | View | |
VIEW_STATISTICS_COUNT_FIND_LR | 0 | 2 | 16 | 0 | View | |
VIEW_LEGAL_DOCUMENT | 0 | 3 | 8 | 0 | View | |
VIEW_ADMIN_CERTIFICATES | 0 | 1 | 14 | 0 | View | |
VIEW_MET_STRUCTURE | 0 | 0 | 17 | 0 | View | |
VIEW_CERTIFICATE_MATRIX_INT | 0 | 2 | 9 | 0 | View | |
FINDINGS_CORRELATED_VIEW | 0 | 1 | 20 | 0 | View | |
FINDINGS_BASE_VIEW | 0 | 1 | 14 | 0 | View | |
VIEW_LEGAL_REQUIREMENT_AUX | 0 | 1 | 6 | 0 | View | |
FINDINGS_TOTAL_DIRECT_VIEW | 0 | 1 | 22 | 0 | View | |
VIEW_INSPECTIONS_ENTITY | 0 | 2 | 19 | 0 | View | |
VIEW_STATISTICS_ALL_P | 0 | 4 | 20 | 0 | View | |
VIEW_MET_QUALITY_SYSTEMS | 0 | 1 | 12 | 0 | View | |
VIEW_RECOGNISED_COUNTRY | 0 | 1 | 8 | 0 | View | |
VIEW_STATISTICS_ALL_LR | 0 | 2 | 11 | 0 | View | |
FINDINGS_TOTAL_CORRELATED_VIEW | 0 | 1 | 22 | 0 | View | |
VIEW_MET_PROGRAMANS | 0 | 2 | 29 | 0 | View | |
VIEW_STATISTICS_FINDING_AUX | 0 | 6 | 22 | 0 | View | |
VIEW_STAT_COUNT_LR | 0 | 1 | 24 | 0 | View | |
VIEW_COUNTRY | 0 | 0 | 11 | 0 | View | |
VIEW_LEGISLATION | 0 | 1 | 7 | 0 | View | |
VIEW_FINDINGS | 0 | 2 | 16 | 0 | View | |
VIEW_CERTIFICATE_MATRIX | 0 | 2 | 11 | 0 | View | |
VIEW_STAT_COUNT_DIRECT | 0 | 2 | 20 | 0 | View | |
VIEW_MET_STUDENTS | 0 | 2 | 29 | 0 | View | |
VIEW_STATISTICS_ALL_FINDING_P | 0 | 3 | 18 | 0 | View | |
VIEW_INSPECTIONS_TEAM | 0 | 1 | 2 | 0 | View | |
VIEW_FRAUDULENT_CERTIFICATES | 0 | 1 | 17 | 0 | View | |
VIEW_ADMIN_QUALITY_SYSTEMS | 0 | 1 | 12 | 0 | View | |
VIEW_INSPECTIONS_LEGAL_ENTITY | 0 | 1 | 3 | 0 | View | |
VIEW_FINAL_STAT_COUNT_LR_NEW | 0 | 1 | 18 | 0 | View | |
VIEW_INSPECTIONS | 0 | 2 | 16 | 0 | View | |
NEW_STAT_COUNT_BASE_1 | 0 | 2 | 18 | 0 | View | |
VIEW_BUSINESS_STU_PROGR | 0 | 2 | 9 | 0 | View | |
VIEW_FINAL_STAT_COUNT_P | 0 | 2 | 17 | 0 | View | |
VIEW_COUNT_MET_PROGRAMANS | 0 | 3 | 22 | 0 | View | |
VIEW_ADMIN_STRUCTURE | 0 | 1 | 20 | 0 | View | |
VIEW_METS | 0 | 1 | 17 | 0 | View | |
VIEW_FINAL_STAT_COUNT_LR | 0 | 1 | 24 | 0 | View | |
NEW_STAT_COUNT_BASE_4 | 0 | 2 | 22 | 0 | View | |
NEW_STAT_COUNT_BASE_5 | 0 | 1 | 22 | 0 | View | |
NEW_STAT_COUNT_BASE_2 | 0 | 2 | 18 | 0 | View | |
NEW_STAT_COUNT_BASE_3 | 0 | 2 | 22 | 0 | View | |
VIEW_ADMINISTRATIONS | 0 | 1 | 17 | 0 | View | |
NEW_STAT_COUNT_BASE_6 | 0 | 1 | 17 | 0 | View | |
VIEW_PROCESS | 0 | 1 | 11 | 0 | View | |
NEW_STAT_COUNT_BASE | 0 | 3 | 19 | 0 | View | |
VIEW_BUSINESS_STUDENTS | 0 | 2 | 8 | 0 | View | |
VIEW_FINDING_AUX | 0 | 6 | 20 | 0 | View | |
VIEW_STATISTICS_ALL_FINDING_LR | 0 | 2 | 17 | 0 | View | |
VIEW_INSPECTION_FINDING | 0 | 6 | 26 | 0 | View | |
VIEW_COLLECTIONS | 0 | 1 | 18 | 0 | View | |
VIEW_DISPENSATIONS | 0 | 1 | 10 | 0 | View |