/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-start */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */
====== dbo.ipblocks ======


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-start */
===== Columns =====
^ ^Column name((Columns with names in **bold** are non-nullable; columns with __underlined__ names are participants in the table's primary key.))  ^Column type  ^Description   ^Notes   ^
|**PK**  |__**ipb_id**__  |INT  |  |  |
|  |**ipb_address**  |NVARCHAR(255)  |  |  |
|[[dbo.mwuser|FK1]]  |ipb_user  |INT  |  |  |
|[[dbo.mwuser|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  |  |  |
|[[dbo.ipblocks|FK3]]  |ipb_parent_block_id  |INT  |  |  |

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Columns-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-start */
===== Relationships =====
This table belongs to the [[projects:dbexplorer:samples:mediawiki:Mediawiki database schema:Users|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).   |||


/* Net.FireFive.ERModel.Dokuwiki.TablePage.Relationships-end */

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-start */
----
Page generated from database metadata by [[https://richardswinbank.net/DbScout|DbScout]].

/* Net.FireFive.ERModel.Dokuwiki.TablePage.Footer-end */