Wagon

From wikiwad
Jump to: navigation, search

Contents

Shopping Wagon

Activity Log

  • April 16 2010
    • Initial database table design
    • Install subversion on abba
    • Install mysql on abba
  • April 21 2010
    • Assembled initial build.xml to allow ant
    • Integrated junit, added simple test case, "ant test" now works

Technologies

  • build tool: ant
  • IDE: eclipse
  • unit testing: JUnit
  • logging: jog4j
  • framework: spring
  • application server: tomcat
  • hosting OS for app server: Ubuntu server edition (linux)
  • Object-relational mapping: hibernate
  • database: MySQL for production, Hypersonic for development and testing
  • hosting OS for database server: Debian Lenny (linux)

Designs

Database

Tables

User

  • User_ID (PK)
  • User_Name
  • Password
  • First_Name
  • Last_Name
  • Address
  • Phone_Num
  • Email
  • User_Type
  • Creation_DT

Order

  • Order_Num (PK)
  • Order_Dat
  • Status_Code
  • Ship_DT
  • Fill_DT
  • Order_Submit
  • Pay_DT
  • Shipping_Amt

OrderItem

  • Item (FK)
  • Order_Num (FK)
  • Version (FK)
  • Quantity

Item

  • Item_Num (PK)
  • Version (PK)
  • Desc
  • Price
  • Cost
  • Quantity
  • Distributor

Session

  • Session_ID (PK)
  • Order_Num
  • Create_DT
Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox