Table of Contents

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

dbo.recentchanges

Columns

	Column name¹⁾	Column type	Description	Notes
PK	rc_id	INT
	rc_timestamp	VARCHAR(14)
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
FK2	rc_logid	INT
	rc_log_type	NVARCHAR(255)
	rc_log_action	NVARCHAR(255)
	rc_params	NVARCHAR(MAX)

Relationships

This table belongs to the 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

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.