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