Sorry, but it was an MS Access database when I was Clerk Signet. We had the monarchs/reign as a separate table and cross-referenced to the award record via a numerical index to the monarch/reign table. I didn't deal with Baronial awards other than the occasional courtesy if someone remembered to CC me with the court report. From outward appearances, it seems that Cassandra may have expanded that table to include Territorial Barons & Baronesses--but she may have developed some other scheme to manage the information. I haven't seen the new database schema, but I don't think it would be radically different from what I was using (as the Clerk Signet database was an extension of the original OP database design)
The foreign award concept was not part of my database, but it definitely is in the OP....
It's been a long time since I did any meaningful compiler work, but it looks like you are going to need to do a little bit of lexical analysis of the flat files in addition to your parsing. To me, that means you may have a fairly large "case" statement to filter the monarch/coronet-oriented awards versus a comment indicating a branch. Unfortunately, unless you can guarantee the syntax is consistent, you still are likely to have some manual cleanup to do before or after. :/
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
(no subject)
Date: 2012-08-24 08:50 pm (UTC)The foreign award concept was not part of my database, but it definitely is in the OP....
It's been a long time since I did any meaningful compiler work, but it looks like you are going to need to do a little bit of lexical analysis of the flat files in addition to your parsing. To me, that means you may have a fairly large "case" statement to filter the monarch/coronet-oriented awards versus a comment indicating a branch. Unfortunately, unless you can guarantee the syntax is consistent, you still are likely to have some manual cleanup to do before or after. :/