dbo.ipblocks
Columns
| Column name1) | Column type | Description | Notes | |
|---|---|---|---|---|
| PK | ipb_id | INT | ||
| ipb_address | NVARCHAR(255) | |||
| FK1 | ipb_user | INT | ||
| FK2 | ipb_by | INT | ||
| ipb_by_text | NVARCHAR(255) | |||
| ipb_reason | NVARCHAR(255) | |||
| ipb_timestamp | VARCHAR(14) | |||
| ipb_auto | BIT | |||
| ipb_anon_only | BIT | |||
| ipb_create_account | BIT | |||
| ipb_enable_autoblock | BIT | |||
| ipb_expiry | VARCHAR(14) | |||
| ipb_range_start | VARCHAR(255) | |||
| ipb_range_end | VARCHAR(255) | |||
| ipb_deleted | BIT | |||
| ipb_block_email | BIT | |||
| ipb_allow_usertalk | BIT | |||
| FK3 | ipb_parent_block_id | INT |
Relationships
This table belongs to the Users module.
References to other tables
| Attributes (in this table) | Referenced table | Referenced attributes (in referenced table) |
|
|---|---|---|---|
| FK3 | ipb_parent_block_id | dbo.ipblocks (self-reference) | ipb_id |
| FK2 | ipb_by | dbo.mwuser | user_id |
| FK1 | ipb_user | dbo.mwuser | user_id |
References to this table from others
| Relationship | Attributes (in referencing table) | Referenced attributes (in this table) |
|---|---|---|
| (None). | ||
Page generated from database metadata by DbScout.
1)
Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.