This section lists the main schemas used in Faunix -- a commercial application for managing a veterinary practice. The schemas are presented here to give you a feel for how to create schemas for your application.
Doctors ( Name ) *
Personnel ( Name )*
EntryCodes verbosename "Entry Codes" (
Code
Description
) *
Rabies verbosename "Next Rabies Tag #"
InvoiceNumber verbosename "Next Invoice #" type integer
ClientID verbosename "Next Client #" type integer
PetID verbosename "Next Pet #" type integer
ServiceChargeRate verbosename "Service Charge Rate %"
type real format "%.2f"
DefCity verbosename "Default City"
DefState verbosename "Default State"
DefZip verbosename "Default Zip Code"
Clinic verbosename "Clinic Information" (
Name
Address (Street City State Zip)
Phone verbosename "Primary phone:"
)
TaxRate verbosename "Tax rate %" type integer
PaymentTypes verbosename "Types of Payment Accepted"
EstimateNumber verbosename "Next Estimate #" type integer
MinimumServiceCharge verbosename "Minimum Service Charge $"
type real format "%.2f"
RxNumber verbosename "Next Rx #" type integer
AgingType verbosename "Account Aging" defaultvalue "Automatic"
AgingDayOfMonth verbosename "Day of month for aging (1-28)"
type integer defaultvalue "1"
AutomaticBackups verbosename "Automatic Backups" defaultvalue "On"
Use reduced attribute identifiers
Use cached secondary search
Use Cached Hashing
HashSize = 20000
ID verbosename "Client #" type integer
Client (
Name (Title First Middle Last)*
Address (
Street City State Zip verbosename "Zip Code"
Billing verbosename "Billing" defaultvalue "Y"
Reminder verbosename "Reminders" defaultvalue "Y"
)*
Phones (Desc verbosename "Desc" Number)*
Employer Occupation
SS verbosename "S.S. #"
BillingPercent verbosename "Invoice %"
)*
net verbosename "Net Bal." type real format "%.2f"
MonthlyPayments verbosename "This month's payments" type real format "%.2f"
MonthlyCharges verbosename "This month's charges" type real format "%.2f"
curr verbosename "Current" type real format "%.2f"
d30 verbosename "30 days" type real format "%.2f"
d60 verbosename "60 days" type real format "%.2f"
d90 verbosename "90 days" type real format "%.2f"
CreditHold verbosename "Credit hold" defaultvalue "N"
LastPayment verbosename "Last Payment Date" type date
FirstDate verbosename "1st Date" type date
LastDate verbosename "Last Date" type date
ReferenceDisc verbosename "Ref. Disc. %" type real format "%.2f"
MultiPet verbosename "Multi-Pet Disc. %" type real format "%.2f"
Comments
Referral verbosename "Referred by" (ClientName ClientNumber)
Pets (
ID verbosename "Animal #" type integer
Name Species Breed Markings Color Sex
Died defaultvalue "N" Breeding verbosename "Breeding An."
Birthday type date
FirstVisit verbosename "First Visit" type date
LastVisit verbosename "Last Visit" type date
NextVisit verbosename "Next Visit" type date
WeightDate verbosename "Date Taken" type date
WeightType verbosename "Weight Type" defaultvalue "lbs"
Weight verbosename "Weight"
Rabies (
Date verbosename "Date" type date
Tag verbosename "Tag #"
Manufacturer verbosename "Mfg."
)*
Comments
MedHist verbosename "Medical History" (
Date type date
EntryCode verbosename "Entry Code"
Doctor
Items verbosename "Services/Items" (
Qty type integer defaultvalue ""
SvcType
Code
Desc exclude
Price type real format "%.2f" defaultvalue "" exclude
Total type real format "%.2f" defaultvalue "" exclude
Unit exclude
Comments
)*
Comments
)*
Reminders (
DueWhen verbosename "Date Due" type date
Code
Desc exclude
RemindersSent verbosename "# reminders sent" type integer
DoneWhen verbosename "Last Done" type date
)*
Recalls (
EnteredDate verbosename "On (date)" type date
Date verbosename "recall/recheck (date)" type date
Code
Desc verbosename "Description"
Doctor
Comments
)*
)*
Statements (
Date verbosename "Statement date" type date
net verbosename "Net Bal." type real format "%.2f" defaultvalue ""
curr verbosename "Curr. Bal." type real format "%.2f" defaultvalue ""
d30 verbosename "30 Days" type real format "%.2f" defaultvalue ""
d60 verbosename "60 Days" type real format "%.2f" defaultvalue ""
d90 verbosename "90 Days" type real format "%.2f" defaultvalue ""
ServiceCharge verbosename "Service charge"
type real format "%.2f" defaultvalue ""
)*
Use Reduced Attribute Identifiers
Use Cached Hashing
CacheSize = 500
HashSize = 20000
Number verbosename "Invoice Number" type integer
Client (
ID verbosename "Client #" type integer
Name
)
Date type date
Time exclude
DayOfWeek verbosename "Day of Week"
Pet (
PetID verbosename "Animal #" type integer
PetName verbosename "Animal Name"
Doctor
Personnel
EntryCode verbosename "Entry Code"
Items (
Qty type integer
Code
SvcType
Desc verbosename "Description"
Taxable exclude
Price type real format "%.2f" exclude
Total verbosename "Line Total" type real format "%.2f" exclude
DiscountedTotal verbosename "Discounted Total" type
real format "%.2f" exclude
)*
Subtotal type real format "%.2f" exclude
)*
Subtotal type real format "%.2f" exclude
Discounts type real verbosename "Discounts" format "%.2f" exclude
Tax type real verbosename "Sales Tax" format "%.2f"
Total verbosename "Invoice Total" type real format "%.2f" exclude
PaymentType verbosename "Type of Payment"
PaymentAmount verbosename "Payment Amount" type real format "%.2f" exclude
PreviousBalance verbosename "Previous Balance" type real format "%.2f" exclude
AmountDue verbosename "Total amount due" type real format "%.2f"
Use Cached Hashing HashSize = 500 Category Barcode separators "" Desc verbosename "Description" Msg verbosename "Print Message" Size Tax Price type real format "%.2f" Group QtyInStock type integer verbosename "Quantity in stock" Date verbosename "Date last changed" Dynamic verbosename "Variable pricing" Message verbosename "Message To Print" Actions Code separators ""
Use Reduced Attribute Identifiers Use Cached Hashing CacheSize = 500 HashSize = 20000 Number verbosename "Estimate Number" type integer Client ( ID verbosename "Client #" type integer Name ) Date type date Time exclude DayOfWeek verbosename "Day of Week" Pet ( PetID verbosename "Animal #" type integer PetName verbosename "Animal Name" Doctor Items ( Qty type integer Code SvcType Desc verbosename "Description" exclude Taxable exclude Price type real format "%.2f" exclude Total verbosename "Line Total" type real format "%.2f" exclude DiscountedTotal verbosename "Discounted Total" type real format "%.2f" exclude )* Subtotal type real format "%.2f" exclude )* Subtotal type real format "%.2f" exclude Discounts type real verbosename "Discounts" format "%.2f" exclude Tax type real verbosename "Sales Tax" format "%.2f" exclude Total type real format "%.2f" exclude PaymentType verbosename "Type of Payment" exclude PaymentAmount verbosename "Payment Amount" type real format "%.2f" exclude
Use Cached Hashing HashSize = 500 Category Code separators "" Barcode separators "" Desc verbosename "Description" Unit Reminders verbosename "Reminders in" type integer defaultvalue "0" Area SvcType verbosename "Type" AI Msg verbosename "Print a message on the invoice" Tax defaultvalue "N" Price type real format "%.2f" Group verbosename "Additional codes for automatic entry" Message verbosename "Message To Print" Actions verbosename "Programming Actions" Invoice verbosename "Print on invoice" defaultvalue "Y" ReminderUnits verbosename " " defaultvalue "Months" Dynamic verbosename "Variable pricing" defaultvalue "N" Recall verbosename "Recall/recheck in" type integer defaultvalue "0" RecallUnits verbosename " " defaultvalue "Days" # programming actions RabiesCode verbosename "Should this service generate a rabies tag?" defaultvalue "N" SexChangeCode verbosename "Does this service change the animal's sex?" defaultvalue "N" SexChangeValue verbosename "If so, to what?" DeadCode verbosename "Does this service indicate the animal has died?" defaultvalue "N" EquivalentCodes verbosename "Equivalent codes for reminders" RecallComments verbosename "Prompt for comments?" defaultvalue "N" MedHistComments verbosename "Prompt for medical history comments?" defaultvalue "N"
Use Cached Hashing HashSize = 500 Title verbosename "Report title" From type date verbosename "Report from (date)" To type date verbosename "Report to (date)" RabiesCodes verbosename "Rabies Codes" ComparisonCodes verbosename "Codes for comparison to rabies" ( Desc verbosename "Description" Codes Target type real format "%.2f" verbosename "Target (%)" )* GroomingCodes verbosename "Grooming Codes" Expected type real format "%.2f" verbosename "Expected % increase from last year" Excess type real format "%.2f" verbosename "Excess (per visit) bonus $" Days type integer verbosename "Working days" Bonus type real format "%.2f" verbosename "Bonus (%)"
Use Cached Hashing HashSize = 3000 Date type date DayClosed verbosename "Day Closed" Visits verbosename "# Visits" type integer InvStart verbosename "Invoice Start" type integer InvEnd verbosename "Invoice End" type integer Payments verbosename "Daily Payments" ( PaymentType verbosename "Type of Payment" Amount type real format "%.2f" )* Total verbosename "Daily Payment Total" type real format "%.2f" Tax verbosename "Daily Sales Tax" type real format "%.2f" OverShort verbosename "Over + / Short -" type real format "%.2f" Reason verbosename "Reason for Over/Short" Deposit verbosename "Deposit" type real format "%.2f" ByDoctor verbosename "Services by doctor" ( Doctor Services ( Code Desc verbosename "Description" Total type real format "%.2f" Qty type integer )* )* Fees verbosename "Daily Invoice Total" type real format "%.2f"
Use Cached Hashing HashSize = 500 Title verbosename "Report title" From type date verbosename "Report from (date)" To type date verbosename "Report to (date)" StatementDate type date verbosename "Statement Date (8/1/95)" QtyCodes verbosename "Areas and codes for quantity breakdown" ( Desc verbosename "Description" Areas Codes )* RevenueBreakdown verbosename "Areas and codes for revenue breakdown" ( Desc verbosename "Description" Areas Codes )*