oaregithub / oare_mono

1 stars 0 forks source link

Migration for SQL column names #1709

Open edstratford opened 1 year ago

edstratford commented 1 year ago

The following terms in SQL columns need to be standardized:
object > obj (ex. obj_uuid) reference > ref (ex. ref_uuid) parent > par. (ex. par_uuid, obj_par_uuid) text > txt reading > rdg abbreviation > abbr column > col spelling

For full list see: https://docs.google.com/spreadsheets/d/1ua7NCi0ziMj_PtegMWaNotTEp53XyV-UlQ-VYFo5ia4/edit#gid=380047943

May also be ready to remove following columns (must determine that none are used in backend of code) text_discourse.word_on_tablet text_discourse.child_num text_epigraphy.char_on_line text_epigraphy.char_on_tablet text_discourse.spelling

edstratford commented 1 year ago

See also #1623