RdsDiagram
Audit
Authentication
Tolls 2.0 Conceptual Data Model
RTD
Hermes
AUDIT_EXCEPTIONS
seq: INTEGER
AUDIT_COMPONENTS
seq: INTEGER
AUDIT_SERVICES
seq: INTEGER
AUDIT_PROCESSES
seq: INTEGER
USER_CREDENTIALS
username: VARCHAR(128)
AUTH_USER_TOKENS
username: VARCHAR(128)
oauthtoken: VARCHAR(500)
ZECOM_PRESCRIPTION
country: VARCHAR(3)
customerid: VARCHAR(50)
prescriptionid: VARCHAR(18)
ZECOM_SUBSCRIPTION
country: VARCHAR(3)
customerid: VARCHAR(50)
subscriptionid: VARCHAR(10)
Company
country: VARCHAR(3)
customerid: VARCHAR(50)
subscriptionid: VARCHAR(10)
ZECOM_SUBSCRIPTION_LINES
country: VARCHAR(3)
customerid: VARCHAR(50)
subscriptionID: VARCHAR(10)
ZECOM_SUBSCRIPTION_PAYMENTS
country: VARCHAR(3)
customerid: VARCHAR(50)
subscriptionid: VARCHAR(10)
ZECOM_SUBSCRIPTION_PAUSE
country: VARCHAR(2)
customerid: VARCHAR(50)
subscriptionid: VARCHAR(10)
ZECOM_SUBSCRIPTION_QUANTITY
country: VARCHAR(2)
customerid: VARCHAR(50)
subscriptionid: VARCHAR(10)
RTD_APPOINTMENT_TYPES
id: VARCHAR(500)
VE_STORE_URL_MAP
practice_id: VARCHAR(3)
OUT_COURIER_V
record_id: NUMERIC(16,0)
order_id: NUMERIC(16,0)
OUT_COURIER_CONTENT_V
courier_out_id: NUMERIC(16,0)
order_id: NUMERIC(16,0)
RTD_STORE_SYNC
practice_id: VARCHAR(3)
IN_COURIER_MESSAGE
record_id: NUMERIC(16,0)
courier_out_id: NUMERIC(16,0)
order_id: NUMERIC(16,0)
IN_COURIER
record_id: NUMERIC(16,0)
courier_out_id: NUMERIC(16,0)
order_id: NUMERIC(16,0)
AUDIT_DOCUMENTS
seq: INTEGER
PENDING_DOCUMENTS
seq: INTEGER
AUDIT_HEALTH
seq: INTEGER