X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;ds=sidebyside;f=htdocs%2Fdocs%2Fschema.html;h=474a3501a035b6ad20ede4ceb49670b29890aece;hb=7f07089722bfcabe3bf42619bb2bdb81fd8d44e1;hp=5a296ec83963ef4519299645e9241ca23dd53ac2;hpb=c0af1d666cd655dcece6f263890123851631c0fd;p=freeside.git
diff --git a/htdocs/docs/schema.html b/htdocs/docs/schema.html
index 5a296ec83..474a3501a 100644
--- a/htdocs/docs/schema.html
+++ b/htdocs/docs/schema.html
@@ -50,7 +50,9 @@
custnum - primary key
agentnum - agent
refnum - referral
+ titlenum - title
first - name
+ middle - name
last - name
ss - social security number
company
@@ -63,6 +65,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,11 +73,18 @@
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
@@ -133,6 +143,14 @@
pkgnum - package
svcpart - Service definition
+ 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 +162,8 @@
part_referral - Referral listing
- - refnum
- primary key
- - referral
- referral
+ - refnum - primary key
+
- referral - referral
part_svc - Service definitions
@@ -155,12 +173,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 +228,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