Access to the documents related to the emigration movement dated from 1960s till 1970s.
Application to aid and to intermediate the upload of the institution documents data into a relational database.
The Relational Database has been designed dedicated to the analysis of emigration documents. The logical model of the database implemented covers the data items in the sources — emigration documents of Fafe Archive necessary to obtain an emigration passport.
uploading, storing and preserving the emigration documents.
The schema designed covers the data items described in Section 2 of the paper (Emigration Documents). To better present the relational database developed, the diagram below shows the sixteen tables that compose the logical model.
In the next list will be detailed the conceptual model (group of items).
In next table is presented the primary and foreign keys of the database.
Table | Primary Key | Foreign Key |
---|---|---|
Acompanhante | idAcomp | |
Anexo | idAnexo | |
Chamante | idChamante | |
Contratante | idContratante | |
DeslAnterior | idDeslAnterior | numCM references Processo |
Filiacao | idFiliacao | |
IdentificacaoEmigrante | idEmigrante | idFiliacao references Filiacao; idNaturalidade references Localidade |
Intermediario | idIntermediario | |
Localidade | idLocalidade | |
Lugar | idLugar | idLocalidade references Localidade |
Nota | idNota | numCM references Processo |
PessoasFamFicamPais | idPessoasFamFicamPais | idResidencia references Localidade |
Processo | numCM | idEmigrante references IdentificacaoEmigrante; idChamante references Chamante; idResidencia references Localidade; idLugar references Lugar; idIntermediario references Intermediario; idContratante references Contratante |
ProcessoAcomp | idProcessoAcomp | numCM references Processo; idAcomp references Acompanhante |
ProcessoAnexo | idProcessoAnexo | numCM references Processo; idAnexo references Anexo |
ProcessoPessoasFam | idProcessoPessoasFam | numCM references Processo; idPessoasFamFicamPais references PessoasFamFicamPais |