In the table tblPagesoftlink, there's a column called "LinkType." It has integer values, seemingly 1-4. Does anyone know what these values correspond to? It's not an FK, so there's no other table to look at. They're just kind of magic numbers.
Those should refer to the enum EPiServer.DataAbstraction.ReferenceType. They are loaded into the SoftLink.SoftLinkType property.
Per GunsarfsEPiServer Development Team