“路由器” - 如何做正确的事？

发布于 2024-11-29 22:06:45 字数 561 浏览 1 评论 0原文

我想向您询问路由器的最佳解决方案。

我的数据库中有一些表（文章、页面、类别等），它们都有 ID。我想为每个人生成特定的 URL，例如。 /en/article/25-This-is-an-test-article。

但是如何摆脱那个/article，/page，...？用户不想看到它 - 它只是增加了 url 的长度...

我的第一个想法是简单的路由器表：

CREATE TABLE `router` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `entity_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

但是有一个致命的问题 - 不可能为 enity_id 列设置外键，因为它应该引用更多列，这在 SQL 中是不可能的。

我的问题是：您认为我应该坚持该解决方案（并忽略外键）或者我应该忘记它并在 URL 中附加类型？

原文

I want to ask you for best solution for the router.

I have some tables in my database (articles, pages, categories etc.) which all has IDs.
I want to generate specific URL for each of them, eg. /en/article/25-This-is-an-test-article.

But how to get rid of that /article, /page, ... ? Users don't want to see it - it just increases the length of url ...

My first idea was simple router table:

CREATE TABLE `router` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `entity_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

But there is one fatal problem - It's impossible to set foreign key for the enitity_id column because it should refer to more columns and that is not possible in SQL.

My question is:
Do you think that I should stick with that solution (and ignore the foreign key )
or should I forgt about it and append the type in the URL ?

分享到QQ

分享到微博