X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fschema.html;h=95929ead800eee3d37dd12bbee851f005799fff6;hb=15f65a0c56cbce6951d9cb4f71119725a2009f79;hp=5a296ec83963ef4519299645e9241ca23dd53ac2;hpb=660b40e2ac8b22033f8e2efc486417b0d27df482;p=freeside.git
diff --git a/htdocs/docs/schema.html b/htdocs/docs/schema.html
index 5a296ec83..95929ead8 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
@@ -50,7 +48,9 @@
- custnum - primary key
- agentnum - agent
- refnum - referral
+
- titlenum - title
- first - name
+
- middle - name
- last - name
- ss - social security number
- company
@@ -63,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
@@ -70,14 +71,21 @@
- tax - tax exempt, Y or null
- otaker - order taker
+ cust_main_invoice - Invoice destinations for email invoices
+
+ - 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)
+
cust_main_county - Tax rates
- taxnum - primary key
- state
- county
+
- country
- tax - % rate
- cust_pay - Payments
+ cust_pay - Payments. Money being transferred from a customer.
- paynum - primary key
- invnum - invoice
@@ -117,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
@@ -144,8 +160,8 @@
part_referral - Referral listing
- - refnum
- primary key
- - referral
- referral
+ - refnum - primary key
+
- referral - referral
part_svc - Service definitions
@@ -155,12 +171,39 @@
- table__field - Default or fixed value for field in table
- table__field_flag - null, D or F
+ part_title - Personal titles
+
+ - titlenum - primary key
+
- title - personal title (`Dr.' or `Mr.')
+
pkg_svc
+ 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
@@ -183,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
+ svcnum - primary key
+ recnum - host
+ usersvc - account
+
type_pkgs