Database

Download as pdf or txt
Download as pdf or txt
You are on page 1of 4

customerchathistory customeralerts customersubscriptions customerfeedbackresponses softwaredetails

Chat_ID INT Alert_ID INT Subscription_ID INT Response_ID INT ID INT


Customer_ID VARCHAR(45) Customer_ID VARCHAR(45) Customer_ID VARCHAR(45) Feedback_ID VARCHAR(45) XML_File_Name VARCHAR(45)
Support_Agent VARCHAR(45) Alert_Type VARCHAR(45) Product_Name VARCHAR(45) Support_Rating VARCHAR(45) Category VARCHAR(45)
Chat_Text VARCHAR(45) Alert_Message VARCHAR(45) Start_Date VARCHAR(45) Support_Comments VARCHAR(45) Sub_Category VARCHAR(45)
Chat_Date VARCHAR(45) Alert_Date VARCHAR(45) End_Date VARCHAR(45) Indexes Name VARCHAR(45)
Indexes Indexes Status VARCHAR(45) File_Name VARCHAR(45)
Indexes File_Size DOUBLE
Release_Date DATETIME
Developer VARCHAR(45)
RAM_Requirement VARCHAR(45)
Disk_Space_Requirement VARCHAR
Description LONGTEXT
systemrequirements customercomplains orderItemAttribute customerdevices Indexes
OrderDelivery
Software_ID INT Complaint_ID INT OrderItemAttribute_ID VARCHAR(45) Devices_ID INT OrderDelivery_ID INT
Operating_System VARCHAR(45) Customer_ID VARCHAR(45) OrderItem_ID INT Customer_ID VARCHAR(45) Customer_ID INT
RAM INT Complaint_Type VARCHAR(45) Order_ID VARCHAR(45) Devices_Type VARCHAR(45) Order_ID INT
Hard_Disk_Space INT Complaint_Details VARCHAR(45) Total VARCHAR(45) Device_Name VARCHAR(45) UserName VARCHAR(45)
Processor VARCHAR(45) Status VARCHAR(45) Weight VARCHAR(45) Last_Used VARCHAR(45) OrderNum VARCHAR(45)
Indexes Indexes Quantity VARCHAR(45) Indexes TrackingNum VARCHAR(45)
Attribute_ID VARCHAR(45) Total VARCHAR(45)
AttributeCode VARCHAR(45) Shipping VARCHAR(45)
AttributeName VARCHAR(45) Tax VARCHAR(45)
AttributeUnitCost VARCHAR(45) TaxableSubTotal VARCHAR(45)
UnitPrice VARCHAR(45) SubTotal VARCHAR(45)
AltPrice VARCHAR(45) Weight VARCHAR(45)
softwarefeatures
Product_Attribute_copy1 customerpayments ProductWeight VARCHAR(45) customerinvoices Quantity VARCHAR(45)
Software_ID INT INT
ProductAtribute_ID Payment_ID INT IsTaxed VARCHAR(45) Invoice_ID INT created VARCHAR(45)
Feature VARCHAR(45)
Product_ID VARCHAR(45) Customer_ID VARCHAR(45) Image VARCHAR(45) Customer_ID VARCHAR(45) LastModified VARCHAR(45)
Indexes
Atribute_ID VARCHAR(45) Payment_Method VARCHAR(45) ShortDescription VARCHAR(45) Total_Amount VARCHAR(45) Completed VARCHAR(45)
ProductAtributeOrder VARCHAR(45) Amount VARCHAR(45) StatusDetail VARCHAR(45) Due_Date VARCHAR(45) Status VARCHAR(45)
Class VARCHAR(45) Payment_Date VARCHAR(45) DecrementedSKUs VARCHAR(45) Status VARCHAR(45) StatusDetail VARCHAR(45)
Note INT Indexes Class VARCHAR(45) Indexes FirstName VARCHAR(45)
Status VARCHAR(45) Note VARCHAR(45) LastName VARCHAR(45)
Indexes Status VARCHAR(45) Organization VARCHAR(45)
details SKU ProductSetting customersubscriptionhistory order
SKU_ID INT ProductSetting_ID INT SubscriptionHistory_ID INT Order_ID INT
me VARCHAR(45) Product_ID VARCHAR(45) Product_ID VARCHAR(45) Customer_ID VARCHAR(45) Customer_ID VARCHAR(45)
CHAR(45) Atribute_ID VARCHAR(45) Code VARCHAR(45) Product_Name VARCHAR(45) UserName VARCHAR(45)
VARCHAR(45) SKU_Num VARCHAR(45) Name VARCHAR(45) Start_Date VARCHAR(45) OrderNum VARCHAR(45)
SKUName VARCHAR(45) Description VARCHAR(45) End_Date VARCHAR(45) TrackingNum VARCHAR(45)
RCHAR(45) SKUMessages INT Type INT Status VARCHAR(45) Total VARCHAR(45)
Track_Inventory INT ValueType VARCHAR(45) Indexes Shipping VARCHAR(45)
DATETIME Inventory_Level VARCHAR(45) IntegerValue VARCHAR(45) Tax VARCHAR(45)
RCHAR(45) Note VARCHAR(255) SmallValue VARCHAR(255) TaxableSubTotal VARCHAR(45)
ment VARCHAR(45) Status VARCHAR(45) MediumValue VARCHAR(45) SubTotal VARCHAR(45)
equirement VARCHAR(45) Footer INT TextValue INT Weight VARCHAR(45)
ONGTEXT Taxed VARCHAR(45) Class VARCHAR(45) Quantity VARCHAR(45)
customertaskshistory
Img_Smal INT customertasks
Note INT CustomerAddress
customersocialmedia created VARCHAR(45)
_ID INT Img_Big INT INT
TasHistory_ID Status
Task_IDINT
INT CustomerAddress_ID
SocialMedia_ID INT INT LastModified VARCHAR(45)
Indexes
Task_ID VARCHAR(45) Product_Category_ID INT
Customer_ID VARCHAR(45) Customer_ID VARCHAR(45) Completed VARCHAR(45)
Customer_ID VARCHAR(45) Product_SubCategory_Category_ID1
Access_Type VARCHAR(45) INT FirstNameVARCHAR(45)
Platform VARCHAR(45) Status VARCHAR(45)
RCHAR(45) Task_Status VARCHAR(45) Product_SKU_SKU_ID INT
Access_Level VARCHAR(45) LastName VARCHAR(45)
Username StatusDetail VARCHAR(45)
RCHAR(45) Task_Completion_Date VARCHAR(45) Indexes Indexes
Organization VARCHAR(45) FirstName VARCHAR(45)
VARCHAR(45) Indexes Address1 INT LastName VARCHAR(45)
Address2 VARCHAR(45) Organization VARCHAR(45)
CHAR(45) City INT Address1 VARCHAR(45)
State VARCHAR(45) Address2 VARCHAR(45)
otal VARCHAR(45) Postalcode VARCHAR(45) City VARCHAR(45)
CHAR(45) Country VARCHAR(45) State VARCHAR(45)
HAR(45) PhoneNum1 VARCHAR(45) PostalCode VARCHAR(45)
CHAR(45) customertags
Product customernotes
Customer customerpreferences
PhoneNum2 VARCHAR(45) Country VARCHAR(45)
customerrewards
HAR(45) Tag_ID INT INT
Category_ID Note_ID INT INT
Customer_ID EmailAddress VARCHAR(45)
Preference_ID INT PhoneNum1
Rewards_ID VARCHAR(45)
INT
VARCHAR(45) Customer_ID VARCHAR(45)
SubCategory_num VARCHAR(45) Customer_ID
UserName VARCHAR(45)
VARCHAR(45) Note VARCHAR(45)
Customer_ID VARCHAR(45) PhoneNum2 VARCHAR(45)
Customer_ID VARCHAR(45)
ARCHAR(45) Tag_Name VARCHAR(45)
SubCategory_Name VARCHAR(45) Note_DateVARCHAR(45)
Password VARCHAR(45) Status VARCHAR(45)
Receive_Emails VARCHAR(45) EmailAddress1VARCHAR(45)
Reward_Type VARCHAR(45)
AR(45) Indexes
SubCategory_description VARCHAR(45) Note_Text
Created VARCHAR(45)
VARCHAR(45) Indexes
Receive_SMS VARCHAR(45) EmailAddress2 VARCHAR(45)
Reward_Points VARCHAR(45)
ARCHAR(45) IsActive VARCHAR(45) Indexes
Last_Login VARCHAR(45) Receive_Updates VARCHAR(45) Indexes 2 more...
RCHAR(45) SubCategorycol INT FirstName INT Indexes Indexes
RCHAR(45) Header VARCHAR(45) LastName VARCHAR(45)
VARCHAR(45) Footer VARCHAR(45) Organization INT
City VARCHAR(45) Address1 VARCHAR(45)
State VARCHAR(45) Address2 VARCHAR(45)
PostalCode VARCHAR(45) City VARCHAR(45)
Country VARCHAR(45) State VARCHAR(45)
customerpurchases
orderItem softwaredata.xlsb
payments EmailAddress1 VARCHAR(45)
productreviews developerdetails
Atribute PostalCode VARCHAR(45)
applicationcapabilities
Purchase_ID INT
OrderItem_ID INT Software_ID INT
Payment_ID EmailAddress2
Review_ID INT VARCHAR(45) Developer INT
Atribute_ID INT Country VARCHAR(45)
Software_ID INT
Customer_ID
Order_ID VARCHAR(45)
VARCHAR(45) Product SKU
Order_ID VARCHAR(45)
TEXT Indexes
Product_Name VARCHAR(45) Description VARCHAR(45)
AtributeCode VARCHAR(45) PhoneNum1 VARCHAR(45)
Capability VARCHAR(45)
Product_Name VARCHAR(45)
OrderDelivery_ID VARCHAR(45) Column3 TEXT VARCHAR(45)
Payment_Date Customer_ID VARCHAR(45) Indexes
AtributeName VARCHAR(45) PhoneNum2 VARCHAR(45)
Indexes
Purchase_Date
Total VARCHAR(45)
VARCHAR(45) Column33 TEXT VARCHAR(45)
Payment_amount Rating (Out of 5) VARCHAR(45) AtributeDescription VARCHAR(45) EmailAddress1 VARCHAR(45)
Purchase_Amount
Weight VARCHAR(45)
VARCHAR(45) Indexes
Column34 TEXT Review_Text VARCHAR(45) AtributeIsActive VARCHAR(45) 3 more...
Indexes
Quantity VARCHAR(45) Column35 TEXT Indexes AtributeType INT Indexes
ProductID VARCHAR(45) Column4 INT AtributeUnitCost VARCHAR(45)
Code VARCHAR(45) Column5 INT AtributUnitPrice VARCHAR(45)
Name VARCHAR(45) Column62 TEXT AtributeWeight VARCHAR(45)
IsActive VARCHAR(45) Column63 TEXT AtributeSmallImage VARCHAR(45)
UnitPrice VARCHAR(45) Column64 TEXT AtributeBigImage VARCHAR(45)
AltPrice VARCHAR(45) Column67 DATETIME DefaultOptionID VARCHAR(45)
ProductWeight VARCHAR(45) wishlists
Column68 TEXT filefetails AtributeIsRequested VARCHAR(45) RelatedProduct
IsTaxed VARCHAR(45) Column82 TEXT
Wishlists_ID INT Software_ID INT AtributeOrder VARCHAR(45) RelatedProduct_ID INT
Image VARCHAR(45) Column83 TEXT
Customer_ID VARCHAR(45) File_Name VARCHAR(45) Class VARCHAR(45) ParentProduct_ID INT
ShortDescription VARCHAR(45) Column9 TEXT VARCHAR(45)
Product_Name File_Size VARCHAR(45) Note VARCHAR(45) Product_ID VARCHAR(45)
StatusDetail VARCHAR(45) Indexes
Column10 TEXT Release_Date VARCHAR(45) Status VARCHAR(45) IsActive VARCHAR(45)
DecrementedSKUs VARCHAR(45) Column11 TEXT Indexes Product_Attribute_copy1_ProductAtribute_ID INT Product_Category_ID INT
Class VARCHAR(45) Column12 TEXT Indexes Product_SubCategory_Category_ID1
Note VARCHAR(45) Column13 TEXT Product_SKU_SKU_ID INT
Status VARCHAR(45) Column14 TEXT Indexes
City VARCHAR(45) Column15 TEXT
State VARCHAR(45) Column16 TEXT
PostalCode VARCHAR(45) Column17 TEXT
Country VARCHAR(45) Column18 TEXT
EmailAddress1
customers VARCHAR(45) 6 more... customerreturns orderdetails customersupporttickets
EmailAddress2INT
Customer_ID VARCHAR(45) Indexes Return_ID INT Order_Detail_ID INT Tiket_ID INT
Indexes
First_Name VARCHAR(45) Customer_ID VARCHAR(45) Order_ID DOUBLE Customer_ID VARCHAR(45)
Last_Name VARCHAR(45) Order_ID VARCHAR(45) Product_Name VARCHAR(45) Subject VARCHAR(45)
Email VARCHAR(45) Return_Date VARCHAR(45) Quantity VARCHAR(45) Status VARCHAR(45)
Phone_Number VARCHAR(45) Return_Reason VARCHAR(45) Unit_Price VARCHAR(45) Created_Date VARCHAR(45)
Note VARCHAR(45) Indexes Indexes Resolved_Date VARCHAR(45)
Indexes Indexes
CHAR(45) Img_Smal VARCHAR(255) Address1 VARCHAR(45)
CHAR(45) Img_Big VARCHAR(45) Address2 VARCHAR(45)
ParentCategory INT City VARCHAR(45)
CategoryOrder INT State VARCHAR(45)
ARCHAR(45)
oncapabilities user
Note VARCHAR(45) customerfeedback
PostalCode VARCHAR(45) orderDiscount customerevents
customersubscriptionshistory
HAR(45) Status INTVARCHAR(16)
username Country VARCHAR(45)
FeedBack_ID INT Order_ID VARCHAR(45) Event_ID INT
SubscriptionHistory_ID INT
VARCHAR(45)
RCHAR(45) SubCategory_Category_ID1
email VARCHAR(255) INT PhoneNum1
Customer_IDVARCHAR(45)
VARCHAR(45) OrderItem_ID INT Customer_ID VARCHAR(45)
VARCHAR(45) SKU_SKU_ID
password INT
VARCHAR(32) PhoneNum2 VARCHAR(45)
Feedback_Text VARCHAR(45) OrderDelivery_ID VARCHAR(45) Event_Type VARCHAR(45)
Reward_Type VARCHAR(45)
1 VARCHAR(45) Product_Attribute_ProductAtribute_ID
create_time TIMESTAMP INT Indexes
EmailAddress1 VARCHAR(45) Total VARCHAR(45) Event_Date VARCHAR(45)
Reward_Points VARCHAR(45)
Indexes
customers_Customer_ID INT EmailAddress2 VARCHAR(45) Weight VARCHAR(45) Indexes
Event_Location VARCHAR(45)
Indexes CustomerAddress_CustomerAddress_ID INT Quantity VARCHAR(45) Indexes
Indexes ProductID VARCHAR(45)
Code VARCHAR(45)
Name VARCHAR(45)
userAppliedType VARCHAR(45)
UserAppliedValue VARCHAR(45)
ItemAppliesType VARCHAR(45)
roduct Payement customersurveys ItemAppliesValue VARCHAR(45) SubCategory
ct_ID INT Payment_ID INT Survey_ID INT RewardType VARCHAR(45) Category_ID INT
t_ID INT Status DOUBLE Customer_ID VARCHAR(45) Reward VARCHAR(45) SubCategory_num VARCHAR(45)
ARCHAR(45) Order_ID VARCHAR(45) Rating (Out Of 5) VARCHAR(45) CouponCode VARCHAR(45) SubCategory_Name VARCHAR(45)
HAR(45) ProcessorClassName VARCHAR(45) Feedback_Text VARCHAR(45) Floor VARCHAR(45) SubCategory_description VARCHAR(45)
gory_ID INT ValueFieldLabel VARCHAR(45) Survay_Date VARCHAR(45) Ceiling VARCHAR(45) IsActive VARCHAR(45)
ategory_Category_ID1 INT CreditCardName VARCHAR(45) Indexes Class VARCHAR(45) SubCategorycol INT
_SKU_ID INT CreditCardType VARCHAR(45) Note VARCHAR(45) Header VARCHAR(45)
CreditCardDate VARCHAR(45) Status VARCHAR(45) Footer VARCHAR(45)
CreditCard Number VARCHAR(45) Class VARCHAR(45) Img_Smal VARCHAR(255)
CreditCardNumberDisplay VARCHAR(45) Note VARCHAR(45) Img_Big VARCHAR(45)
PaymentValue VARCHAR(45) Status VARCHAR(45) ParentCategory INT
Value VARCHAR(45) Indexes CategoryOrder INT
supporttickets Class VARCHAR(45)
customertraining customerinterests customerrefferals Note VARCHAR(45)
customersupportmessages
Note VARCHAR(45)
Training_ID INT Interest_ID INT Referral_ID INT Status INT INT
Message_ID
VARCHAR(45) Status VARCHAR(45)
Customer_ID VARCHAR(45) Customer_ID VARCHAR(45) Customer_ID VARCHAR(45) Indexes
Tiket_ID VARCHAR(45)
HAR(45) order_Order_ID INT
Training_Type VARCHAR(45) Interest_Category VARCHAR(45) Referral_Code VARCHAR(45) Sender_Type VARCHAR(45)
AR(45) orderDiscount_OrderItem_ID
Training_Date VARCHAR(45) INT Interest_Details VARCHAR(45) Referral_Customer_ID VARCHAR(45) Sender_Name VARCHAR(45)
VARCHAR(45) Indexes
Trainer VARCHAR(45) Indexes Indexes Message_Text VARCHAR(45)
e VARCHAR(45) Indexes TimeStamp VARCHAR(45)
Indexes

You might also like