Difference between revisions of "Database Table: commenturls"
From Dreamwidth Notes
(Created page with 'commenturls =Definition= <source lang="sql"> CREATE TABLE commenturls ( posterid int unsigned NOT NULL, journalid int unsigned NOT NULL, jta...') |
Dreamnestia (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | + | = Definition = | |
| − | =Definition= | + | |
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE commenturls ( | CREATE TABLE commenturls ( | ||
| Line 12: | Line 12: | ||
</source> | </source> | ||
| − | =Relationships= | + | = Relationships = |
| − | + | ||
| − | Foreign key journalid to [[Database | + | Foreign key posterid to [[Database Tables: user|user]].userid |
| + | |||
| + | Foreign key journalid to [[Database Tables: user|user]].userid | ||
| + | |||
| + | = Location = | ||
| − | |||
[[Global database]] | [[Global database]] | ||
| + | |||
| + | [[Category: Database Tables|commenturls]] | ||
Revision as of 22:13, 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
