SF rule to require adding the companyId field to new tables unless is a control table

• Type: Story
• Status: Closed
• Priority: Minor
• Resolution: Completed
• Affects Version/s: None
• Fix Version/s: 7.3.0 CE GA1, Master
• Component/s: Dev Tools > Source Formatter
• Labels:
  • fc_20_01
• Epic Link: SaaS Database Support
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/83730

Supporting saas requires that we have to separate data (physically) based on the companyId.

Originally we thought about modifying the Service Builder to achieve it (see LPS-103481) but we don't want to affect custom developments for now.

For that reason, we are going to create a SF rule which will require the use of the companyId column for new tables unless is a control table (a table is considered as "control table" when it stores data a portal level, it doesn't store data specifically for a particular instance (company), for example, Release, ResourceAction or Counter). This will be the logic of the SF rule:

1. Detect new tables in service.xml files
2. Require to add the companyId field unless it is a control table

We should have a way to bypass this control for new control tables (a property or something like that)