Skip to content

Instantly share code, notes, and snippets.

@seesharper

seesharper/veins.md

Last active January 29, 2017 21:36
Show Gist options
  • Save seesharper/c60b5de1868696501248a415023aef8a to your computer and use it in GitHub Desktop.
Save seesharper/c60b5de1868696501248a415023aef8a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
veins.md

This document shows how to model veins in a relations model.

FACT: Veins can split into several other veins that in turn merges into other veins.

tbl_veins

This table simply list all the veins

Id Name
1 SampleNerve1
2 SampleNerve2
3 SampleNerve3
4 SampleNerve4

tbl_parent_veins

This table describes the relationship between veins. Looking at the sample data we can see that nerve 3 splits into two other veins, 1 and 2. These veins (1 and 2) then merges into vein 4.

*Nerve_Id *ParentNerve_Id
3 1
3 2
1 4
2 4
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment