Design for a dump of the database - Psalms

I have produced a complete searchable dump of my music data on the te'amim.

It is organized by book. For each table in the book there are 4 columns

Column 1 is Music leading to the mid point (if there is one)
Column 2 is Music returning to the tonic (if there was a mid point)
Column 3 is The total number of times this musical phrase occurs in the Bible
Column 4 is where these phrases occur in the Psalms

To compare across books, one selects the musical phrase and searches the PDF. The reader knows if there are more if the number of references does not add up. It is useful to know if a phrase occurs only in one book or in many. It could help identify authors.

E.g. the sixth line of the following table for the Psalms says there are 97 occurrences of this phrase. It lists only 32. So there are 65 other occurrences in Proverbs and Job. We know this because the sequence g B e only occurs in the three poetry books and the second clue is the ole, which also only occurs in the 3 books.

If you want to see accents, use the following translation.

	Below the text		Above the text
c	darga	ger-rev	revia-mugrash
d	galgal	pas	pashta
e	silluq	ger	geresh
f	merkha	tar	tarsin
g	tifha	paz	pazer
A	atnah	z-q	zaqef-qatan
B	munah	z-g	zaqef-gadol
C	mahpakh	qad	qadma
dm	double merkha, kefulah	seg	segol
		zar	zarqa, tsinnor
		tal	telisha
		qar	qarne farah
		shl	shalshalet
		ill	illuy
		ole	ole
		rev	revia

The Psalms and its musical phrases. A sampling.

f# e rev,C f# zar,d ole,f# B g f# A	f# ger-rev,B e	1	Psalms 1:1
C f# f# rev,ole,f# e f# rev,f# e		1	Psalms 1:2
e rev,zar,d e ole,f# C pas,ill,rev,f# e A	g B e	1	Psalms 1:3
e f# A	f# ger-rev,e f# e	1	Psalms 1:4
e C B g A	ger-rev,f# e	2	Psalms 1:5, 6:11
e B g B A	g B e	97	Psalms 1:6, 30:2, 33:7, 34:17, 37:10, 49:21, 50:18, 51:14, 56:12, 58:6, 66:16, 68:33, 72:14, 74:3, 74:4, 74:8, 77:15, 86:10, 88:15, 89:47, 105:44, 112:2, 112:8, 115:11, 118:6, 118:23, 119:39, 124:2, 136:9, 136:12, 139:8, 140:2
g B A	ger-rev,e	75	Psalms 2:1, 2:6, 16:3, 18:4, 22:5, 26:7, 31:25, 37:15, 44:12, 48:7, 50:15, 54:4, 55:17, 71:7, 71:14, 72:8, 73:21, 76:13, 78:28, 78:40, 81:13, 88:7, 88:17, 89:43, 104:6, 105:7, 105:31, 106:8, 106:22, 106:44, 111:2, 114:4, 114:6, 115:2, 115:13, 116:9, 116:14, 116:15, 116:18, 118:21, 119:60, 119:118, 119:121, 119:126, 119:134, 119:135, 122:2, 122:6, 124:5, 130:8, 135:8, 147:3

I have produced the book. It will be volume 10 of Bob's Bible. It is a unique resource where you can search for any musical phrase. I.e. any sequence of accents over the scope of the whole of the Hebrew Scripture.

Here for instance are all the verses that have the same musical shape as Psalms 2:4

Psalms 2:4

Psalms 2:4, 2:11, 18:24, 22:21, 30:9, 33:15, 33:19, 34:5, 34:6, 34:18, 35:2, 37:6, 45:4, 48:10, 50:9, 55:14, 65:7, 67:3, 73:23, 77:6, 78:47, 78:48, 78:62, 80:11, 80:12, 85:8, 90:16, 102:17, 103:6, 105:21, 105:29, 105:30, 105:36, 105:43, 106:40, 106:46, 114:2, 114:8, 115:14, 118:28, 119:25, 119:58, 119:79, 119:137, 119:170, 121:3, 135:14, 149:5

Proverbs 2:15, 3:22, 5:9, 5:16, 6:4, 6:21, 7:26, 7:27, 23:12, 24:21, 24:28, 27:2, 31:17, 31:23

Job 7:15, 9:34, 11:9, 14:17, 15:6, 15:25, 18:8, 22:19, 26:11, 33:11, 33:22, 34:18, 36:14, 38:3, 38:9, 39:9, 40:7

and there are another 16 that have a shape that contains this shape.
Are these shapes leitmotifs? Or composer fingerprints?