Web hosting Directory

Table of contents

Requirements

Functions

  1. A webhost must register first to submit information. Once authorized and authenticated, a webhost can submit information.
  2. One user can have muliple web host accounts.
  3. Each web host account can have multiple plans
  4. Each plan can have many attributes.
  5. Each submitted web host must be moderated.
  6. A confirmation email should be sent to the user when he submits information.
  7. A confirmation email should be sent to the user when the listing is live.

Views

  1. User should be able to browse web host's directory By Country, By State, By City, By ZipCode, By Rating, By OS Type, By Customer base etc...
  2. User should be able search the directory based on any web host or web host plan related attributes.
  3. Authorized/Authenticated user should be able to update / delete the information, subject to moderation.

Analysis & Design

Entities

  • JMDMODWebHost
FieldName DataType Required Description
ID UniqueIdentifier Y Primary Key
BusinessName nvarchar(100) Y Legal Business Name
BusinessStartDate DateTime Y Business Start Date
URL nvarchar(255) Y url for the website
ResellerURL nvarchar(255) N URL of the website, if this web host is a reseller
DateSubmitted DateTime Y Last submitted or update date
AffiliateURL nvarchar(500) N Internal: redirect URL , if affiliated
TotalClicks int N Internal: Clicks Tracking
IsActive int Y Internal. 1=Active, 0=Inactive
User_Id int Y Internal. FK
Thumbnail nvarchar(50) N Internal


  • JMDMODWebHostPlan
FieldName DataType Required Description
ID UniqueIdentifier Y Primary Key
WebHostId UniqueIdentifier Y FK. JMD_WebHost
Name nvarchar(50) Y Name of the webhosting plan

  • JMDMODWebHostPlanType
FieldName DataType Required Description
ID UniqueIdentifier Y Primary Key
PlanType nvarchar(50) Y Plan Type i.e. Shared, Dedicated, VPS etc...


  • JMDMODWebHostPlanOSType
FieldName DataType Required Description
ID UniqueIdentifier Y Primary Key
OSType nvarchar(50) Y Operating System Type i.e. Windows, Linux etc...

  • JMDMODWebHostPlanPropertyGroup
FieldName DataType Required Description
ID UniqueIdentifier Y Primary Key
GroupName nvarchar(100) Y Name of the property


  • JMDMODWebHostPlanProperty
FieldName DataType Required Description
ID UniqueIdentifier Y Primary Key
PropertyName nvarchar(100) Y Name of the property
PlanPropertyGroupId UniqueIdentifier Y FK JMD_WebHostPlanPropertyGroup
Sort int Y Order of properties listing


  • JMDMODWebHostPlanDetail
FieldName DataType Required Description
ID UniqueIdentifier Y Primary Key
WebHostPlanId UniqueIdentifier Y FK JMD_WebHostPlan
WebHostPlanPropertyId UniqueIdentifier Y FK JMD_WebHostPlanProperty
Value nvarchar(1000) Y Property Value


  • JMDMODWebHostReviews
FieldName DataType Required Description
ID UniqueIdentifier Y Primary Key


  • JMDMODWebHostSponsors
FieldName DataType Required Description
ID UniqueIdentifier Y Primary Key

Entity Relationship Diagram

WebHostingDirectory.jpg

Object Relational Mapping Diagram

Implementation

Test

Deployment

Configuration & Change Management

Environment

Last edited Jan 12, 2008 at 5:11 PM by handaajay15, version 53

Comments

No comments yet.