Difference: NewPurchaseSystemDesign (1 vs. 2)

Revision 22016-06-15 - JimSkon

Line: 1 to 1
 
META TOPICPARENT name="LIMRI.WebHome"

New Purchase System Design

Changed:
<
<

Organization

>
>
Database
<div id="_mcePaste">CREATE TABLE `accounts` (   `AccountName` varchar(20),   `Email` varchar(50),   `Password` varchar(30),   `First` varchar(30),   `Last` varchar(30),   `Phone` varchar(11),   `OrgAccount` varchar(20),   `OrgName` varchar(50),   `Type` enum(user,coach,organization,
admin),   `CreationTimestamp` timestamp,   PRIMARY KEY (`AccountName`) );</div>
<div id="_mcePaste">CREATE TABLE `account_inventories` (   `AccountName` varchar(20),   `IID` varchar(10),   `Pin` varchar(6),   `ProductCode` varchar(20),   `NickName` varchar(20),   PRIMARY KEY (`AccountName`, `IID`) );</div>
 
Deleted:
<
<
Organization.png
 
Changed:
<
<

Coach

>
>
CREATE TABLE `coupons` ( `Code` varchar(15), `OrgName` varchar(20), `Description` varchar(40), `UseCount` int, `UseLimit` int, `ProductCode` varchar(20), `Enabled` boolean, `ExpirationDate` date, `Discount` int, PRIMARY KEY (`Code`), FOREIGN KEY (`OrgName`), FOREIGN KEY (`ProductCode`) );
 
Deleted:
<
<
Coach.png
 
Deleted:
<
<

User

 
Changed:
<
<
User.png
>
>
CREATE TABLE `meta_inventories` ( `IID` varchar(10), `OrderId` varchar(255), `ProductCode` varchar(20), `Comment` varchar(255), PRIMARY KEY (`IID`) );

CREATE TABLE `orders` ( `OrderID` varchar(255), `AccountName` varchar(20), `OrderUpdateTimestamp` timestamp, `OrderStatus` varchar(255), `OrderTotal` decimal, `TxnID` varchar(255), `PaypalEmail` varchar(255), `CouponCode` varchar(15), `OrgName` varchar(20), PRIMARY KEY (`OrderID`), FOREIGN KEY (`CouponCode`) ); CREATE TABLE `order_purchases` ( `OrderID` varchar(255), `ProductCode` varchar(20), `Quantity` int, `TemplateName` char(10), PRIMARY KEY (`OrderID`, `ProductCode`), FOREIGN KEY (`TemplateName`) ); CREATE TABLE `Templates` ( `TemplateName` varchar(20), `TemplateDescription` vachar(1024), `CompatableProduct` varchar(20), `TemplateID` char(10), `OrgAccount` varchar(20), PRIMARY KEY (`TemplateName`), FOREIGN KEY (`CompatableProduct`, `TemplateID`), FOREIGN KEY (`OrgAccount`) ); CREATE TABLE `ActiveProduct` ( `Product` varchar(20), `TemplateName` varchar(20), PRIMARY KEY (`Product`, `TemplateName`) );

 
Added:
>
>

Organization

Organization.png

Coach

Coach.png

User

User.png

 
META FILEATTACHMENT attachment="Organization.png" attr="" comment="" date="1462370253" name="Organization.png" path="Organization.png" size="65340" user="JimSkon" version="1"
META FILEATTACHMENT attachment="Coach.png" attr="" comment="" date="1462370286" name="Coach.png" path="Coach.png" size="32580" user="JimSkon" version="1"

Revision 12016-05-04 - JimSkon

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="LIMRI.WebHome"

New Purchase System Design

Organization

Organization.png

Coach

Coach.png

User

User.png

META FILEATTACHMENT attachment="Organization.png" attr="" comment="" date="1462370253" name="Organization.png" path="Organization.png" size="65340" user="JimSkon" version="1"
META FILEATTACHMENT attachment="Coach.png" attr="" comment="" date="1462370286" name="Coach.png" path="Coach.png" size="32580" user="JimSkon" version="1"
META FILEATTACHMENT attachment="User.png" attr="" comment="" date="1462370311" name="User.png" path="User.png" size="44072" user="JimSkon" version="2"
META TOPICMOVED by="JimSkon" date="1462370186" from="LIMRI.NewPurchaseSystemDesign" to="Main.NewPurchaseSystemDesign"
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback