Please check https://bcgov.github.io/nr-forests-access-management/app_fam/relationships.html

Please note that the fam group related tables are not currently in use.

ER Studio FAM Data Model Link (only accessible within the bcgov network)

• We are currently maintaining the data model with SchemaSpy, and it's an automatic process. For more details please refer to SchemaSpy for Generating Data Model.
• Previously we are maintaining the data model manually in ER Studio. The first version of the database is checked into the FAM repo under db/sql.
• As we update the database, change scripts will be added to the FAM repo.
• Database migration scripts will be managed with github actions. We are currently building this capability.