DB Schema updates for pci patch
Kristian Hoffmann
khoff at pc-intouch.com
Mon Jan 15 10:48:03 PST 2001
I've attached the changes to the database in the form of pretty_print
output as well as a modified schema.html which attempts to explain the
changes. I'll send a modified fs-setup once I try it on my test machine,
if necessary.
-Kristian
-------------- next part --------------
<head>
<title>Schema reference</title>
</head>
<body>
<h1>Schema reference</h1>
<ul>
<li><a name="agent">agent</a> - Agents are resellers of your service. Agents may be limited to a subset of your full offerings (via their agent type).
<ul>
<li>agentnum - primary key
<li>agent - name of this agent
<li>typenum - <a href="#agent_type">agent type</a>
<li>prog - (unimplemented)
<li>freq - (unimplemented)
<li>parent - agentnum of parent agent (for commission calculations)
</ul>
<li><a name="agent_type">agent_type</a> - Agent types define groups of packages that you can then assign to particular agents.
<ul>
<li>typenum - primary key
<li>atype - name of this agent type
</ul>
<li><a name="cust_bill">cust_bill</a> - Invoices
<ul>
<li>invnum - primary key
<li>custnum - <a href="#cust_main">customer</a>
<li>_date
<li>charged - amount of this invoice
<li>owed - amount still outstanding on this invoice (Removed. cust_bill->owed is now a method which calculates invoice's remaining balance.)
<li>printed - how many times this invoice has been printed automatically
<li>com_paid - date commission was paid for this invoice
</ul>
<li><a name="cust_bill_pkg">cust_bill_pkg</a> - Invoice line items
<ul>
<li>invnum - (multiple) key
<li>pkgnum - <a href="#cust_pkg">package</a>
<li>setup - setup fee
<li>recur - recurring fee
<li>sdate - starting date
<li>edate - ending date
</ul>
<li><a name="cust_credit">cust_credit</a> - Credits (Removed? Credits merged into cust_pay.)
<ul>
<li>crednum - primary key
<li>custnum - <a href="#cust_main">customer</a>
<li>amount - amount credited
<li>credited - amount still outstanding (not yet refunded) on this credit
<li>_date
<li>otaker - order taker
<li>reason
</ul>
<li><a name="cust_main">cust_main</a> - Customers
<ul>
<li>custnum - primary key
<li>agentnum - <a href="#agent">agent</a>
<li>refnum - <a href="#part_referral">referral</a>
<li>titlenum - <a href="#part_title">title</a>
<li>first - name
<li>middle - name
<li>last - name
<li>ss - social security number
<li>company
<li>address1
<li>address2
<li>city
<li>county
<li>state
<li>zip
<li>country
<li>daytime - phone
<li>night - phone
<li>fax - phone
<li>payby - CARD, BILL, or COMP
<li>payinfo - card number, P.O.#, or comp issuer
<li>paydate - expiration date
<li>payname - billing name (name on card)
<li>tax - tax exempt, Y or null
<li>otaker - order taker
</ul>
<li><a name="cust_main_invoice">cust_main_invoice</a> - Invoice destinations for email invoices
<ul>
<li>destnum - primary key
<li>custnum - <a href="#cust_main">customer</a>
<li>dest - Invoice destination: If numeric, a <a href="#svc_acct">svcnum</a>, if string, a literal email address, or `POST' to enable mailing (the default if no cust_main_invoice records exist)
</ul>
<li><a name="cust_main_county">cust_main_county</a> - Tax rates
<ul>
<li>taxnum - primary key
<li>state
<li>county
<li>country
<li>tax - % rate
</ul>
<li><a name="cust_pay">cust_pay</a> - Payments
<ul>
<li>paynum - primary key
<li>invnum - <a href="#cust_bill">invoice</a>
<li>paid - amount
<li>_date
<li>payby - CARD, BILL, or COMP
<li>payinfo - card number, P.O.#, or comp issuer
<li>paybatch - text field for tracking card processor batches
<li>credit - A boolean field for identifying credits in cust_pay.
</ul>
<li><a name="cust_pay_batch">cust_pay_batch</a> - Pending batch
<ul>
<li>trancode - 77 for charges
<li>cardnum
<li>exp - card expiration
<li>amount
<li>invnum - <a href="#cust_bill">invoice</a>
<li>custnum - <a href="#cust_main">customer</a>
<li>payname - name on card
<li>first - name
<li>last - name
<li>address1
<li>address2
<li>city
<li>state
<li>zip
<li>country
</ul>
<li><a name="cust_pkg">cust_pkg</a> - Customer billing items
<ul>
<li>pkgnum - primary key
<li>custnum - <a href="#cust_main">customer</a>
<li>pkgpart - <a href="#part_pkg">Package definition</a>
<li>setup - date
<li>bill - next bill date
<li>susp - (past) suspension date
<li>expire - (future) cancellation date
<li>cancel - (past) cancellation date
<li>otaker - order taker
</ul>
<li><a name="cust_refund">cust_refund</a> - Refunds
<ul>
<li>refundnum - primary key
<li>crednum - <a href="#cust_credit">credit</a>
<li>refund - amount
<li>_date
<li>payby - CARD, BILL or COMP
<li>payinfo - card number, P.O.#, or comp issuer
<li>otaker - order taker
</ul>
<li><a name="cust_svc">cust_svc</a> - Customer services
<ul>
<li>svcnum - primary key
<li>pkgnum - <a href="#cust_pkg">package</a>
<li>svcpart - <a href="#part_svc">Service definition</a>
</ul>
<li><a name="part_pkg">part_pkg</a> - Package definitions
<ul>
<li>pkgpart - primary key
<li>pkg - package name
<li>comment - non-customer visable package comment
<li>setup - setup fee
<li>freq - recurring frequency (months)
<li>recur - recurring fee
</ul>
<li><a name="part_referral">part_referral</a> - Referral listing
<ul>
<li>refnum - primary key
<li>referral - referral
</ul>
<li><a name="part_svc">part_svc</a> - Service definitions
<ul>
<li>svcpart - primary key
<li>svc - name of this service
<li>svcdb - table used for this service: svc_acct, svc_acct_sm, svc_domain, svc_charge or svc_wo
<li><i>table</i>__<i>field</i> - Default or fixed value for <i>field</i> in <i>table</i>
<li><i>table</i>__<i>field</i>_flag - null, D or F
</ul>
<li><a name="part_title">part_title</a> - Personal titles (Obsolete?)
<ul>
<li>titlenum - primary key
<li>title - personal title (`Dr.' or `Mr.')
</ul>
<li><a name="pkg_svc">pkg_svc</a>
<ul>
<li>pkgpart - <a href="#part_pkg">Package definition</a>
<li>svcpart - <a href="#part_svc">Service definition</a>
<li>quantity - quantity of this service that this package includes
</ul>
<li><a name="prepay_credit">prepay_credit</a>
<ul>
<li>prepaynum - primary key
<li>identifier - text or numeric string used to receive this credit
<li>amount - amount of credit
</ul>
<li><a name="svc_acct">svc_acct</a> - Accounts
<ul>
<li>svcnum - <a href="#cust_svc">primary key</a>
<li>username
<li>_password
<li>popnum - <a href="#svc_acct_pop">Point of Presence</a>
<li>uid
<li>gid
<li>finger - GECOS
<li>dir
<li>shell
<li>quota - (unimplementd)
<li>slipip - IP address
<li>radius_<i>Radius_Attribute</i> - Radius-Attribute
<li>attr_template - Radius attribute template name as defined in table radius_attr_template
<li>active - Boolean field for radius server to check account status. Useful if using encrypted passwords.
<li>radius_attr - Additional Radius attributes not available in an attr_template.
<li>pgpkeyid - Part of a hack for the exim MTA that PGP encrypts messages prior to local delivery.
</ul>
<li><a name="svc_acct_pop">svc_acct_pop</a> - Points of Presence
<ul>
<li>popnum - primary key
<li>city
<li>state
<li>ac - area code
<li>exch - exchange
<li>loc - rest of number
</ul>
<li><a name="svc_acct_sm">svc_acct_sm</a> - Domain mail aliases
<ul>
<li>svcnum - <a href="#cust_svc">primary key</a>
<li>domsvc - <a href="#svc_domain">Domain</a> (by svcnum)
<li>maildest - Address mail matching domuser at domain is forwarded to
<li>domuser - domuser @ <a href="#svc_domain">Domain</a> forwards to maildest</a>
</ul>
<li><a name="svc_domain">svc_domain</a> - Domains
<ul>
<li>svcnum - <a href="#cust_svc">primary key</a>
<li>domain
<li>registry - See conf/registries and conf/registry_list
<li>is_local - If false, domain records are not set up.
</ul>
<li><a name="domain_record">domain_record</a> - Domain zone detail
<ul>
<li>recnum - primary key
<li>svcnum - <a href="#svc_domain">Domain</a> (by svcnum)
<li>reczone - zone for this line
<li>recaf - address family, usually <b>IN</b>
<li>rectype - type for this record (<b>A</b>, <b>MX</b>, etc.)
<li>recdata - data for this record
</ul>
<li><a name="svc_www">svc_www</a>
<li>svcnum - <a href="#cust-svc">primary key</a>
<li>recnum - <a href="#domain_record">host</a>
<li>usersvc - <a href="#svc_acct">account</a>
</ul>
<li><a name="type_pkgs">type_pkgs</a>
<ul>
<li>typenum - <a href="#agent_type">agent type</a>
<li>pkgpart - <a href="#part_pkg">Package definition</a>
</ul>
</ul>
</body>
-------------- next part --------------
'svc_acct' => {
'columns' => [
'username', 'varchar', '', '16', '', '',
'uid', 'int', 'NULL', '11', '', '',
'passwd_opt', 'varchar', 'NULL', '100', '', '',
'expire_date', 'date', 'NULL', '', '2037-01-01', '',
'quota', 'varchar', 'NULL', '80', '', '',
'start_date', 'date', 'NULL', '', '1981-08-17', '',
'slipip', 'varchar', 'NULL', '15', '', '',
'_password', 'varchar', '', '25', '', '',
'gid', 'int', 'NULL', '11', '', '',
'attr_template', 'varchar', 'NULL', '32', '', '',
'shell', 'varchar', 'NULL', '80', '', '',
'finger', 'varchar', 'NULL', '80', '', '',
'svcnum', 'int', '', '11', '0', '',
'active', 'int', 'NULL', '1', '1', '',
'dir', 'varchar', 'NULL', '80', '', '',
'popnum', 'int', 'NULL', '11', '', '',
'radius_attr', 'text', '', '', '', '',
'pgpkeyid', 'varchar', 'NULL', '80', '', '',
],
'primary_key' => 'svcnum',
'unique' => [ ],
'index' => [ [ 'username' ], [ 'username' ] ],
},
'cust_svc' => {
'columns' => [
'pkgnum', 'int', '', '11', '0', '',
'svcpart', 'int', '', '11', '0', '',
'svcnum', 'int', '', '11', '0', '',
],
'primary_key' => 'svcnum',
'unique' => [ ],
'index' => [ [ 'pkgnum' ], [ 'svcnum' ], [ 'svcnum' ], [ 'svcpart' ], [ 'pkgnum' ], [ 'svcpart' ] ],
},
'cust_bill' => {
'columns' => [
'_date', 'int', 'NULL', '11', '', '',
'invnum', 'int', '', '11', '0', '',
'printed', 'int', '', '11', '0', '',
'charged', 'decimal', '', '10,2', '0.00', '',
'bogus_owed', 'decimal', '', '10,2', '0.00', '',
'custnum', 'int', '', '11', '0', '',
'com_paid', 'int', 'NULL', '11', '', '',
],
'primary_key' => 'invnum',
'unique' => [ ],
'index' => [ [ 'custnum' ], [ 'custnum' ] ],
},
'radius_attr_template' => {
'columns' => [
'template_name', 'varchar', '', '32', '', '',
'radius_attr', 'text', 'NULL', '', '', '',
'comment', 'text', 'NULL', '', '', '',
],
'primary_key' => 'template_name',
'unique' => [ ],
'index' => [ ],
},
'cust_pay' => {
'columns' => [
'paynum', 'int', '', '11', '0', '',
'paybatch', 'varchar', 'NULL', '80', '', '',
'payby', 'varchar', '', '4', '', '',
'_date', 'int', 'NULL', '11', '', '',
'invnum', 'int', '', '11', '0', '',
'payinfo', 'varchar', 'NULL', '16', '', '',
'paid', 'decimal', '', '10,2', '0.00', '',
'credit', 'tinyint', '', '4', '0', '',
],
'primary_key' => 'paynum',
'unique' => [ ],
'index' => [ [ 'invnum' ], [ 'invnum' ] ],
},
'type_pkgs' => {
'columns' => [
'pkgpart', 'int', '', '11', '0', '',
'typenum', 'int', '', '11', '0', '',
],
'primary_key' => '',
'unique' => [ [ 'typenum', 'pkgpart' ], [ 'typenum', 'pkgpart' ] ],
'index' => [ [ 'typenum' ], [ 'typenum' ] ],
},
'cust_pkg' => {
'columns' => [
'setup', 'int', 'NULL', '11', '', '',
'pkgnum', 'int', '', '11', '0', '',
'bill', 'int', 'NULL', '11', '', '',
'cancel', 'int', 'NULL', '11', '', '',
'otaker', 'varchar', '', '8', '', '',
'pkgpart', 'int', '', '11', '0', '',
'susp', 'int', 'NULL', '11', '', '',
'expire', 'int', 'NULL', '11', '', '',
'custnum', 'int', '', '11', '0', '',
],
'primary_key' => 'pkgnum',
'unique' => [ ],
'index' => [ [ 'custnum' ], [ 'custnum' ] ],
},
'prepay_credit' => {
'columns' => [
'prepaynum', 'int', '', '11', '0', '',
'identifier', 'varchar', '', '80', '', '',
'amount', 'decimal', '', '10,2', '0.00', '',
],
'primary_key' => 'prepaynum',
'unique' => [ ],
'index' => [ [ 'identifier' ] ],
},
'svc_wireless' => {
'columns' => [
'svcnum', 'int', '', '11', '0', '',
'cellnum', 'int', 'NULL', '11', '', '',
'speed', 'int', 'NULL', '8', '', '',
'antenna', 'varchar', 'NULL', '32', '', '',
'radio', 'varchar', 'NULL', '32', '', '',
'router', 'varchar', 'NULL', '32', '', '',
'installer', 'int', 'NULL', '11', '', '',
'address', 'varchar', 'NULL', '32', '', '',
'city', 'varchar', 'NULL', '32', '', '',
'state', 'char', 'NULL', '2', '', '',
'latitude', 'varchar', 'NULL', '16', '', '',
'longitude', 'varchar', 'NULL', '16', '', '',
'ip_address', 'varchar', 'NULL', '15', '', '',
'radio_mac', 'varchar', 'NULL', '17', '', '',
'device_mac', 'varchar', 'NULL', '17', '', '',
],
'primary_key' => 'svcnum',
'unique' => [ ],
'index' => [ ],
},
'agent_type' => {
'columns' => [
'typenum', 'int', '', '11', '0', '',
'atype', 'varchar', '', '80', '', '',
],
'primary_key' => 'typenum',
'unique' => [ ],
'index' => [ ],
},
'part_referral' => {
'columns' => [
'referral', 'varchar', '', '80', '', '',
'refnum', 'int', '', '11', '0', '',
],
'primary_key' => 'refnum',
'unique' => [ ],
'index' => [ ],
},
'domain_record' => {
'columns' => [
'recnum', 'int', '', '11', '0', '',
'svcnum', 'int', '', '11', '0', '',
'reczone', 'varchar', '', '80', '', '',
'recaf', 'char', '', '2', '', '',
'rectype', 'varchar', '', '5', '', '',
'recdata', 'varchar', '', '80', '', '',
],
'primary_key' => 'recnum',
'unique' => [ ],
'index' => [ ],
},
'svc_acct_sm' => {
'columns' => [
'maildest', 'varchar', 'NULL', '80', '', '',
'domsvc', 'int', '', '11', '0', '',
'svcnum', 'int', '', '11', '0', '',
'domuser', 'varchar', '', '80', '', '',
],
'primary_key' => 'svcnum',
'unique' => [ [ 'domsvc', 'domuser' ] ],
'index' => [ ],
},
'cust_credit' => {
'columns' => [
'reason', 'varchar', '', '255', '', '',
'credited', 'decimal', '', '10,2', '0.00', '',
'amount', 'decimal', '', '10,2', '0.00', '',
'_date', 'int', 'NULL', '11', '', '',
'otaker', 'varchar', '', '8', '', '',
'crednum', 'int', '', '11', '0', '',
'custnum', 'int', '', '11', '0', '',
],
'primary_key' => 'crednum',
'unique' => [ ],
'index' => [ [ 'custnum' ], [ 'custnum' ] ],
},
'svc_wireless_cell' => {
'columns' => [
'cellnum', 'int', '', '11', '0', '',
'address', 'varchar', 'NULL', '32', '', '',
'city', 'varchar', 'NULL', '32', '', '',
'state', 'char', 'NULL', '2', '', '',
'latitude', 'varchar', 'NULL', '16', '', '',
'longitude', 'varchar', 'NULL', '16', '', '',
'location', 'varchar', 'NULL', '32', '', '',
'parent', 'int', '', '11', '0', '',
'channel', 'int', '', '2', '0', '',
'polarization', 'char', '', '1', 'V', '',
],
'primary_key' => 'cellnum',
'unique' => [ ],
'index' => [ ],
},
'svc_domain' => {
'columns' => [
'domain', 'varchar', '', '80', '', '',
'svcnum', 'int', '', '11', '0', '',
'registry', 'varchar', '', '32', '', '',
'is_local', 'int', '', '1', '1', '',
],
'primary_key' => 'svcnum',
'unique' => [ [ 'domain' ], [ 'domain' ] ],
'index' => [ ],
},
'pkg_svc' => {
'columns' => [
'pkgpart', 'int', '', '11', '0', '',
'svcpart', 'int', '', '11', '0', '',
'quantity', 'int', '', '11', '0', '',
],
'primary_key' => '',
'unique' => [ [ 'pkgpart', 'svcpart' ], [ 'pkgpart', 'svcpart' ] ],
'index' => [ [ 'pkgpart' ], [ 'pkgpart' ] ],
},
'agent' => {
'columns' => [
'prog', 'varchar', 'NULL', '255', '', '',
'typenum', 'int', '', '11', '0', '',
'freq', 'int', 'NULL', '11', '', '',
'agent', 'varchar', '', '80', '', '',
'agentnum', 'int', '', '11', '0', 'auto_increment',
'parent', 'int', '', '11', '0', '',
],
'primary_key' => 'agentnum',
'unique' => [ ],
'index' => [ [ 'typenum' ], [ 'typenum' ] ],
},
'cust_main' => {
'columns' => [
'state', 'varchar', 'NULL', '80', '', '',
'county', 'varchar', 'NULL', '80', '', '',
'payby', 'varchar', '', '4', '', '',
'otaker', 'varchar', '', '8', '', '',
'ss', 'varchar', 'NULL', '11', '', '',
'paydate', 'varchar', 'NULL', '10', '', '',
'first', 'varchar', '', '80', '', '',
'payname', 'varchar', 'NULL', '80', '', '',
'refnum', 'int', '', '11', '0', '',
'tax', 'char', 'NULL', '1', '', '',
'daytime', 'varchar', 'NULL', '20', '', '',
'custnum', 'int', '', '11', '0', '',
'zip', 'varchar', '', '10', '', '',
'last', 'varchar', '', '80', '', '',
'country', 'char', '', '2', '', '',
'payinfo', 'varchar', 'NULL', '17', '', '',
'company', 'varchar', 'NULL', '80', '', '',
'address1', 'varchar', '', '80', '', '',
'address2', 'varchar', 'NULL', '80', '', '',
'city', 'varchar', '', '80', '', '',
'night', 'varchar', 'NULL', '20', '', '',
'agentnum', 'int', '', '11', '0', '',
'fax', 'varchar', 'NULL', '12', '', '',
],
'primary_key' => 'custnum',
'unique' => [ ],
'index' => [ [ 'last' ], [ 'last' ] ],
},
'cust_main_county' => {
'columns' => [
'state', 'varchar', 'NULL', '80', '', '',
'county', 'varchar', 'NULL', '80', '', '',
'country', 'char', '', '2', '', '',
'tax', 'double', '', '16,4', '0.0000', '',
'taxnum', 'int', '', '11', '0', '',
],
'primary_key' => 'taxnum',
'unique' => [ ],
'index' => [ ],
},
'radacct' => {
'columns' => [
'User_Name', 'char', 'NULL', '32', '', '',
'Start', 'int', 'NULL', '16', '', '',
'Stop', 'int', 'NULL', '16', '', '',
'NAS', 'char', '', '20', '', '',
'Session_Id', 'char', 'NULL', '32', '', '',
'framed_addr', 'char', '', '16', '0.0.0.0', '',
],
'primary_key' => '',
'unique' => [ ],
'index' => [ ],
},
'svc_www' => {
'columns' => [
'svcnum', 'int', '', '11', '0', '',
'recnum', 'int', '', '11', '0', '',
'usersvc', 'int', '', '11', '0', '',
],
'primary_key' => 'svcnum',
'unique' => [ ],
'index' => [ ],
},
'radius_acct_attr' => {
'columns' => [
'attr', 'char', '', '32', '', '',
'field', 'char', '', '32', '', '',
],
'primary_key' => 'field',
'unique' => [ ],
'index' => [ ],
},
'part_svc' => {
'columns' => [
'svc_acct__active', 'int', '', '1', '1', '',
'svc_acct_sm__domuser', 'varchar', 'NULL', '80', '', '',
'svc_acct__dir', 'varchar', 'NULL', '80', '', '',
'svcpart', 'int', '', '11', '0', '',
'svc_acct_sm__maildest', 'varchar', 'NULL', '80', '', '',
'svc_acct__uid', 'varchar', 'NULL', '80', '', '',
'svc_acct__radius_attr', 'text', 'NULL', '', '', '',
'svc_acct__quota_flag', 'char', 'NULL', '1', '', '',
'svc_acct__expire_date_flag', 'char', 'NULL', '1', '', '',
'svc_acct__start_date_flag', 'char', 'NULL', '1', '', '',
'svc_acct__passwd_opt', 'varchar', 'NULL', '100', '', '',
'svc', 'varchar', '', '80', '', '',
'svc_acct__slipip_flag', 'char', 'NULL', '1', '', '',
'svc_acct___password_flag', 'char', 'NULL', '1', '', '',
'svc_acct__start_date', 'date', 'NULL', '', '', '',
'svc_acct__gid_flag', 'char', 'NULL', '1', '', '',
'svcdb', 'varchar', '', '80', '', '',
'svc_acct__attr_template_flag', 'char', 'NULL', '1', '', '',
'svc_acct__shell_flag', 'char', 'NULL', '1', '', '',
'svc_acct__slipip', 'varchar', 'NULL', '80', '', '',
'svc_acct__active_flag', 'char', 'NULL', '1', '', '',
'svc_acct_sm__domuser_flag', 'char', 'NULL', '1', '', '',
'svc_acct__popnum_flag', 'char', 'NULL', '1', '', '',
'svc_acct__uid_flag', 'char', 'NULL', '1', '', '',
'svc_acct__radius_attr_flag', 'char', 'NULL', '1', '', '',
'svc_acct__passwd_opt_flag', 'char', 'NULL', '1', '', '',
'svc_acct__popnum', 'varchar', 'NULL', '80', '', '',
'svc_acct__username', 'varchar', 'NULL', '80', '', '',
'svc_acct_sm__domsvc_flag', 'char', 'NULL', '1', '', '',
'svc_acct__expire_date', 'date', 'NULL', '', '', '',
'svc_acct__quota', 'varchar', 'NULL', '80', '', '',
'svc_acct_sm__domsvc', 'varchar', 'NULL', '80', '', '',
'svc_domain__domain_flag', 'char', 'NULL', '1', '', '',
'svc_acct___password', 'varchar', 'NULL', '80', '', '',
'svc_acct__gid', 'varchar', 'NULL', '80', '', '',
'svc_acct__finger_flag', 'char', 'NULL', '1', '', '',
'svc_domain__domain', 'varchar', 'NULL', '80', '', '',
'svc_acct__attr_template', 'varchar', 'NULL', '32', '', '',
'svc_acct__shell', 'varchar', 'NULL', '80', '', '',
'svc_acct__dir_flag', 'char', 'NULL', '1', '', '',
'svc_acct__username_flag', 'char', 'NULL', '1', '', '',
'svc_acct_sm__maildest_flag', 'char', 'NULL', '1', '', '',
'svc_acct__finger', 'varchar', 'NULL', '80', '', '',
'svc_wireless__speed', 'int', 'NULL', '8', '', '',
'svc_wireless__speed_flag', 'char', 'NULL', '1', '', '',
],
'primary_key' => 'svcpart',
'unique' => [ ],
'index' => [ ],
},
'cust_notes' => {
'columns' => [
'notenum', 'int', '', '11', '0', 'auto_increment',
'notes', 'blob', 'NULL', '', '', '',
'custnum', 'int', '', '11', '0', '',
'notedate', 'int', 'NULL', '11', '', '',
],
'primary_key' => 'notenum',
'unique' => [ ],
'index' => [ [ 'custnum' ] ],
},
'cust_pay_batch' => {
'columns' => [
'trancode', 'int', '', '11', '0', '',
'state', 'varchar', '', '80', '', '',
'zip', 'varchar', '', '10', '', '',
'amount', 'decimal', '', '10,2', '0.00', '',
'country', 'char', '', '2', '', '',
'last', 'varchar', '', '80', '', '',
'address1', 'varchar', '', '80', '', '',
'first', 'varchar', '', '80', '', '',
'address2', 'varchar', 'NULL', '80', '', '',
'city', 'varchar', '', '80', '', '',
'cardnum', 'varchar', '', '16', '', '',
'payname', 'varchar', 'NULL', '80', '', '',
'exp', 'int', 'NULL', '11', '', '',
'invnum', 'int', '', '11', '0', '',
'custnum', 'int', '', '11', '0', '',
],
'primary_key' => '',
'unique' => [ ],
'index' => [ [ 'invnum' ], [ 'invnum' ], [ 'custnum' ], [ 'custnum' ] ],
},
'cust_refund' => {
'columns' => [
'reason', 'varchar', '', '80', '', '',
'refund', 'decimal', '', '10,2', '0.00', '',
'refundnum', 'int', '', '11', '0', '',
'payby', 'varchar', '', '4', '', '',
'_date', 'int', 'NULL', '11', '', '',
'payinfo', 'varchar', 'NULL', '16', '', '',
'otaker', 'varchar', '', '8', '', '',
'crednum', 'int', '', '11', '0', '',
],
'primary_key' => 'refundnum',
'unique' => [ ],
'index' => [ [ 'crednum' ], [ 'crednum' ] ],
},
'part_pkg' => {
'columns' => [
'recur', 'varchar', 'NULL', '255', '', '',
'setup', 'varchar', 'NULL', '255', '', '',
'pkgpart', 'int', '', '11', '0', '',
'pkg', 'varchar', '', '80', '', '',
'comment', 'varchar', '', '80', '', '',
'freq', 'int', '', '11', '0', '',
],
'primary_key' => 'pkgpart',
'unique' => [ ],
'index' => [ ],
},
'cust_bill_pkg' => {
'columns' => [
'sdate', 'int', 'NULL', '11', '', '',
'recur', 'decimal', '', '10,2', '0.00', '',
'setup', 'decimal', '', '10,2', '0.00', '',
'pkgnum', 'int', '', '11', '0', '',
'edate', 'int', 'NULL', '11', '', '',
'invnum', 'int', '', '11', '0', '',
],
'primary_key' => '',
'unique' => [ [ 'pkgnum', 'invnum' ], [ 'pkgnum', 'invnum' ] ],
'index' => [ [ 'invnum' ], [ 'invnum' ] ],
},
'cust_main_invoice' => {
'columns' => [
'dest', 'varchar', '', '80', '', '',
'destnum', 'int', '', '11', '0', '',
'custnum', 'int', '', '11', '0', '',
],
'primary_key' => 'destnum',
'unique' => [ ],
'index' => [ [ 'custnum' ], [ 'custnum' ] ],
},
'agent_type_pkg' => {
'columns' => [
'typenum', 'int', '', '11', '0', '',
'pkgpart', 'int', '', '11', '0', '',
'tier', 'int', '', '11', '0', '',
'commission', 'double', '', '16,4', '0.0000', '',
],
'primary_key' => 'tier',
'unique' => [ ],
'index' => [ ],
},
'svc_acct_pop' => {
'columns' => [
'exch', 'char', '', '3', '', '',
'state', 'varchar', '', '80', '', '',
'city', 'varchar', '', '80', '', '',
'ac', 'char', '', '3', '', '',
'popnum', 'int', '', '11', '0', '',
'loc', 'varchar', 'NULL', '4', '', '',
],
'primary_key' => 'popnum',
'unique' => [ ],
'index' => [ ],
}
More information about the freeside-users
mailing list