Wikidata:WikiProject 20th Century Press Archives/Data structure/Mapping to IFIS data structure

This page only makes sense if you have access to the IFIS database.

Documentation

The IFIS data structures are documented in the schema "documentation" of the ifis database.

The "used" column (boolean) marks colums which are used in RDF contents or the selection of records for RDF output.

Table institution

Query:

 select dc.table_name, dc.column_name, ic.data_type,
   case when ic.is_nullable='NO' then 'X' end as required, 
   dc.used, dc.description
 from information_schema.columns as ic, documentation.columns as dc
 where ic.column_name = dc.column_name and dc.table_name = ic.table_name
   and ic.table_name = 'institution'

not covered

Many-to-many-Relationships, completly outside table institution:

institution types
texts
industry sectors
locations
alternative names
related institutions
related persons

Table klassifikator

Query: see above for 'klassifikator'

TODO: Make fields required by application "not null" in Postgres Schema (+ DBIx)

not covered

broader/narrower relations
texts
Geonames and some GNDs, which are derived from text fields

Essential information for input

institution view for edits

 -- inst_kennz and inst_name are required for new records
 select nr_inst, inst_kennz, firmsiga, inst_name
 from institution