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

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

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


/* 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**  |__**rev_id**__  |INT  |  |  |
|**[[dbo.page|FK2]]**  |**rev_page**  |INT  |  |  |
|**[[dbo.text|FK4]]**  |**rev_text_id**  |INT  |  |  |
|  |**rev_comment**  |NVARCHAR(255)  |  |  |
|[[dbo.mwuser|FK1]]  |rev_user  |INT  |  |  |
|  |**rev_user_text**  |NVARCHAR(255)  |  |  |
|  |**rev_timestamp**  |VARCHAR(14)  |  |  |
|  |**rev_minor_edit**  |BIT  |  |  |
|  |**rev_deleted**  |TINYINT  |  |  |
|  |rev_len  |INT  |  |  |
|[[dbo.revision|FK3]]  |rev_parent_id  |INT  |  |  |
|  |**rev_sha1**  |NVARCHAR(32)  |  |  |
|  |rev_content_model  |NVARCHAR(32)  |  |  |
|  |rev_content_format  |NVARCHAR(64)  |  |  |

/* 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:Content|Content]] module.
==== References to other tables ====

^  ^Attributes \\ (in this table)  ^Referenced table  ^Referenced attributes \\  (in referenced table)   ^
|FK1  |rev_user  |[[dbo.mwuser]]  |user_id  |
|FK2  |rev_page  |[[dbo.page]]  |page_id  |
|FK3  |rev_parent_id  |[[dbo.revision]] (self-reference)  |rev_id  |
|FK4  |rev_text_id  |[[dbo.text]]  |old_id  |

==== References to this table from others ====

^Relationship  ^Attributes \\ (in referencing table)  ^Referenced attributes \\ (in this table)   ^
|[[dbo.change_tag]].FK1  |ct_rev_id  |rev_id  |
|[[dbo.page]].FK1  |page_latest  |rev_id  |
|[[dbo.tag_summary]].FK1  |ts_rev_id  |rev_id  |


/* 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 */