php postgresql website art register

Website Art Register Objective: To record pieces of art and their artists, agents and owners. Owners can sell to one another - the seller enters details of the buyer onto the website. The website generates emails to seller and buyer requesting/confirming information provided. Each art piece has a unique serial generated by the superadmin of website, plus a mod5 check digit that is passed to the buyer. The website allows for franchisees to buy serial numbers from the superadmin and in turn on-sell these to the owner. The Agent (eg insurance agent) must be able to query information as well. CSS: The website should allow for layout by divisions wherever possible, and standard fonts and colours that can be adjusted by the buyer later. Database PostgreSQL not MySQL. Home Page • General description of application (text to be added by this buyer later) • Contact details • Logo • Login box • Forgotten password email generator Login In EMAIL ADDRESS and PASSWORD Verify Page • Match email to databse contact list • Match password to email • Write login log entry • Branch to user type pages o Super admin o Franchisee o Agent o Owner o Error page Error Page • Opportunity for • re-input of email/password • forgotten password routine • return to Home Page • exit User Type Page: SuperAdmin Example: owner only Input Facilities • Form: add /edit Website serial o Unique job serial o Generate check digit modulus 11 • Form: add/edit asset • Form: add/edit owner • Form: add/edit franchisee • Form: add/edit agent • Form: Agent purchase of kits Output Facilities • Button: Generate owner verification emails • List: login log list (date range input form) • List: transaction log list (date range input form) • List: active Website serials • List: available Website serials • List: agent purchase details Transaction Log • Log: all queries • Log: all email requests Log out User Type Page: Franchisee Example: Tali Gallery Input Facilities • Form: add/edit asset • Form: add/edit customer • Form: query Website serial for items • Form: query customer for Website items • Form: Owner purchase of kits Output Facilities • List: assets and serials for given owner • List: assets for given serial Transaction Log • Log: all queries • Log: all email requests Log out User Type Page: Agent Example: Insurance Agent Input Facilities • Form: query Website serial for items • Form: Query title for items • Form: query customer for Website items Output Facilities • List: assets and serials for given owner • List: assets for given serial Transaction Log • Log: all queries • Log: all email requests Log out User Type Page: Owner Example: Tali Gallery ?? Input Facilities • Form: Register Transfer • Form: new contact details • Form: change my contact details • Form: add/edit asset Output Facilities • Email: sent to new contact • List: assets and serials Transaction Log • Log: all queries • Log: all email requests Log out Program Logic • Needs https? • Hide contact ID in URL • No prices in system Program Validation SuperAdmin • Check digit modulus for entering Website Agent • Match serial to contact • Match contact to admin list?? Database Schema Asset Table • Primary Key: AssetID • Foreign key: AssetCatID • Foreign key: SourceID (SerialSource) • ItemName • Description • Artist • Medium • CreatedDate • Size • Framed • Condition • Photo (attachment) • Acquired Date • SellDate • Location • Agent • Model • Comments • Retired Date • Inventory • AlternateCode • ArtCodeCountry • ArtCodeSerial • SerialMod5 Asset Category Table • Primary Key: AssetCatID • AssetCategory Serial Source Table • Primary Key: SourceID • SerialSource Contacts Table • Primary Key: ContactID • Foreign key: ContactTYpeID (ContactType) • Company • Last Name • First Name • E-mail Address • ContactPassword • Business Phone • Mobile Phone • Fax Number • Address • City • State/Province • ZIP/Postal Code • Country/Region • Web Page • Notes Contact Types Table • Primary Key: ContactTypeID • Con