---
title: "Discussion on \"Orchid Academy Issaquah Is Two Rooftops: Why (Brand, City) Is the Wrong Unique Key\" | Hashnode"
description: "Discussion on \"Orchid Academy Issaquah Is Two Rooftops: Why (Brand, City) Is the Wrong Unique Key\". Orchid Academy Issaquah publishes two academy addresses in the same city with the same hours and age band. A uniqueness constraint on brand plus city merges them. The stable key is the rooftop."
url: "https://hashnode.com/posts/orchid-academy-issaquah-brand-city-unique-key/6a871b9aa1cf3598fd5f1b8d"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Orchid Academy Issaquah Is Two Rooftops: Why (Brand, City) Is the Wrong Unique Key](https://spcn.hashnode.dev/orchid-academy-issaquah-brand-city-unique-key?utm_source=hashnode&utm_medium=feed)

Orchid Academy Issaquah publishes two academy addresses in the same city with the same hours and age band. A uniqueness constraint on brand plus city merges them. The stable key is the rooftop.

Aug 20 · 3 min read · spcn.hashnode.dev  
Updated Oct 16  
Read the article

-   [#datamodeling](https://hashnode.com/tag/datamodeling)
-   [#architecture](https://hashnode.com/tag/architecture)
-   [#database](https://hashnode.com/tag/database)
-   [#seo](https://hashnode.com/tag/seo)

## Written by

[Special Needs Care Network](https://hashnode.com/@spcn)

@spcn

  
[View profile](https://hashnode.com/@spcn)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
