Difference between revisions of "Database Table: has subs"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'has_subs =Definition= <source lang="sql"> CREATE TABLE has_subs ( journalid INT UNSIGNED NOT NULL, etypeid INT UNSIGNED NOT NULL, arg1 ...')
 
m (reformat, right category)
Line 1: Line 1:
[[Category: Database Table|has_subs]]
+
= Definition =
=Definition=
+
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE has_subs (
 
CREATE TABLE has_subs (
Line 13: Line 13:
 
</source>
 
</source>
  
=Relationships=
+
= Relationships =
 +
 
 +
= Location =
  
=Location=
 
 
[[Clustered database]]
 
[[Clustered database]]
 +
 +
[[Category: Database Tables|has_subs]]

Revision as of 20:41, 26 March 2009

Definition

CREATE TABLE has_subs (
  journalid  INT UNSIGNED NOT NULL,
  etypeid    INT UNSIGNED NOT NULL,
  arg1       INT UNSIGNED NOT NULL,
  arg2       INT UNSIGNED NOT NULL,
  PRIMARY KEY (journalid, etypeid, arg1, arg2),
 
  verifytime   INT UNSIGNED NOT NULL
)

Relationships

Location

Clustered database