/* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-start */ /* Net.FireFive.ERModel.Dokuwiki.TablePage.Notes-end */ /* Net.FireFive.ERModel.Dokuwiki.TablePage.Header-start */ ====== dbo.recentchanges ====== /* 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** |__**rc_id**__ |INT | | | | |**rc_timestamp** |VARCHAR(14) | | | |**[[dbo.mwuser|FK1]]** |**rc_user** |INT | | | | |**rc_user_text** |NVARCHAR(255) | | | | |**rc_namespace** |INT | | | | |**rc_title** |NVARCHAR(255) | | | | |**rc_comment** |NVARCHAR(255) | | | | |**rc_minor** |BIT | | | | |**rc_bot** |BIT | | | | |**rc_new** |BIT | | | | |rc_cur_id |INT | | | | |rc_this_oldid |INT | | | | |rc_last_oldid |INT | | | | |**rc_type** |TINYINT | | | | |**rc_source** |NVARCHAR(16) | | | | |**rc_patrolled** |BIT | | | | |**rc_ip** |NVARCHAR(40) | | | | |rc_old_len |INT | | | | |rc_new_len |INT | | | | |**rc_deleted** |TINYINT | | | |[[dbo.logging|FK2]] |rc_logid |INT | | | | |rc_log_type |NVARCHAR(255) | | | | |rc_log_action |NVARCHAR(255) | | | | |rc_params |NVARCHAR(MAX) | | | /* 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) ^ |FK2 |rc_logid |[[dbo.logging]] |log_id | |FK1 |rc_user |[[dbo.mwuser]] |user_id | ==== References to this table from others ==== ^Relationship ^Attributes \\ (in referencing table) ^Referenced attributes \\ (in this table) ^ |[[dbo.change_tag]].FK2 |ct_rc_id |rc_id | |[[dbo.tag_summary]].FK2 |ts_rc_id |rc_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 */