Thinking out loud...New tables will have prefix rb to group them in PgAdmin or psql..
rborg will hold organizations, naturally. They'll be primary reference.
id = serial (PK natch!)
orgname = varchar (64)
orgparent = integer (FK)
orgarea = integer (FK)
description = text
founded = date
lastseen = timestamp
So a record might show:
id = 1
orgname= M23
orgparent = 99 (= Rwanda)
orgarea = 104 (= North Kivu Province, DRC; or should this be varchar?)
description = March 23rd Movement, also known as the Congolese Revolutionary Army (Armée révolutionnaire du Congo). For the most part formed of ethnic Tutsi bad guyz. The M23 rebellion of 2012 to 2013 against the DRC government led to the displacement of large numbers of people. On 20 November 2012, M23 took control of Goma, a provincial capital with a population of a million people, but it was requested to evacuate it by the International Conference on the Great Lakes Region because the DRC government had finally agreed to negotiate. In late 2012, Congolese troops, along with UN troops, retook control of Goma, and M23 announced a ceasefire and said that it wanted to resume peace talks.
A United Nations report found that Rwanda created and commanded the M23 rebel group. Rwanda ceased its support because of international pressure and the military defeat by the DRC and the UN in 2013.
In 2017, M23 elements resumed their insurgency, but the operations of this splinter faction had little local impact. In 2022, a larger portion of M23 started an offensive, which eventually resulted in the capture of the Congolese border town of Bunagana. After the M23 attacks of 2022, the Congolese government blamed Rwanda of supporting the rebels. Rwanda piously denied these accusations. In November 2022, M23 rebels got close to the city of Goma and forced about 180,000 people to leave their homes after the Congolese Army had withdrawn from the region near the village of Kibumba.
As of February 2023 the group occupies various major towns in eastern North Kivu including Bunagana, Kiwanja, Kitchanga, Rubaya, and controls vital roads leading to Goma.
founded = 23 March 2009
lastseen = 10/31/2023
So now what am I forgetting?