New database structure admin: Difference between revisions

(Created page with "The following pages have been added to the new database structure - what improvements could be made? <div class="row"> <div class="large-4 columns"> ==Cases== {{#cargo_query:...")
 
 
(12 intermediate revisions by the same user not shown)
Line 1: Line 1:
The following pages have been added to the new database structure - what improvements could be made?
==Progress==
{|class="wikitable"
!What !! Done !! Still to do !! Comments
|-
! Cases
| {{Count pages in database table|Cases}}
| {{Count pages in category|category=Transcript¦No transcript|notcategory=Cases}}
| Total is {{Count pages in category|category=Transcript¦No transcript¦Cases}}. Use [[Mental health case law admin]] to add new cases.
|-
! Resources
| {{Count pages in database table|Resources}}
| ?
| The database includes [[Books]] and [[Consultations]]. Impossible to know how many items are still to go, as most were just external links on pages.
|-
! Legislation
| {{Count pages in database table|Legislation}}
| {{Count pages in category|category=Mental Health Act 2007 commencement orders‎¦Mental Health Act 2007 secondary legislation - England‎¦Mental Health Act 2007 secondary legislation - England and Wales‎¦Mental Health Act 2007 secondary legislation - Scotland‎¦Mental Health Act 2007 secondary legislation - Wales‎¦Legislation amending MHA 1983‎¦Mental Health Regulations‎¦Tribunal legislation‎¦Tribunal resources‎¦Mental Capacity Act 2005 commencement orders‎¦Mental Capacity Act 2005 secondary legislation - DOLS‎¦Mental Capacity Act 2005 secondary legislation - IMCA‎¦Mental Capacity Act 2005 secondary legislation - Other‎¦Mental Capacity Act 2005 secondary legislation - Public Guardian and Court of Protection‎¦Mental Capacity Act 2005 secondary legislation - Research‎¦Legal Aid legislation‎¦Other useful legislation‎¦Miscellaneous legislation|notcategory=Legislation‎}}
| Use [[Legislation to add to new database structure]] to add new legislation.
|-
! Information
| {{Count pages in category|category=Coronavirus‎‎¦CPD‎‎¦General information pages‎‎¦Legal Aid‎‎¦Nearest relative‎‎¦Legal Aid archive‎¦Legal Aid eligibility‎‎¦‎Main types of funding‎ ¦Changing the nearest relative‎¦Nearest relative powers‎‎¦‎Northern Ireland‎¦Scotland‎ ‎¦‎Southern Ireland‎¦Wales‎¦Statistics‎ ‎¦The Law Society‎}}
| {{Count pages in category|category=Changes made by MHA 2007‎¦Mental Capacity Act 2005 provisions‎ ¦Miscellaneous articles‎ ¦Organisations ¦Other resources‎ ¦Routes to discharge ¦Types of detention‎ ¦Types of discharge‎ ¦Types of patient}}
| The new information pages are better structured, but are ''not'' in the database.
|-
! Jobs
| {{Count pages in database table|Jobs}}
| 0
|
|-
! Events
| {{Count pages in database table|Events}}
| 0
|
|-
! Contacts
| {{Count pages in database table|Contact}}
| 0
|
|}
 
==Database==
The following pages have been added to the new database structure.
<div class="row">
<div class="row">
<div class="large-4 columns">
<div class="large-4 columns">
==Cases==
{{database header|CASES}}
{{#cargo_query:
{{#cargo_query:
tables=Cases
tables=Cases
|format=ul
|format=ul
|limit=20
}}
}}
</div>
</div>
<div class="large-4 columns">
<div class="large-4 columns">
==Legislation==
{{database header|LEGISLATION}}
{{#cargo_query:
{{#cargo_query:
tables=Legislation
tables=Legislation
|format=ul
|format=ul
|limit=20
}}
}}
</div>
</div>
<div class="large-4 columns">
<div class="large-4 columns">
==Items==
{{database header|RESOURCES}}
{{#cargo_query:
{{#cargo_query:
tables=Items
tables=Resources
|format=ul
|format=ul
|limit=20
}}
}}
</div>
</div>

Latest revision as of 13:11, 13 November 2020

Progress

What Done Still to do Comments
Cases 843 1,649 Total is 2,487. Use Mental health case law admin to add new cases.
Resources 1,140 ? The database includes Books and Consultations. Impossible to know how many items are still to go, as most were just external links on pages.
Legislation 393 345 Use Legislation to add to new database structure to add new legislation.
Information 98 94 The new information pages are better structured, but are not in the database.
Jobs 92 0
Events 522 0
Contacts 329 0

Database

The following pages have been added to the new database structure.

RESOURCES DATABASE

More...