Difference between revisions of "Template:Database Table Footer"
From Dreamwidth Notes
| Line 1: | Line 1: | ||
| + | = Relationships = | ||
| + | {{#ask:[[Kind::Database Relationship]][[From page::{{{PAGENAME}}}]] | ||
| + | |mainlabel=- | ||
| + | |? To table | ||
| + | |? From field | ||
| + | |? To field | ||
| + | |? Relationship type | ||
| + | |link=none | ||
| + | |sort = From field | ||
| + | |order = asc | ||
| + | |format=template | ||
| + | |template=Database Table Relationship | ||
| + | |intro=<h2>Outgoing</h2> | ||
| + | |default=[[Category:Database Table Needing Relationship Data|{{{2}}}]] | ||
| + | }} | ||
| + | {{#ask:[[Kind::Database Relationship]][[To page::{{{PAGENAME}}}]] | ||
| + | |mainlabel=- | ||
| + | |? From table | ||
| + | |? To field | ||
| + | |? From field | ||
| + | |? Relationship type | ||
| + | |sort = From table, From field | ||
| + | |order = asc | ||
| + | |link=none | ||
| + | |format=template | ||
| + | |template=Database Table Relationship | ||
| + | |intro=<h2>Incoming</h2> | ||
| + | |userparam=from | ||
| + | }} | ||
| + | |||
{{#show: {{PAGENAME}} | {{#show: {{PAGENAME}} | ||
| ? | | ? | ||
Revision as of 11:27, 27 January 2010
Relationships
Outgoing
- Foreign key: clientid to clients.clientid
- Concept: clusterid to [[{{{5}}}]]
- Concept: clusterid to [[{{{5}}}]]
- Foreign key: cprodid to cprodlist.cprodid
- Foreign key: intid to interests.intid
- Foreign key: intid to interests.intid
- Foreign key: jitemid to log2.jitemid
- Foreign key: jitemid to log2.jitemid
- Foreign key: jitemid to log2.jitemid
- Foreign key: jitemid to log2.jitemid
- Foreign key: journalid to user.userid
- Foreign key: journalid to user.userid
- Foreign key: journalid to user.userid
- Foreign key: journalid to user.userid
- Foreign key: journalid to user.userid
- Foreign key: journalid to user.userid
- Foreign key: journalid to user.userid
- Foreign key: lastcapid to captchas.capid
- Foreign key: moodthemeid to moodthemes.moodthemeid
- Foreign key: ownerid to user.userid
- Foreign key: posterid to user.userid
- Foreign key: posterid to user.userid
- Foreign key: suggest_journalid to user.userid
- Foreign key: targetid to user.userid
- Foreign key: targetid to user.userid
- : themeid to themelist.themeid
- Foreign key: upropid to userproplist.upropid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid
- Foreign key: userid to user.userid"{{{PAGENAME}}}" cannot be used as a page name in this wiki.
Incoming
- Foreign key: userid from acctcode.userid
- Foreign key: userid from acctcode_promo.suggest_journalid
- Foreign key: userid from acctcode_request.userid
- Concept: from [[{{{5}}}]]
- Foreign key: userid from active_user.userid
- Concept: from [[{{{5}}}]]
- Foreign key: userid from authactions.userid
- Foreign key: userid from backupdirty.userid
- Foreign key: userid from birthdays.userid
- Foreign key: capid from captcha_session.lastcapid
- Foreign key: userid from captchas.userid
- Foreign key: clientid from clientusage.clientid
- Foreign key: userid from clientusage.userid
- Foreign key: userid from clustermove.userid
- Foreign key: userid from clustermove_inprogress.userid
- Foreign key: userid from clustertrack2.userid
- Foreign key: userid from commenturls.journalid
- Foreign key: userid from commenturls.posterid
- Foreign key: intid from comminterests.intid
- Foreign key: userid from comminterests.userid
- Foreign key: userid from community.ownerid
- Foreign key: userid from community.userid
- Foreign key: cprodid from cprod.cprodid
- Foreign key: userid from cprod.userid
- Foreign key: userid from identitymap.userid
- Foreign key: userid from infohistory.userid
- Foreign key: userid from log2.journalid
- Foreign key: userid from log2.posterid
- Foreign key: userid from logkwsum.journalid
- Foreign key: jitemid from logprop2.jitemid
- Foreign key: userid from logprop2.journalid
- Foreign key: jitemid from logsec2.jitemid
- Foreign key: userid from logsec2.journalid
- Foreign key: jitemid from logtagsrecent.jitemid
- Foreign key: userid from logtagsrecent.journalid
- Foreign key: jitemid from logtext2.jitemid
- Foreign key: userid from logtext2.journalid
- Foreign key: userid from password.userid
- Foreign key: userid from reluser.targetid
- Foreign key: userid from reluser.userid
- Foreign key: userid from reluser2.targetid
- Foreign key: userid from reluser2.userid
- Foreign key: moodthemeid from user.moodthemeid
- : themeid from user.themeid
- Foreign key: intid from userinterests.intid
- Foreign key: userid from userinterests.userid
- Foreign key: upropid from userproplite2.upropid
- Foreign key: userid from userproplite2.userid"{{{PAGENAME}}}" cannot be used as a page name in this wiki.
