Vital Signs Articles Specification

Vital Signs Articles Specification


I. Introduction

We want to build a system which allows administrators to add quarterly vital signs articles into the database. The administrator should then be able to map topics to these vital signs articles. These topics will be mapped to current medical service specialties in the database. There is a detail page for each division and clinical program in a medical service specialty. On this detail page, there will be a link to view all articles related to it.

II. Vital Signs Articles
  • Article ID
  • Title
  • Date Released
  • Content (clob)
III. Vital Signs Topics (Similar to Visiting Speakers Program Topics, but in a separate table)
  • Topic ID
  • Name
IV. Article to Topic Mapping
  • Topic ID
  • Article ID
  • Mapping Date
V. Medical Service Specialty to Topic Mapping
  • The query to get all the medical service specialties in the database is:
    	select category_id, 
    	       name 
    	from categories
    	here parent_category_id =
    		(select category_id
    	         from   categories
    		 where  name = 'Specialty'
    		 and    parent_category_id is null)
  • Specialty ID (category_id from the above query)
  • Topic ID
  • Mapping Date
VI. Data Model Requirements
  • Table for Articles
  • Table for Topics
  • Table for Article to Topic Mapping
  • Table for Topic to Medical Service Specialty Mapping
VII. Admin Requirements
  • View all articles
  • Add an article
  • Edit article
  • Delete article
  • View all topics
  • Add a topic
  • Edit topic
  • Delete topic
  • View all Articles Mapped to a Topic
  • Map Articles to topic
  • View all Topics Mapped to a Medical Services Specialty
  • Map Topic to Medical Service Specialty
VIII. User Requirements
  • On /institution/groups/detail have a display of all articles related to the group.
    (i.e. "Read related articles: link to article1, link to article2")

avni@avni.net