X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fschema.html;h=474a3501a035b6ad20ede4ceb49670b29890aece;hb=c661868d1119af8a911c47982b52a2c89776c752;hp=c561a5ab34b0e2d130b363abd0b1fe99613a0db1;hpb=56b98dd1587282585a92a93dbac5781da58154f1;p=freeside.git
diff --git a/htdocs/docs/schema.html b/htdocs/docs/schema.html
index c561a5ab3..474a3501a 100644
--- a/htdocs/docs/schema.html
+++ b/htdocs/docs/schema.html
@@ -65,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
@@ -76,7 +77,8 @@
- destnum - primary key
- custnum - customer
-
- dest - Invoice destination: svcnum if numeric, literal email address if string
+
- 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
+ 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 +162,8 @@
part_referral - Referral listing
- - refnum
- primary key
- - referral
- referral
+ - refnum - primary key
+
- referral - referral
part_svc - Service definitions
@@ -174,6 +184,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 +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