Metadata-table

[sabinem]

Decide on the structure of the metadata table

Proposal

The structure needs to be stable. So we need to decide about this table:

Metadata Table Structure

table name:

• table name metadata_table

table columns

• item: the name of the field or table
• type: either field or table
• table: the table name that this entry relates to
• language: the language of the table that the entry relates to
• description: description of the item

Questions:

• one or two tables (there could be one for tables and one for table columns
• should item better be item_title?

[sabinem]

Answers:

• yes 2 tables: metadata_tables, metadata_table_columns

• not type, but for columns we need data_type

• instead of ìtem: name`

• table -> table_name

• categorical values: put a list in the description (enumarates)examples in the decription

• data_type: categorical , numeric, text

• language at metadata_tables only.

[sabinem]

Adapted after discussion:

[nooralahzadeh]

Is it possible to have the table description in En and Fr?

[sabinem]

We should discuss this tomorrow.
The table structure now is:

In regards to the metadata for the table I would suggest to add a field data_source for the url to the data source.