Differences

This shows you the differences between two versions of the page.

--- newdevs:checklist:tables-columns [2025/03/17 17:46] – created tmccanna
+++ newdevs:checklist:tables-columns [2025/03/17 17:53] (current) – tmccanna
@@ Line 1: / Line 1: @@
 **New Developers Working Group**
 ====== Checklist for Adding Tables and Columns to Evergreen ======
+Here is a list of factors to consider when adding new tables and columns/fields.
 ===== Tables =====
@@ Line 28: / Line 30: @@
   * Appropriate sample data is included in Concerto
+===== Columns =====
+  * New column does not unnecessarily require a full rewrite of a large table during upgrade
+  * Column creation is included in seed scripts
+    * Including any required seed data
+  * Column creation is included in schema update
+    * Including any required seed data
+  * fm_IDL.xml is updated
+    * With links that reflect relationships with other IDL classes
+    * With columns that are intended for localization flagged as such
+  * PII is handled thoughtfully
+    * Reason for storing additional PII is documented
+  * Foreign keys are added thoughtfully
+    * With reason for behavior on update
+    * With reason for behavior on delete
+    * With appropriate indexes if cascading updates or deletions are permitted
+  * Foreign keys linking to actor.usr include...
+    * ... appropriate action in actor.usr_delete_data()
+    * ... appropriate action in actor.usr_merge()
+  * Indexes are added thoughtfully
+  * Appropriate sample data is included in Concerto