Reassign schema captions & descriptions to COG, COGT, and COT tables

[grantfitzsimmons]

We are building the schema records for these tables, and we're shipping this in 7.9.7.

The schema captions are bad in almost every case, and we haven't reviewed or given captions or descriptions to these fields. It is unacceptable to leave it "as-is".

[grantfitzsimmons]

The fields were decided but the user-facing names and captions (like "Cojos" and "Parent Cojos") need to be discussed. "Cog Type" isn't something the user should see

Something like:
"Cog Type" --> "Type"
"Cojos" --> "Children"
Plus we need to write a description for those fields

[grantfitzsimmons]

We should definitely fix these while we're at it...

spuserexternalid
spattachmentdataset
uniquenessrule
uniquenessrulefield
message
spmerging
userpolicy
role
libraryrole
userrole
libraryrolepolicy
rolepolicy
spdataset

Here's an idea of what things look like now with those tables:

This is the result of the following query:

SELECT sps.SpLocaleItemStrID AS 'String ID', sps.`Text` AS 'Field Label',
       d.Name AS 'Discipline Name', slc.Format AS 'Field Format', slc.Name AS 'Database Field', slc.PickListName, splc.Name AS 'Database Table',
       slc.IsHidden AS 'Is Hidden?', slc.SpLocaleContainerItemID AS 'Container ID'
FROM splocaleitemstr sps
JOIN splocalecontaineritem slc ON sps.SpLocaleContainerItemNameID = slc.SpLocaleContainerItemID
JOIN splocalecontainer slca ON slc.SpLocaleContainerID = slca.SpLocaleContainerID
JOIN splocalecontainer splc ON slc.SpLocaleContainerID = splc.SpLocaleContainerID
JOIN discipline d ON slca.DisciplineID = d.disciplineId
WHERE splc.Name IN ('collectionobjecttype', 'collectionobjectgrouptype', 'collectionobjectgroup', 'collectionobjectgroupjoin')
ORDER BY splc.Name;

String ID	Field Label	Discipline Name	Field Format	Database Field	PickListName	Database Table	Is Hidden?	Container ID
33236	Created By Agent	Geology		createdByAgent		collectionobjectgroup	1	16428
33198	Version	Geology		version		collectionobjectgroup	1	16409
33210	Integer1	Geology		integer1		collectionobjectgroup	0	16415
33220	Decimal3	Geology		decimal3		collectionobjectgroup	0	16420
33232	Parent Cojos	Geology		parentCojos		collectionobjectgroup	0	16426
33196	Guid	Geology		guid		collectionobjectgroup	0	16408
33208	Text3	Geology		text3		collectionobjectgroup	0	16414
33230	Cog Type	Geology		cogType	COGTypes	collectionobjectgroup	0	16425
33194	Igsn	Geology		igsn		collectionobjectgroup	0	16407
33206	Text2	Geology		text2		collectionobjectgroup	0	16413
33218	Decimal2	Geology		decimal2		collectionobjectgroup	0	16419
33228	Collection	Geology		collection		collectionobjectgroup	0	16424
33192	Description	Geology		description		collectionobjectgroup	0	16406
35244	Children	Geology		children		collectionobjectgroup	0	17357
33204	Text1	Geology		text1		collectionobjectgroup	0	16412
33216	Decimal1	Geology		decimal1		collectionobjectgroup	0	16418
33226	Yesno3	Geology		yesno3		collectionobjectgroup	0	16423
33190	Name	Geology		name		collectionobjectgroup	0	16405
33240	Collection Object Group Id	Geology		collectionObjectGroupId		collectionobjectgroup	0	16430
33202	Timestamp Modified	Geology		timestampModified		collectionobjectgroup	1	16411
33214	Integer3	Geology		integer3		collectionobjectgroup	0	16417
33224	Yesno2	Geology		yesno2		collectionobjectgroup	0	16422
33238	Modified By Agent	Geology		modifiedByAgent		collectionobjectgroup	1	16429
33200	Timestamp Created	Geology		timestampCreated		collectionobjectgroup	1	16410
33212	Integer2	Geology		integer2		collectionobjectgroup	0	16416
33222	Yesno1	Geology		yesno1		collectionobjectgroup	0	16421
33272	Yesno3	Geology		yesno3		collectionobjectgroupjoin	0	16445
33248	Precedence	Geology		precedence		collectionobjectgroupjoin	0	16433
33258	Text2	Geology		text2		collectionobjectgroupjoin	0	16438
33270	Yesno2	Geology		yesno2		collectionobjectgroupjoin	0	16444
33246	Substrate	Geology		isSubstrate		collectionobjectgroupjoin	0	16432
33268	Yesno1	Geology		yesno1		collectionobjectgroupjoin	0	16443
33244	Primary	Geology		isPrimary		collectionobjectgroupjoin	0	16431
33280	Collection Object Group Join Id	Geology		collectionObjectGroupJoinId		collectionobjectgroupjoin	0	16449
33256	Text1	Geology		text1		collectionobjectgroupjoin	0	16437
33266	Integer3	Geology		integer3		collectionobjectgroupjoin	0	16442
33278	Child Co	Geology		childCo		collectionobjectgroupjoin	0	16448
33254	Timestamp Modified	Geology		timestampModified		collectionobjectgroupjoin	1	16436
33264	Integer2	Geology		integer2		collectionobjectgroupjoin	0	16441
33276	Child Cog	Geology		childCog		collectionobjectgroupjoin	0	16447
33252	Timestamp Created	Geology		timestampCreated		collectionobjectgroupjoin	1	16435
33262	Integer1	Geology		integer1		collectionobjectgroupjoin	0	16440
33274	Parent Cog	Geology		parentCog		collectionobjectgroupjoin	0	16446
33250	Version	Geology		version		collectionobjectgroupjoin	1	16434
33260	Text3	Geology		text3		collectionobjectgroupjoin	0	16439
33172	Type	Geology		type	SystemCOGTypes	collectionobjectgrouptype	0	16397
33182	Created By Agent	Geology		createdByAgent		collectionobjectgrouptype	1	16402
33170	Name	Geology		name		collectionobjectgrouptype	0	16396
33180	Collection	Geology		collection		collectionobjectgrouptype	0	16401
33178	Timestamp Modified	Geology		timestampModified		collectionobjectgrouptype	1	16400
33176	Timestamp Created	Geology		timestampCreated		collectionobjectgrouptype	1	16399
33186	Cog Type Id	Geology		cogTypeId		collectionobjectgrouptype	0	16404
33174	Version	Geology		version		collectionobjectgrouptype	1	16398
33184	Modified By Agent	Geology		modifiedByAgent		collectionobjectgrouptype	1	16403
33158	Collection	Geology		collection		collectionobjecttype	0	16391
33144	Name	Geology		name		collectionobjecttype	0	16384
33156	Text3	Geology		text3		collectionobjecttype	0	16390
33154	Text2	Geology		text2		collectionobjecttype	0	16389
33166	Collection Object Type Id	Geology		collectionObjectTypeId		collectionobjecttype	0	16395
33152	Text1	Geology		text1		collectionobjecttype	0	16388
33164	Modified By Agent	Geology		modifiedByAgent		collectionobjecttype	1	16394
33150	Timestamp Modified	Geology		timestampModified		collectionobjecttype	1	16387
33162	Created By Agent	Geology		createdByAgent		collectionobjecttype	1	16393
33148	Timestamp Created	Geology		timestampCreated		collectionobjecttype	1	16386
33160	Taxon Tree Def	Geology		taxonTreeDef		collectionobjecttype	0	16392
33146	Version	Geology		version		collectionobjecttype	1	16385