Modèle logique ou relationnel - projhistoire/Projet-Histoire GitHub Wiki

person(pk_person, name, definition, sex, death_date, fk_birth, notes)

formation(pk_formation, name, begin date, end date, type of formation, fk_person)

mission(pk_mission, name, begin date, end date, fk_mission)

time in space(pk_time_space, total time of flight in space, time in space out of vehicule, fk_time_space)

membership(pk_membership, begin date, end date, fk_person, fk_organisation)

appellation(pk_appellation, pk_person, name, sources, notes)

tag(pk_tag, fk_parent_tag, name, definition, notes)

tags(pk_tags, fk_person, fk_tag, notes)

pursuit(pk_pursuit, fk_person, fk_occupation, fk_organisation, begin_date, end_date, sources, notes)

organisation(pk_organisation, fk_geographical_place, name, definition, notes)

organisation_tag(pk_organisation_tag, fk_tag, fk_organisation)

occupation(pk_occupation, name, definition, notes)

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

geographical_place_type(pk_geographical_place_type, name, definition, fk_parent_geographical_place_type, notes)