Re: IS 480: UML Final Design

[Clint Checketts]

Web Service and DB info:

SOAP Methods:
getAllCategories() returns an array of all the category IDs (or an array of id and names)
getPosts(categoryID, beginDate, endDate) returns an array of postObjects
getPost(postID) returns a single postObject
addPost(author,categoryID,title,description,pubdate,link) returns nothing, pubdate and link can be null (note the category will be ID based, but the author name/email can be passed in and resolved)
addCategory(categoryName) returns nothing


DB Schema:
posts table-
id (int)
author_id (int)
category_id (int)
title (varchar)
description (varchar)
pubdate (timestamp)
link (varchar)

authors table-
id (int)
name (varchar)
email (varchar)

categories table-
id (int)
name (varchar)



Please correct me regarding anything that seems wrong.

-Clint