X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fschema.html;h=1ab0e7f62269f7337e9e2ae81b01ea426b7d507d;hb=61a85894466342b93507614785e61932f7358c50;hp=9558109e970cc874b4713965c1d0bb364edbc3b1;hpb=d605e2e68f3c388bd0479fb0aba1bb1bc8e61e73;p=freeside.git
diff --git a/htdocs/docs/schema.html b/htdocs/docs/schema.html
index 9558109e9..1ab0e7f62 100644
--- a/htdocs/docs/schema.html
+++ b/htdocs/docs/schema.html
@@ -154,8 +154,8 @@
part_referral - Referral listing
- - refnum
- primary key
- - referral
- referral
+ - refnum - primary key
+
- referral - referral
part_svc - Service definitions
@@ -176,6 +176,12 @@
- svcpart - Service definition
- quantity - quantity of this service that this package includes
+ prepay_credit
+
+ - prepaynum - primary key
+
- identifier - text or numeric string used to receive this credit
+
- amount - amount of credit
+
svc_acct - Accounts
- svcnum - primary key
@@ -198,6 +204,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