Difference between revisions of "Database Table: cprodlist"
From Dreamwidth Notes
(Created page with 'This table supports the prodding feature not currently supported in Dreamwidth. cprodlist =Definition= <source lang="sql"> CREATE TABLE cprodlist ( ...') |
Dreamnestia (Talk | contribs) |
||
| Line 1: | Line 1: | ||
This table supports the prodding feature not currently supported in Dreamwidth. | This table supports the prodding feature not currently supported in Dreamwidth. | ||
| − | + | = Definition = | |
| − | =Definition= | + | |
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE cprodlist ( | CREATE TABLE cprodlist ( | ||
| Line 11: | Line 11: | ||
</source> | </source> | ||
| − | =Relationships= | + | = Relationships = |
| + | |||
Foreign key cprodid to [[Database Table: cprod|cprod]].cprodid | Foreign key cprodid to [[Database Table: cprod|cprod]].cprodid | ||
| − | =Location= | + | = Location = |
| + | |||
[[Global database]] | [[Global database]] | ||
| + | |||
| + | [[Category: Database Tables|cprodlist]] | ||
Revision as of 11:16, 31 March 2009
This table supports the prodding feature not currently supported in Dreamwidth.
Definition
CREATE TABLE cprodlist ( cprodid SMALLINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, class VARCHAR(100), UNIQUE (class) )
Relationships
Foreign key cprodid to cprod.cprodid
