User:SamanthaNguyen/Sandbox/DB table page

From mediawiki.org

Thought experiment on a complete, template-based page for DB tables on MediaWiki. A lot of stuff gets duplicated...

{{DB table
|name = actor
|introduced = 1.31
|desc =
|fields =

{{db column
|name = actor_id
|desc = The primary key, used to uniquely identify an actor.
}}
{{db column
|name = actor_user
|desc = A key to <code>{{manual|User table|user}}.user_id</code> of the user who made the action, or <code>NULL</code> for logged-out (IP) edits and for some mass imports.
}}
{{db column
|name = actor_name
|desc = The text of the username or the IP address of the actor.

In anonymous revisions imported from UseModWiki or early incarnations of the Phase II software, this field may contain an IP address with the final octet obscured (i.e. <code>\d{1,3}\.\d{1,3}\.\d{1,3}\.xxx</code> such as 24.150.61.xxx; see bug 3631). Some edits imported from UseModWiki may contain a Reverse DNS lookup hostname like <code>ppfree165-153-bz.aknet.it</code> or <code>office.bomis.com</code>.
}}

}}