No, there won’t be any new tables, rather the description columns in the existing tables will now be populated.
For example, for the event role type, you will see in the event_ref table that column role0 has an integer value and column role1 has the corresponding description.
There are a few other integer values for which you’ll need to create your own descriptions, if you want them. I created a lookup table like this:
DROP TABLE constants;
CREATE TABLE constants (
table_name CHARACTER(25),
column_name CHARACTER(25),
code INTEGER,
value TEXT);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘quality’, 0, ‘Regular’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘quality’, 1, ‘Estimated’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘quality’, 2, ‘Calculated’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘modifier’, 0, ‘Regular’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘modifier’, 1, ‘Before’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘modifier’, 2, ‘After’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘modifier’, 3, ‘About’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘modifier’, 4, ‘Range’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘modifier’, 5, ‘Span’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘modifier’, 6, ‘Text only’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘newyear’, 0, ‘January 1’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘newyear’, 1, ‘March 1’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘newyear’, 2, ‘March 25’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘newyear’, 3, ‘September 1’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘calendar’, 0, ‘Gregorian’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘calendar’, 1, ‘Julian’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘calendar’, 2, ‘Hebrew’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘calendar’, 3, ‘French’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘calendar’, 4, ‘Persian’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘calendar’, 5, ‘Islamic’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘date’, ‘calendar’, 6, ‘Swedish’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘citation’, ‘confidence’, 0, ‘Very low’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘citation’, ‘confidence’, 1, ‘Low’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘citation’, ‘confidence’, 2, ‘Normal’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘citation’, ‘confidence’, 3, ‘High’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘citation’, ‘confidence’, 4, ‘Very high’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘name’, ‘display_as’, 0, ‘Default’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘name’, ‘display_as’, 1, ‘Surname, Given Suffix’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘name’, ‘display_as’, 2, ‘Given Surname Suffix’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘name’, ‘display_as’, 4, ‘Given’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘name’, ‘display_as’, 5, ‘Main Surnames, Given Patronymic Suffix Prefix’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘name’, ‘sort_as’, 0, ‘Default’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘name’, ‘sort_as’, 1, ‘Surname, Given Suffix’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘name’, ‘sort_as’, 2, ‘Given Surname Suffix’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘name’, ‘sort_as’, 4, ‘Given’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘name’, ‘sort_as’, 5, ‘Main Surnames, Given Patronymic Suffix Prefix’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘person’, ‘gender’, 0, ‘Female’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘person’, ‘gender’, 1, ‘Male’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘person’, ‘gender’, 2, ‘Unknown’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘note’, ‘format’, 0, ‘Unformatted’);
INSERT INTO constants (table_name, column_name, code, value) VALUES (‘note’, ‘format’, 1, ‘Preformatted’);