StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8193693
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-11-19T11:22:18.250
FavoriteCount
0
LastActivityDate
2011-11-19T11:22:18.250
LastEditDate
LastEditorUserId
0
OwnerUserId
770876
ParentId
8191772
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
I would suggest using <a href="http://book.cakephp.org/2.0/en/models/associations-linking-models-together.html" rel="nofollow">Aliases</a> in your relationships which will help get your head around the data being returned. For example, your User model could use SelectedPet and ProfilePicture in it's associations: User.php model <pre><code>/** * belongsTo associations * * @var array */ public $belongsTo = array( 'SelectedPet' => array( 'className' => 'Pet', 'foreignKey' => 'petid' ), 'ProfilePicture' => array( 'className' => 'Picture', 'foreignKey' => 'picid', ) ); /** * hasMany associations * * @var array */ public $hasMany = array( 'Album' => array( 'className' => 'Album', 'foreignKey' => 'userid', 'dependent' => false ), 'Pet' => array( 'className' => 'Pet', 'foreignKey' => 'userid', 'dependent' => false ) ); </code></pre> Your Pet model could use ProfilePicture as well: <pre><code>/** * belongsTo associations * * @var array */ public $belongsTo = array( 'User' => array( 'className' => 'User', 'foreignKey' => 'userid' ), 'ProfilePicture' => array( 'className' => 'Picture', 'foreignKey' => 'picid' ) ); /** * hasMany associations * * @var array */ public $hasMany = array( 'Album' => array( 'className' => 'Album', 'foreignKey' => 'petid', 'dependent' => false ) ); </code></pre> Picture model: <pre><code>/** * belongsTo associations * * @var array */ public $belongsTo = array( 'Album' => array( 'className' => 'Album', 'foreignKey' => 'albumid' ) ); </code></pre> ..and finally your Album model: <pre><code>/** * belongsTo associations * * @var array */ public $belongsTo = array( 'User' => array( 'className' => 'User', 'foreignKey' => 'userid' ), 'Pet' => array( 'className' => 'Pet', 'foreignKey' => 'petid' ) ); /** * hasMany associations * * @var array */ public $hasMany = array( 'Picture' => array( 'className' => 'Picture', 'foreignKey' => 'albumid', 'dependent' => false ) ); </code></pre> With regards to the logic of an Album belonging to a User or a Pet, you could just handle this in your controller when saving data or returning it. I.e User is given preference over Pet. I hope this helps.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POAssociations in CakePHP with non-conventional database
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMoz Morris
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.