# \#multi-table

**URL:** https://forum.datacebo.com/tag/multi-table/9.md

[Latest](https://forum.datacebo.com/latest.md) · [Categories](https://forum.datacebo.com/categories.md) · [Tags](https://forum.datacebo.com/tags.md)

---

## [Specify Composite Keys in the Metadata](https://forum.datacebo.com/t/specify-composite-keys-in-the-metadata/425)

<div class="topic-metadata">

**Author:** [@neha](https://forum.datacebo.com/u/neha)\
**Replies:** 0\
**Last updated:** [March 30, 2026, 3:57pm UTC](https://forum.datacebo.com/t/specify-composite-keys-in-the-metadata/425 "2026-03-30T15:57:18Z")

</div>

Starting from the latest SDV Enterprise release, you can specify composite keys directly in your SDV metadata. Then, you can supply the metadata (containing composite keys) to a synthesizer, and use it to create realisti…

---

## [Tips for maintaining many-to-one relationships across multiple tables](https://forum.datacebo.com/t/tips-for-maintaining-many-to-one-relationships-across-multiple-tables/219)

<div class="topic-metadata">

**Author:** [@ecastaner](https://forum.datacebo.com/u/ecastaner)\
**Replies:** 1\
**Last updated:** [January 26, 2026, 9:13pm UTC](https://forum.datacebo.com/t/tips-for-maintaining-many-to-one-relationships-across-multiple-tables/219 "2026-01-26T21:13:33Z")

</div>

@giovanni.circo could you please add a short description of the challenges you’re facing?

---

## [\[Resolved\] Cross-table constraints](https://forum.datacebo.com/t/resolved-cross-table-constraints/220)

<div class="topic-metadata">

**Author:** [@ecastaner](https://forum.datacebo.com/u/ecastaner)\
**Replies:** 3\
**Last updated:** [January 26, 2026, 8:53pm UTC](https://forum.datacebo.com/t/resolved-cross-table-constraints/220 "2026-01-26T20:53:19Z")

</div>

@giovanni.circo could you please add some details on the question you have regarding this topic? Thanks

---

## [Maintaining Cardinality Between Tables](https://forum.datacebo.com/t/maintaining-cardinality-between-tables/246)

<div class="topic-metadata">

**Author:** [@giovanni.circo](https://forum.datacebo.com/u/giovanni.circo)\
**Replies:** 3\
**Last updated:** [August 27, 2024, 9:13pm UTC](https://forum.datacebo.com/t/maintaining-cardinality-between-tables/246 "2024-08-27T21:13:39Z")

</div>

We have a database of claims, procedures, and diagnoses, along with a header table. The header table uniquely defines records by MBR\_ID, CLM\_ID, and CLM\_HASH\_KEY. The expected output is that every claim in the clm\_detail…

---

## [Generating complex relationships in multi-table data](https://forum.datacebo.com/t/generating-complex-relationships-in-multi-table-data/212)

<div class="topic-metadata">

**Author:** [@giovanni.circo](https://forum.datacebo.com/u/giovanni.circo)\
**Replies:** 1\
**Last updated:** [June 21, 2024, 4:55pm UTC](https://forum.datacebo.com/t/generating-complex-relationships-in-multi-table-data/212 "2024-06-21T16:55:45Z")

</div>

The multi-table synthesizer does a good job out-of-the-box creating simple flat tables that are linked. However, most of our use cases involve complex many-to-one relationships. For example: A claims header table has a s…

---

## [Multi-table models should support sequential data](https://forum.datacebo.com/t/multi-table-models-should-support-sequential-data/204)

<div class="topic-metadata">

**Author:** [@neha](https://forum.datacebo.com/u/neha)\
**Replies:** 0\
**Last updated:** [June 6, 2024, 6:22pm UTC](https://forum.datacebo.com/t/multi-table-models-should-support-sequential-data/204 "2024-06-06T18:22:45Z")

</div>

Problem Description Currently all multi-table synthesizers assume that each table contains single-table (non-sequential) data. However, in some cases you may have one or more table that correspond to sequences. As an exa…
