TID: Mystic BBS 1.12 A49
MSGID: 1:129/215 08112d94
TZUTC: -0400
 CA> I have a question about how you laid our your db containing msgs that i
 CA> thought you might answer.
 CA> In storing messages, specifically echomail, do you save each kludge
 CA> as a seperate value or do you just simply save the header info and then
 CA> the entire message text with kludge?

The message text and the kludges are stored separately.  JAM bases have a
message header/index with mostly integer-based data, and then a message text
buffer.  Part of that text storage is a sub-text buffer that stores custom
fields and it has a variable length which allows field expandability without
breaking the format.  The subtext is where the kludges are stored.

I believe Synchronet's format uses a similar approach too.

... A SQL query walks into a bar and sees two tables. Asks: 'Can I join you?'

--- Mystic BBS v1.12 A49 2023/03/14 (Windows/64)
 * Origin: Sector 7 * Mystic WHQ (1:129/215)
SEEN-BY: 1/123 15/0 90/1 105/81 106/201 114/705 120/616 123/10 120
SEEN-BY: 123/131 129/215 305 153/7715 154/10 30 40 50 700 218/700
SEEN-BY: 218/840 220/70 90 221/6 226/17 18 30 70 100 227/114 201 229/110
SEEN-BY: 229/111 112 113 206 275 307 310 317 400 424 426 428 452 470
SEEN-BY: 229/550 664 700 250/5 8 266/512 267/800 280/464 282/1038
SEEN-BY: 292/854 298/25 301/1 305/2 3 317/3 320/219 322/757 342/200
SEEN-BY: 396/45 460/58 633/280 712/848 770/1 2320/105 3634/12
PATH: 129/215 154/10 770/1 317/3 229/426