ELISAD GATEWAY DATABASE STRUCTURE
- COMPLETE FIELDS AND TABLES OF THE ONLINE FORM -
ARCHIDO: Susanna Prepeliczay, Bernd Titz
Field names and answering options names, MARCH 13, 2002
PUBLISHER (institution / organisation)
| Field name | type of input / names of choice options (=output) |
| publisher_institution_ol | freetext size: 100 |
| publisher_institution_en | freetext size: 100 |
| acronyme | freetext size: 20 |
| country |
28 pulldown menue choices à table country_options
Austria / Belgium / Bulgaria / Czech Republic / Denmark / Finland / France / Greece / Germany / Hungary / Iceland / Eire / Italy / Luxembourg / Netherlands / Norway / Poland / Portugal / Slovenia / Slovakia / Spain / Sweden / Switzerland / United Kingdom / Yugoslavia / Europe / International |
| country_ft | freetext |
| producer_description [] | freetext size: 60 |
| subject[] |
7 checkbox options à table subject_options documentation and publishing / policy / prevention / research / services / treatment / economy |
| other_subject | freetext size: 60 |
WEBSITE DESCRIPTION
| Field name | type of input / names of choice options (=output) | |
| title_ol | freetext size: 100 | |
| URL | freetext size: 50 | |
| language[] |
18 checkbox options à table language_options
Czech / Danish / Dutch / English / Finnish / French / German / Greek / Hungarian / Italian / Norwegian / Portuguese / Polish / Russian / Spanish / Slovak / Slovenian / Swedish |
|
| language_ft | freetext | |
| audience | freetext size: 60 | |
| targetgroup_audience[] |
16 checkbox options à table targetgroup_options
practitioners / researchers / drug users / general public / health professionals / politicians / prevention actors / prisoners / students / adolescents / children / ethnic groups / gay men/lesbians / parents / women / young adults |
|
WEBSITE CONTENT I: TOPICS COVERAGE
1 information on PSYCHOACTIVE SUBSTANCES, ADDICTIVE BEHAVIOR, TARGET GROUPS
| Field name | type of input / names of choice options (=output) |
| substance_ft | freetext size: 200 |
| substance_info[] |
20 checkbox options à table substance_options
alcohol / amphetamines / buprenorphine / cannabis / cocaine / crack / coffee / doping substances / hallucinogens / heroin / opium / inhalants / LSD / ecstasy / methadone / opiate substitutes / prescription drugs / tobacco / synthetic drugs / smart drugs |
| addictive_behavior_ft | freetext size: 200 |
| addictive_behavior[] |
7 checkbox options à table addiction_options
computer and internet / drug addiction / eating disorders / pathological gambling / sexual relations / compulsive shopping / workaholism |
| druguse_consequences_ft | freetext size: 200 |
| health_consequence[] |
8 checkbox options à table health_consequence_options
AIDS / hepatitis / somatic pathologies / psychological disorders / |
| social_consequence[] |
7 checkbox options à table social_consequence_options
|
| positive_consequence[] |
7 checkbox optionsà table positive_consequence_options
creativity / performance enhancement / hedonism and leisure / relaxation / medication / self exploration / therapeutical effect |
2 information on TREATMENT
| Field name | type of input / names of choice options (=output) |
| treatment_ft | freetext size: 200 |
| treatment[] |
19 checkbox options à table treatment_options
diagnosis / drug-free treatment / substitution / psychotherapy / self-help group / family therapy / case management / aftercare / detoxification / addiction cure heroin distribution / hospital / alcoholism cure hospital / psychiatric clinic / therapeutic communities / short-term therapy / long-term therapy / rehabilitation / treatment effectiveness and guidelines / tr. statistics |
3 information on SERVICES
| Field name | type of input / names of choice options (=output) |
| services_ft | freetext size: 200 |
| services[] |
14 checkbox options à table sevices_options
accomodation / counseling / crisis and emergency intervention / contact cafe / consumption room / outreach work / psychosocial care / rehabilitation / self help initiatives / syringe exchange / legal advise / emergency shelter / telephone helpline / elementary offers |
4 information on POLICY
| Field name | type of input / names of choice options (=output) |
| policy_ft | freetext size: 200 |
| political_activity[] |
8 checkbox options à table political_activities_options
legislation and jurisprudence / prevention policy / treatment policy / harm reduction policy / prescription policy / prison policy / specific target groups policy / public health policy / |
5 information on RESEARCH
| Field name | type of input / names of choice options (=output) |
| research_ft | freetext size: 200 |
| research_discipline[] |
9 checkbox options à table research_discipline_options
biology / medicine / multidisciplinary / neurosciences / pharmacology / policy / psychiatry / psychology / social sciences |
| research_focus[] |
11 checkbox options à table research_focus_options
clinical study / epidemiology / statistics / evaluation / experimental / theory / qualitative / computerised approach / conferences / lectures |
6 information on DOCUMENTATION, PUBLISHING & CULTURE
| Field name | type of input / names of choice options (=output) |
| docu_info_ft | freetext size : 200 |
| documentation_information[] |
10 checkbox options à table documentation_information_options library / documentation centre / information producer / information provider / internet resources provider / internet gateway / book publisher / journal / network / audiovisual media |
| bibliographic_collection_ft | freetext size: 120 |
| culture_ft | freetext size : 200 |
| culture[] |
6 checkbox options à table culture_options
arts / film / history / fiction / subculture / rituals of use / ethnography |
7 information on PREVENTION
| Field name | type of input / names of choice options (=output) |
| prevention_ft | freetext size: 200 |
| prevention_focus[] |
11 checkbox options à table prevention_focus_options
abstinence / demand reduction / prevention of first use / prevention of problematic use / prevention of addiction / harm reduction / prevention strategies and outcome / protective factors / risk factors / moderation / selfcontrol |
| prevention_action[] |
13 checkbox options à table prevention_action_options
health education / school prevention / life skills programs / professionals training / media campaigns / conferences / information measures and strategies / cost-benefit analysis and evaluation / safer drug use / safer sex measures / relapse prevention / workingplace / traffic safety |
7 information on ECONOMY and TRADE
| Field name | type of input / names of choice options (=output) |
| economy_ft | freetext size: 200 |
| economy_options[] |
12 checkbox options à table economy_options
commerce / cost factors / criminal organisation / distribution / geopolitics / illegal economy / marketing and advertising / prices and tax / production / smuggle / trade / trafficking |
WEBSITE CONTENT II: TYPES OF INFORMATION AVAILABLE
| Field name | type of input / names of choice options (=output) / size (no. of types) |
| www_database_ft | freetext size: 200 |
| www_database[] |
11 checkbox options à table www_database_options
audiovisual media database / bibliographic database / fulltext documents database / images database / legal texts database / prevention activities database / prevention tools database / research projects database / research instruments database / statistics database / AOD treatment and services database |
| www_collections_ft | freetext size: 200 |
| www_collections[] |
7 checkbox options à table www_database_options
services and addresses / bibliographies, references, publicationlists / conference infos and agendas / staff contact addresses / AOD institutions websites links / online publications links / online publishers links |
| www_fulltext_materials_ft | freetext size: 200 |
| www_fulltext_materials[] |
13 checkbox options à table www_fulltext_materials_options conference proceedings / legal texts / research reports / research abstracts / substance info sheets / AOD use epidemiology and statistics / treatment statistics / drug experiences self reports / journal articles / pictures / prevention tools / research methods and instruments / software and electronic tools |
| interactive_services_ft | freetext size: 200 |
| interactive_services[] |
11 checkbox options à table interactive_services_options
awareness alerting service / chatroom / contact addresses / educational games / expert forum / FAQ section / mailing list / newsgroups / news section / online evaluation form / online questionnaire |
| format_ft | freetext size: 50 |
| format[] |
4 checkbox options à table format_options
HTML / PDF / Word documents / GIF and JPG |
EVALUATION PART
| Field name | type of input / names of choice options (=output) |
| description_summary | freetext size: lines 20, columns 40, br= virtual |
| keywords | freetext size: 100 |
| comments_userfriendliness | freetext size: 100 |
| access_criteria[] |
7 checkbox options à table access_criteria_options
site search / online help / sitemap / easy navigation / clear structure / staff email contact available / mission statement available |
| author_rating | radio value 1 / 2 / 3 / 4 / 5 |
| goal_rating | radio value 1 / 2 / 3 / 4 / 5 |
| scope_rating | radio value 1 / 2 / 3 / 4 / 5 |
| content_rating | radio value 1 / 2 / 3 / 4 / 5 |
| presentation_rating | radio value 1 / 2 / 3 / 4 / 5 |
| recommendation_rating | radio value 1 / 2 / 3 / 4 / 5 |
| recommendation | checkbox "yes" |
| administrator_email | freetext size: 50 |
| evaluator | freetext size: 50 |
| evaluator_email | freetext size: 50 |
| evaluation_date | date size: 10 |
| evaluation_form_comments | freetext size: 100 |
Keyword catalogue = checkbox options / Tables
| Keyword Tables Names | Anzahl Felder / Namen |
| access_criteria_options | 7 |
| addiction_otions | 7 |
| country_options | 28 |
| culture_options | 7 |
| documentation_information_options | 10 |
| format_options | 4 |
| health_consequence_options | 4 |
| interactive_services_options | 11 |
| language_options | 18 |
| organisation_level_options | 5 |
| economy_options | 12 |
| political_activities_options | 8 |
| positive_consequence_options | 8 |
| prevention_action_options | 14 |
| prevention_focus_options | 11 |
| research_discipline_options | 9 |
| research_focus_options | 10 |
| services_options | 14 |
| social_consequence_options | 7 |
| subject_options | 7 |
| substance_options | 20 |
| targetgroup_options | 16 |
| treatment_options | 19 |
| type_organisation_options | deleted |
| www_collections_options | 7 |
| www_database_options | 11 |
| www_fulltext_materials_options | 13 |