The wp_links table in the WordPress database stores information about external links that are added to the site's blogroll.
It is deprecated as of WordPress 3.5 and may be removed in a future version.
Columns
link_id: Unique identifier for each link, used as primary key.
link_url: URL of the link. This column is typically populated by the user when adding a new link through the WordPress admin interface. Example: "https://www.wpdir.com".
link_name: Name or title of the link, also added by user in the new link form. Example: "WPDir Homepage".
link_image: If the user has specified an image to be associated with the link, the image URL will be stored in this column. Example: "https://www.wpdir.com/images/logo.png".
link_target: The target attribute of the link, which specifies where and how the link should be opened when clicked. Examples: "_blank" to open the link in a new tab or window, or "_self" to open it in the same tab or window.
link_description: Description of the link. This column can be populated with a brief description of the linked website or resource. Example: "A great resource for WordPress developers".
link_visible: This column can be used to control whether the link is displayed on the front end of the website. Possible values are 0 to hide the link or 1 to show it.
link_owner: ID of the user who owns the link or has added the link to the WordPress site. It is the ID column from wp_users table.
link_rating: Numerical rating of the link, used for sorting and filtering links. An integer.
link_updated: Date and time the link was last updated in the WordPress site's timezone. It can be used for sorting and filtering links by date.
link_rel: The rel attribute (relationship of the link to the current page). Typical example is "nofollow".
link_notes: This column can be used to store additional notes about the link, such as why it was added or who recommended it.
link_rss: If the website being linked to has an RSS feed, the URL can be stored in this column. Example: "https://www.wpdir.com/feed".
SQL Schema
CREATE TABLE `wp_links` (
`link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`link_url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`link_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`link_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`link_target` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`link_description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`link_visible` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Y',
`link_owner` bigint(20) unsigned NOT NULL DEFAULT 1,
`link_rating` int(11) NOT NULL DEFAULT 0,
`link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`link_rel` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`link_notes` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
`link_rss` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`link_id`),
KEY `link_visible` (`link_visible`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;