Updated: November 12, 2018 1:16pm

Database Schema

This topic has diagrams of the Prism database schema: Adjustments, Application, Currency, Customer, DDTables, Document, Employee, Inventory, License, Loyalty, Markdown, Promotions, Physical Inventory, PO,
Price, Printer, Prism, Region, Replication, Scale, Tax, Tender, Transfers, Vendor, Voucher, Z-Out

ADJUSTMENTS

adjustments schema

 

APPLICATION

application schema

CURRENCY

currency schema

CUSTOMER

(Top)

customer schema 1

CUSTOMER

(bottom)

customer schema 2

 

DD Tables

ddtables schema

 
DOCUMENT

(top)

document schema 1

 

(bottom)

document schema 2

EMPLOYEE

(top)

employee schema 1

(bottom)

employee schema 2

 
INVENTORY

(part one)

Inventory part one

 

(part two)

Inventory part 2

 


LICENSE

License schema

 
LOYALTY

loyalty schema

 

MARKDOWN
Markdown schema

 
PROMOTIONS

Promotions schema

 
PHYSICAL_INVENTORY

pi schema

 
PO

PO schema

 

PRICE

Price schema

 


PRINTER

printer schema

 

 
PRISM

Prism schema

 
REGION

region schema


REPLICATION

replication schema

 
SCALE

scale schema

 
TAX

tax schema

 
TENDER

(part 1)

tender schema

(part2)

tender schema 2

 
TRANSFERS

transfers schema

 
VENDOR

Vendor schema

 

VENDOR (Z-OUT Links)

vendor schema showing z-out links

 

VOUCHER

voucher schema

WORKSTATION

Workstation ER diagram

WORKSTATION (continued)
Workstation ER diagram continued

Z-Out

z-out schema