Integration Guide

Appendix A
WaveWorks PSS, Integration Guide, 1.10 Page 121
© 2000, Symbol Technologies, Inc. February 1, 2000
Appendix A Database Layout Diagram
The following diagram represents the database layout for the WaveWorks PSS system.
PSS_Admin_Menu
Menu_ID: int
Menu_Title:
h
(30)
Show_System_Status: char(1)
Show_Title: char(1)
Show_Image: char(1)
Show_Status_Line: char(1)
Authenticated: char(1)
Disabled: char(1)
Parent_Menu_ID: int
Target_Page_Name:
h (40)
Button_Columns: int
Special_Type: int
Refresh_Seconds: int
PSS_Admin_Action
Action_ID: int
Description:
h (60)
Privilege_Level: int
Disabled: char(1)
PSS_Marketing_Sent
Customer_ID: int
Shopping_List_ID: int
Marketing_Datetime: datetime
Item_ID:
h (20)
Dept_ID: int
Mfg_ID: int
V1.06 version
PSS_Customer_Suspend_Reaso
Suspend_ID: int
Suspend_Reason:
h (80)
PSS_Admin_User
Username:
h (20)
Full_Name:
h (80)
Password:
h (20)
Valid_Datetime: datetime
Expires_Datetime: datetime
Privilege_Level: int
Privilege_Mask:
h (255)
Login_Failures: int
Last_IP: varchar(16)
Language_ID: int
WIZARD:PSS3
PSS_Text
Text_ID: int
Language_ID: int
Constant_Name:
h (40)
Text: varchar(255)
PSS_Opening_Message
Msg_ID: int
Sequence: int
Language_ID: int
Message: varchar(20)
Start_Datetime: datetime
End_Datetime: datetime
Target_Rank: int
Symbol Technologies, Inc.,
Confidential and
Pit
PSS_Customer
Customer_ID: int
Card_Number:
h (30)
First_Name:
h (40)
Middle_Name:
h (40)
Last_Name:
h (40)
Address: varchar(40)
Address2: varchar(40)
City: varchar(40)
State: varchar(40)
Postal_Code:
h (20)
Country:
h (40)
Allow_Promotions: char(1)
Allow_Checks: char(1)
Currency_ID: int
Language_ID: int
Rescan_Level: int
Rank: int
Suspend_Reason:
h (80)
Card_Expiration_Datetime: datetime
Num_Trips: int
Num_Trips_Since_Rescan: int
Last_Trip_Datetime: datetime
First_Trip_Accurate: char(1)
Greeting_Text:
h (255)
Registered_Datetime: datetime
Display_Foodstamp: char(1)
Special_Customer: char(1)
Suspend_ID: int
Num_Rescans: int
Group_ID: int
Num_Rescan_Diffs: int
Num_Trips_Incomplete: int
Total_Trip_Seconds: int
First_Trip_Datetime: datetime
Last_Incomplete_Datetime: datetime
Total_Spent: int
Last_Rescan_Datetime: datetime
PSS_Currency
Currency_ID: int
Currency_Name:
h (20)
Exchange_Rate: real
Num_Decimal_Digits: int
Decimal_Char: char(1)
Thousands_Char:
h(1)
Currency_Symbol: char(1)
Use_Curr_Symbol: char(1)
Price_Times_Factor: int
Currency_Symbol2: char(1)
Currency_Symbol_Web: char(1)
PSS_Language
Language_ID: int
Language_Name:
h (20)
PSS_Marketing_Department
Department_ID: int
Language_ID: int
Message_Text:
h (255)
Target_Coupon_Amt: int
Target_Rank: int
Start_Datetime: datetime
End_Datetime: datetime
PSS_Marketing_Mfg
Manufacturer_ID: int
Language_ID: int
Message_Text:
h (255)
Target_Coupon_Amt: int
Target_Rank: int
Start_Datetime: datetime
End_Datetime: datetime
PSS_Marketing_Item
Item_ID:
h (20)
Language_ID: int
Message_Text:
h (255)
Target_Coupon_Amt: int
Target_Rank: int
Start_Datetime: datetime
End_Datetime: datetime
PSS_Customer_Message
Customer_ID: int
Message_Nbr: int
Message_Text:
h (255)
Start_Datetime: datetime
End_Datetime: datetime
PSS_Admin_Page
Page_ID: int
Page_Name:
h (40)
Privilege_Level: int
Authenticated: char(1)
Disabled: char(1)
Default_Parms:
h (50)
Parent_Menu_ID: int
Parent_Page_ID: int