ABL2DB - Tracking Shared Things

I have decided to expand my initial modification of ABL2DB for tracking shared variables to track anything shared, figuring that anything shared is a likely target for refactoring and coupling between compile units.  I have a tentative schema for this, for which I was going to attach a PDF, but I guess no attachments.  Perhaps I will paste it at the end.

Issues

• A couple of things like Browse and Menu have potentially complex description or breakdowns, whose value seems dubious to me as a databased item.  I could put in in as text or just leave it out.
• A couple of things like Frame and Stream have no attributes and so don't really need the child files I have proposed for other things.
• I have proposed a sub, sub table to record temp and work table fields so that one can flag which are assigned to and from in any given compile unit, but I have not proposed a subtable for the indices since these seem dubious in the context.

So, the question is, how much of this seems worth doing and is there any more or less that you would like?

Here's the proposed schema:

SharedObject

chID

chCUID => CompileUnit

chName

lgIsNew

lgIsGlobal

chObjectType

 

SharedBrowse

chID

chObjectID => SharedObject

chQuery

chBrowseDefinition (complex)

 

SharedBuffer

chID

chObjectID => SharedObject

chRecordName¹

lgIsDBTable

 

SharedFrame

chID

chObjectID => SharedObject

(does not seem to have any attributes)

 

SharedMenu

chID

chObjectID à SharedObject

chMenuDescription (complex)

 

SharedQuery

chID

chObjectID => SharedObject

chRecordName¹

 

SharedStream

chID

chObjectID => SharedObject

(does not seem to have any attributes)

 

SharedTempTable²

chID

chObjectID à SharedObject

 

SharedTempTableField

chID

chSharedTempTableID => SharedTempTable

chName

chDataType

lgIsAssignedTo

lgIsAssignedFrom

 

SharedVariable

chID

chObjectID => SharedObject

chDataType

lgIsAssignedTo

lgIsAssignedFrom

 

SharedWorkTable²

chID

chObjectID => SharedObject

 

SharedWorkTableField

chID

chSharedWorkTableID => SharedWorkTable

chName

chDataType

lgIsAssignedTo

lgIsAssignedFrom

 

¹ Could be text field, separate fields for DB and Field or GUID pointing to field.

 

² Structure is suggested for the fields, but not for the indices.