dbo.recentchanges

Columns

Column name1) 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.

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