The PostLinks
table in SEDE has a column called LinkTypeId
, but there's nothing in the schema that describes what various values of LinkTypeId
mean. For I think all of the other "Type" columns, there are corresponding description tables like CloseReasonTypes
and PostHistoryTypes
and ReviewTaskTypes
.
So, it would be nice if we had a new table called PostLinkTypes
. I guess it would just have two columns (Id tinyint
and Name nvarchar
), and probably only two rows, too, seeing as the only values of LinkTypeId
I've found are 1
(regular links) and 3
(links to duplicates).
Motivation: I looked at the PostLinks
table for the first time in the process of writing this query and had to spelunk through the table to figure out what the LinkTypeId
column meant.
i
info button is a bit inconsistent and mildly inconvenient, as is the lack of an automatic look up of descriptive names for ids for generating reports (still an easy workaround, of course). I'm a big fan of self-documentation.