[go: up one dir, main page]
Scribd
Upload
132 views1 page

Pharmaceutical Distribution Management System - ERDiagram

The document contains descriptions of multiple database tables that are related to an e-commerce order and registration system. The tables include details on mails, orders, order items, payments, registrations, forums questions and answers, login details, categories, companies and roles. Relationships between the tables are implied through foreign keys.

Uploaded by

1000 Projects
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
132 views1 page

Pharmaceutical Distribution Management System - ERDiagram

The document contains descriptions of multiple database tables that are related to an e-commerce order and registration system. The tables include details on mails, orders, order items, payments, registrations, forums questions and answers, login details, categories, companies and roles. Relationships between the tables are implied through foreign keys.

Uploaded by

1000 Projects
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 1

tblMails

ReceivedMailId tblOrders
SenderMailId OrderId tblPaymentDetails
Subject DorRId PaymentId
Body orderdate OrderId
Filepath DeliveryStatus PaymentDate
ReadStatus DelDate Amount
InStatus CreditCardNo
OutStatus CardCode
MailDate BankName

tblRegistration
DorRId
FirstName
tblOrderDetails LastName
Sno
Gender
OrderId
Address
DistId
PhoneNo
ItemId
DORegistration tblForums
CompanyId QtnId
Email
CategoryId UserName
Qualification
Quantity DorRId
Experience
Rstatus QtnName
Designation
Dstatus Description
Photo
Amount PostDate
status tblForumsAns
NoOfViews AnsId
NoOfReplies QtnId
Answer
RuserName
Attachments
tblItems AnsPostDate
tblCategory ItemId
CategoryId CompanyId tblLoginDetails
CateGoryType ItemName Username
Description CategoryId DorRId
MgOrMl RoleId
Price Password

tblCompanyDetails Description Cpassword


CompanyId Discount HintQtn
CompanyName Answer
CompanyAddress
phoneNo
FaxNo
Website
Email tblRoleMaster
Deescription RoleId
RoleType
Description

You might also like