Difference between revisions of "Database Table: commenturls"
From Dreamwidth Notes
Dreamnestia (Talk | contribs) |
Dreamnestia (Talk | contribs) |
||
| Line 14: | Line 14: | ||
= Relationships = | = Relationships = | ||
| − | Foreign key posterid to [[Database | + | Foreign key posterid to [[Database Table: user|user]].userid |
| − | Foreign key journalid to [[Database | + | Foreign key journalid to [[Database Table: user|user]].userid |
= Location = | = Location = | ||
Revision as of 22:21, 30 March 2009
Definition
CREATE TABLE commenturls ( posterid INT UNSIGNED NOT NULL, journalid INT UNSIGNED NOT NULL, jtalkid mediumint UNSIGNED NOT NULL, timecreate INT UNSIGNED NOT NULL, url VARCHAR(255) NOT NULL, INDEX (timecreate) )
Relationships
Foreign key posterid to user.userid
Foreign key journalid to user.userid
