Data stores / sqlserver:Phenix

sqlserver:Phenix

sqlserver store used by 22 repo(s). Every sharer is coupled through the schema: they move in convoy when it changes. This is one of the three core databases and a binding point: stage 4 of the programme gives it a named owner and an owned interface.

Recommended action

Own the databaseStage 4: databases as products

Treat Phenix as a product

21 systems share it and its schema is only reconstructable by replaying an append-only change ledger. Reconstruct a declarative schema and give it a named owner.

Impact: Service-level modernisation inside this group is unsafe until this exists

proposed

Coupled repos

Repo	Health	Priority	Entanglement	Kind
backoffice-receipt-service	72 · amber	medium	kernel	api
backoffice-repository-service	37 · red	high	kernel	service
phenix-accommodation	54 · amber	medium	kernel	api
phenix-attractions	54 · amber	medium	kernel	api
phenix-cms	47 · red	high	kernel	other
phenix-database	55 · amber	high	loosely attached	database
phenix-datamap	67 · amber	medium	kernel	other
phenix-destination-search	35 · red	medium	loosely attached	api
phenix-feature-service	31 · red	high	kernel	service
phenix-marketing-campaigns-api	88 · green	low	kernel	api
phenix-p2p	88 · green	low	kernel	api
phenix-place-repository	51 · amber	low	kernel	api
phenix-provider	68 · amber	low	loosely attached	api
phenix-root	32 · red	high	kernel	web-ui
phenix-sales-agent-markup	45 · red	medium	kernel	web-ui
phenix-selling-api	74 · amber	low	kernel	api
phenix-task-reminder-wcf	27 · red	high	kernel	service
phenix-task-reminder-web	32 · red	high	kernel	web-ui
phenix-user-api	79 · green	low	loosely attached	api
provider-activator	53 · amber	low	loosely attached	other
public-api	41 · red	high	kernel	api
scheduled-tasks	79 · green	low	kernel	job