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
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.