我即将重新设计DB系统,我正在考虑在我的应用程序中使用ORM,下面的系统是否与Eloquent ORM合作,或者我是否还要加上JOIN表格?
ISSUES(ID, ORGANIZATION_ID, DATE, TIME, CATEGORY_ID, TYPE_ID, ISSUE_DETAILS_ID)
ISSUE_DETAILS(ID, NAME, STATUS, EMAIL)
ORGANIZATIONS(ID, NAME, ADDRESS, CONTACT)
CATEGORIES(ID, CATEGORY)
TYPES(ID, TYPE, CATEGORY_ID)
我唯一可能做的不同之处是在 issu_id 表格上有 issues_ details 外国密钥,这样您就可以对一个 < / strong > 关系有一个 < strong > 关系。
所以,如果你使用神话, 你可以做这样的事情。
echo $issue->details->name;
我并不完全确定你将在详细表格中储存什么,也许对于一个问题,会有多种细节,在这种情况下,你对许多 " /强 " 关系会有 " 强 " 关系。
除了杰森建议的内容外,您还可以从 issues 表格中删除 alissues ,因为每个 type 已经有一个 allike ,您已经可以通过该类型进入该类别。
i. e. e. $issues-gt; 类型> 类别
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...
我把我的用心从使用QQL转向MySQL。 它与凯科特合作,现在不工作,因为我已经改变,使用MySQL。 这里的错误信息是:
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...
Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...
What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...
My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...