Tables


SchemaSpy Analysis of stcwp

Generated on Wed Jun 12 10:23 WEST 2019

stcw.prod.schemaspy.properties

XML Representation
Insertion Order Deletion Order
TABLES 52
VIEWS 55
COLUMNS 1422
Constraints 82
Anomalies 19
Routines 195

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