Difference between revisions of "Database Table: commenturls"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Changing Category:Database Tables)
Line 22: Line 22:
 
[[Global database]]
 
[[Global database]]
  
[[Category: Database Tables|commenturls]]
+
[[Category:Database Tables Needing Conversion|commenturls]]

Revision as of 14:01, 2 October 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

Location

Global database