Pages on this wiki related to Telecoms Package LawTracks are based upon a Mysql database. Some Perl scripts are run to populate this database and to extract informations from this database in order to create wiki pages. Hence these wiki pages can be viewed as a frontend to this database. However there is no real time synchronizations between the database and the wiki pages. Updates of the database from the wiki are frequently made in a semi-automatic way.
Download and license
A dump of the database, and Perl scripts can be downloaded freely, as well as sources of the PHP navigation form and templates for including other languages into the database.
All scripts are licensed under GNU General Public License version 3 or higher.
Description of the database
Tables
- tp_text
- tp_diff_texts
- tp_three_texts
- tp_versions
- tp_lang
- tp_origin
- tp_amending
- tp_amended
- tp_translations
Identifiers for chunks of text
Static tables
tp_versions
tp_lang
| id |
name
|
| en |
English
|
| fr |
Français
|
| de |
Deutsch
|
| es |
Español
|
tp_origin
| short_name |
lang |
name
|
| Commission |
en |
European Commission
|
| Parliament |
en |
European Parliament
|
| Council |
en |
Council of European Union
|
| JURI |
en |
Committee on Legal Affairs
|
| CULT |
en |
Committee on Culture and Education
|
| ECON |
en |
European Parliament Committee on Economic and Monetary Affairs
|
| LIBE |
en |
Committee on Civil Liberties, Justice and Home Affairs
|
| ITRE |
en |
Committee on Industry, Research and Energy
|
| IMCO |
en |
Committee on the Internal Market and Consumer Protection
|
tp_amending
| id |
lang |
number |
title
|
| 0 |
en |
NULL |
NULL
|
| 1 |
en |
COD/2007/0247 |
Proposal for a Directive of the European Parliament and of the Council amending Directives 2002/21/EC on a common regulatory framework for electronic communications networks and services, 2002/19/EC on access to, and interconnection of, electronic communications networks and services, and 2002/20/EC on the authorisation of electronic communications networks and services
|
| 2 |
en |
COD/2007/0248 |
Proposal for a Directive of the European Parliament and of the Council amending Directive 2002/22/EC on universal service and users' rights relating to electronic communications networks, Directive 2002/58/EC concerning the processing of personal data and the protection of privacy in the electronic communications sector and Regulation (EC) No 2006/2004 on consumer protection cooperation
|
tp_amended
| id |
lang |
number |
title |
short_name
|
| 0 |
en |
NULL |
NULL |
NULL
|
| 1 |
en |
2002/19/EC |
Directive on access to, and interconnection of, electronic communications networks and associated facilities |
Access
|
| 2 |
en |
2002/20/EC |
Directive on the authorisation of electronic communications networks and services |
Authorisation
|
| 3 |
en |
2002/21/EC |
Directive on a common regulatory framework for electronic communications networks and services |
Framework
|
| 4 |
en |
2002/22/EC |
Directive on universal service and users' rights relating to electronic communications networks and services |
Universal Service
|
| 5 |
en |
2002/58/EC |
Directive concerning the processing of personal data and the protection of privacy in the electronic communications sector |
ePrivacy
|
tp_translations
| id |
lang |
translation
|
| Title |
fr |
Titre
|
| Recital |
fr |
Considérant
|
| Article |
fr |
Article
|
| Annex |
fr |
Annexe
|
| Telecoms Package |
fr |
Paquet télécom
|
| Evolution |
fr |
Évolution
|
| Comparison |
fr |
Comparaison
|
How to add a translation
Help
Add this page to your book
Show book (0 pages)
Suggest pages