Table of Contents

Columns
Relationships
- References to other tables
- References to this table from others

dbo.ipblocks

Columns

	Column name¹⁾	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.

¹⁾

Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.