Difference between revisions of "Database Table: community"
From Dreamwidth Notes
Dreamnestia (Talk | contribs) |
|||
| Line 1: | Line 1: | ||
This stores information about communities. UserID points to the user record for the community itself, and ownerid points the user who owns the community. | This stores information about communities. UserID points to the user record for the community itself, and ownerid points the user who owns the community. | ||
| − | + | = Definition = | |
| − | =Definition= | + | |
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE community ( | CREATE TABLE community ( | ||
| Line 13: | Line 13: | ||
</source> | </source> | ||
| − | =Relationships= | + | = Relationships = |
| + | |||
*Foreign key userid to [[Database Table: user| user]].userid | *Foreign key userid to [[Database Table: user| user]].userid | ||
*Foreign key ownerid to [[Database Table: user| user]].userid | *Foreign key ownerid to [[Database Table: user| user]].userid | ||
| − | =Location= | + | = Location = |
| − | Global | + | |
| + | [[Global database]] | ||
| + | |||
| + | [[Category: Database Tables|community]] | ||
Revision as of 22:20, 30 March 2009
This stores information about communities. UserID points to the user record for the community itself, and ownerid points the user who owns the community.
Definition
CREATE TABLE community ( userid INT(10) UNSIGNED NOT NULL DEFAULT '0', ownerid INT(10) UNSIGNED NOT NULL DEFAULT '0', membership enum('open','closed') NOT NULL DEFAULT 'open', postlevel enum('members','select','screened') DEFAULT NULL, PRIMARY KEY (userid) )
