X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fschema.html;h=a61000f1f188bdf4b1beabf8d765f24971a9b5bc;hb=3ebf10b2e784390c7c3593b29886e980aff2ff5f;hp=6f4d99937e17fee256d3c9002290fc02493103e1;hpb=d1407e95ff695055c3609eeee7599b32f3b54c54;p=freeside.git
diff --git a/htdocs/docs/schema.html b/htdocs/docs/schema.html
index 6f4d99937..a61000f1f 100644
--- a/htdocs/docs/schema.html
+++ b/htdocs/docs/schema.html
@@ -17,30 +17,28 @@
typenum - primary key
atype - name of this agent type
- cust_bill - Invoices
+ cust_bill - Invoices. Declarations that a customer owes you money. The specific charges are itemized in cust_bill_pkg.
- invnum - primary key
- custnum - customer
- _date
- charged - amount of this invoice
-
- owed - amount still outstanding on this invoice
- printed - how many times this invoice has been printed automatically
cust_bill_pkg - Invoice line items
- invnum - (multiple) key
-
- pkgnum - package
+
- pkgnum - package or 0 for the special virtual sales tax package
- setup - setup fee
- recur - recurring fee
- sdate - starting date
- edate - ending date
- cust_credit - Credits
+ cust_credit - Credits. The equivalent of a negative cust_bill record.
- crednum - primary key
- custnum - customer
- amount - amount credited
-
- credited - amount still outstanding (not yet refunded) on this credit
- _date
- otaker - order taker
- reason
@@ -65,6 +63,7 @@
- country
- daytime - phone
- night - phone
+
- fax - phone
- payby - CARD, BILL, or COMP
- payinfo - card number, P.O.#, or comp issuer
- paydate - expiration date
@@ -72,11 +71,12 @@
- tax - tax exempt, Y or null
- otaker - order taker
- cust_main_invoice - Invoice destinations for email invoices
+ cust_main_invoice - Invoice destinations for email invoices. Note that a customer can have many email destinations for their invoice (either literal or via svcnum), but only one postal destination.
- destnum - primary key
- custnum - customer
-
- dest - Invoice destination: If numeric, a svcnum, if string, a literal email address, or `POST' to enable mailing (the default if no cust_main_invoice records exist)
+
- dest - Invoice destination. Freeside supports three types of invoice delivery: send directly to a service defined in Freeside, send to an arbitrary email address, or print the invoice to a printer and have someone send it out via snail mail. Freeside determines which method to use based on the contents of the dest field. If the contents are numeric, a svcnum pointing to a valid service is expected in the field. If the contents are a string, a literal email address is expected to be in the field. If the special keyword `POST' is present, the snail mail method is used (which is the default if no cust_main_invoice records exist). Snail mail invoices get their address information from cust_main and are printed with the printer defined in the configuration files.
+
cust_main_county - Tax rates
- taxnum - primary key
@@ -85,7 +85,7 @@
- country
- tax - % rate
- cust_pay - Payments
+ cust_pay - Payments. Money being transferred from a customer.
- paynum - primary key
- invnum - invoice
@@ -125,7 +125,7 @@
- cancel - (past) cancellation date
- otaker - order taker
- cust_refund - Refunds
+ cust_refund - Refunds. The transfer of money to a customer; equivalent to a negative cust_pay record.
+ nas - Network Access Server (terminal server)
+
+ - nasnum - primary key
+
- nas - NAS name
+
- nasip - NAS ip address
+
- nasfqdn - NAS fully-qualified domain name
+
- last - timestamp indicating the last instant the NAS was in a known state (used by the session monitoring).
+
part_pkg - Package definitions
- pkgpart - primary key
@@ -152,8 +160,8 @@
part_referral - Referral listing
- - refnum
- primary key
- - referral
- referral
+ - refnum - primary key
+
- referral - referral
part_svc - Service definitions
@@ -174,6 +182,28 @@
- svcpart - Service definition
- quantity - quantity of this service that this package includes
+ port - individual port on a nas
+
+ - portnum - primary key
+
- ip - IP address of this port
+
- nasport - port number on the NAS
+
- nasnum - NAS
+
+ prepay_credit
+
+ - prepaynum - primary key
+
- identifier - text or numeric string used to receive this credit
+
- amount - amount of credit
+
+ session
+
+ - sessionnum - primary key
+
- portnum - Port
+
- svcnum - Account
+
- login - timestamp indicating the beginning of this user session.
+
- logout - timestamp indicating the end of this user session. May be null, which indicates a currently open session.
+
+
svc_acct - Accounts
- svcnum - primary key
@@ -196,6 +226,7 @@
- state
- ac - area code
- exch - exchange
+
- loc - rest of number
svc_acct_sm - Domain mail aliases
+ domain_record - Domain zone detail
+
+ - recnum - primary key
+
- svcnum - Domain (by svcnum)
+
- reczone - zone for this line
+
- recaf - address family, usually IN
+
- rectype - type for this record (A, MX, etc.)
+
- recdata - data for this record
+
+ svc_www
+
type_pkgs