Modèle logique ou relationnel - mroylem/archivist GitHub Wiki

Ce modèle est issu de la transcription sous forme relationnelle du modèle conceptuel

---

person(pk_person, name, gender, maiden name, death_date, nationaltiy)

birth(pk_birth, date_of_birth,fk_person,fk_geographical_place)

relantionship(pk_relantionship, nature, definition, fk_person1, fk_person2)

person_educations(pk_person_educations, fk_person, fk_education)

education(pk_education, name, type, definition, fk_geographical_place)

employment_period(pk_employment_period, year_of_taking_office, year_of_ending_term, fk_person, fk_organisation, fk_occupation)

occupation(pk_occupation, type, definition, name)

organisation(pk_organisation, name, definition, fk_geographical_place)

person_documentary_productions(pk_person_documentary_productions, fk_person, fk_doucmentary_production)

documentary_production(pk_documentary_production, biliographic_reference, year_of_publication, fk_geographical_place)

documentary_production_themes(pk_documentary_production_themes, fk_documentary_production, fk_theme)

theme(pk_theme, name, domain)

geographical_place(pk_geographical_place, name, definition, latitude, longitude)