Table of Contents

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

dbo.archive

Columns

	Column name¹⁾	Column type	Description	Notes
PK	ar_id	INT
	ar_namespace	SMALLINT
	ar_title	NVARCHAR(255)
	ar_text	NVARCHAR(MAX)
	ar_comment	NVARCHAR(255)
FK1	ar_user	INT
	ar_user_text	NVARCHAR(255)
	ar_timestamp	VARCHAR(14)
	ar_minor_edit	BIT
	ar_flags	NVARCHAR(255)
	ar_rev_id	INT
FK2	ar_text_id	INT
	ar_deleted	TINYINT
	ar_len	INT
	ar_page_id	INT
	ar_parent_id	INT
	ar_sha1	NVARCHAR(32)
	ar_content_model	NVARCHAR(32)
	ar_content_format	NVARCHAR(64)

Relationships

This table belongs to the Content module.

References to other tables

	Attributes (in this table)	Referenced table	Referenced attributes (in referenced table)
FK1	ar_user	dbo.mwuser	user_id
FK2	ar_text_id	dbo.text	old_id

References to this table from others

Relationship	Attributes (in referencing table)	Referenced attributes (in this table)
(None).

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.