I. 11/6/2014 4:28:52 SQL Anywhere MobiLink Client Version 12.0.0.2601 I. 11/6/2014 4:28:52 I. 11/6/2014 4:28:52 Copyright © 2001-2010, iAnywhere Solutions, Inc. I. 11/6/2014 4:28:52 Portions copyright © 1988-2010, Sybase, Inc. All rights reserved. I. 11/6/2014 4:28:52 Use of this software is governed by the Sybase L icense Agreement. I. 11/6/2014 4:28:52 Refer to http://www.sybase.com/softwarelicenses. I. 11/6/2014 4:28:52 I. 11/6/2014 4:28:52 1: -c I. 11/6/2014 4:28:52 2: ***************** I. 11/6/2014 4:28:52 3: -ci I. 11/6/2014 4:28:52 4: 10M I. 11/6/2014 4:28:52 5: -cm I. 11/6/2014 4:28:52 6: 75M I. 11/6/2014 4:28:52 7: -ek I. 11/6/2014 4:28:52 8: ********************************************* ******** I. 11/6/2014 4:28:52 9: -e I. 11/6/2014 4:28:52 10: ctp=tls;adr='host=******;port=*****;tr usted_certificates=C:\EBCS\sync\ebcs.crt'; sv=v12_3; sa=ON; ft=OFF; st=ON I. 11/6/2014 4:28:52 11: -qc I. 11/6/2014 4:28:52 12: -o I. 11/6/2014 4:28:52 13: C:\EBCS\sync\dbmlsync.out I. 11/6/2014 4:28:52 14: -vnosu I. 11/6/2014 4:28:52 15: -os I. 11/6/2014 4:28:52 16: 10M I. 11/6/2014 4:28:52 17: -x I. 11/6/2014 4:28:52 Connecting to remote database I. 11/6/2014 4:28:52 Loading synchronization information I. 11/6/2014 4:28:52 Begin synchronizing subscription(s) '2681_upload ' I. 11/6/2014 4:28:52 Options for this synchronization: I. 11/6/2014 4:28:52 FT=NO,ST=YES,SV=v12_3,SA=YES,CTP=tls,ADR ='host=74.93.207.225;port=2439;trusted_certificates=C:\EBCS\sync\ebcs.crt' I. 11/6/2014 4:28:52 Log scan starting at offset 0947380997 I. 11/6/2014 4:28:52 Processing transaction logs from directory "C:\E BCS\Database\" I. 11/6/2014 4:28:52 Deleted old log file "C:\EBCS\Database\141104AA. LOG" I. 11/6/2014 4:28:52 Transaction log "C:\EBCS\Database\141105AA.LOG" starts at offset 0945351189 I. 11/6/2014 4:28:52 Processing transactions from transaction log "C: \EBCS\Database\141105AA.LOG" I. 11/6/2014 4:28:52 Transaction log ends at offset 0947381050 I. 11/6/2014 4:28:52 Processing transactions from active transaction log I. 11/6/2014 4:28:53 Transaction log renamed to: C:\EBCS\Database\141 106AA.LOG I. 11/6/2014 4:28:53 Processing transaction logs from directory "C:\E BCS\Database\" I. 11/6/2014 4:28:53 Transaction log "C:\EBCS\Database\141106AA.LOG" starts at offset 0947381050 I. 11/6/2014 4:28:53 Processing transactions from transaction log "C: \EBCS\Database\141106AA.LOG" I. 11/6/2014 4:28:53 Transaction log ends at offset 0947918136 I. 11/6/2014 4:28:53 Processing transactions from active transaction log I. 11/6/2014 4:28:53 Hovering at end of active log I. 11/6/2014 4:28:53 Log scan ended at offset 0947918083 I. 11/6/2014 4:28:53 Connecting to MobiLink server at 'host=74.93.207 .225;port=2439;trusted_certificates=C:\EBCS\sync\ebcs.crt' using 'tls' I. 11/6/2014 4:28:53 Begin upload I. 11/6/2014 4:28:53 Character set: windows-1252 I. 11/6/2014 4:28:53 MobiLink user name: 2681 I. 11/6/2014 4:28:53 Script version: v12_3 I. 11/6/2014 4:28:53 Remote ID: eb52745f-36b0-48f7-9488-469b407ff0cb I. 11/6/2014 4:28:53 Subscription '2681_upload' - Synchronizing - Log offset 0947380997 - Last download time 2014-11-05 04:29:01.0. I. 11/6/2014 4:28:53 Processor is little-endian I. 11/6/2014 4:28:53 Article table: ebcs_special_charges I. 11/6/2014 4:28:53 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: numeric mod_number(8,0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: numeric seq(4,0) NOT NU LL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char special_charg_d iscript(30) NULL I. 11/6/2014 4:28:53 Article column: numeric amt_of_special_ chrg(10,2) NULL I. 11/6/2014 4:28:53 Article column: numeric num_of_times_to _charge(3,0) NULL I. 11/6/2014 4:28:53 Article column: date first_date_to_c harge NULL I. 11/6/2014 4:28:53 Article column: date next_date_to_ch arge NULL I. 11/6/2014 4:28:53 Article column: timestamp charge_creation _date NULL I. 11/6/2014 4:28:53 Article table: ebcs_temp_changes I. 11/6/2014 4:28:53 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: numeric card_num(8,0) N ULL I. 11/6/2014 4:28:53 Article column: numeric joint_accont_nu m(8,0) NULL I. 11/6/2014 4:28:53 Article column: char account_status( 10) NULL I. 11/6/2014 4:28:53 Article column: char first_name(15) NULL I. 11/6/2014 4:28:53 Article column: char last_name(15) N ULL I. 11/6/2014 4:28:53 Article column: char mi(1) NULL I. 11/6/2014 4:28:53 Article column: char generation(4) N ULL I. 11/6/2014 4:28:53 Article column: char street_num(20) NULL I. 11/6/2014 4:28:53 Article column: char street_name(20) NULL I. 11/6/2014 4:28:53 Article column: char second_line_add ress(26) NULL I. 11/6/2014 4:28:53 Article column: char city(35) NULL I. 11/6/2014 4:28:53 Article column: char state(2) NULL I. 11/6/2014 4:28:53 Article column: char zip(10) NULL I. 11/6/2014 4:28:53 Article column: char home_phone(14) NULL I. 11/6/2014 4:28:53 Article column: char work_phone(14) NULL I. 11/6/2014 4:28:53 Article column: numeric work_ext(4,0) N ULL I. 11/6/2014 4:28:53 Article column: char emp_name(20) NU LL I. 11/6/2014 4:28:53 Article column: numeric emp_street_num( 6,0) NULL I. 11/6/2014 4:28:53 Article column: char emp_street_name (20) NULL I. 11/6/2014 4:28:53 Article column: char emp_sec_line_ad dr(20) NULL I. 11/6/2014 4:28:53 Article column: char emp_city(15) NU LL I. 11/6/2014 4:28:53 Article column: char emp_state(2) NU LL I. 11/6/2014 4:28:53 Article column: numeric emp_zip(10,0) N ULL I. 11/6/2014 4:28:53 Article column: char ssn(11) NULL I. 11/6/2014 4:28:53 Article column: date dob NULL I. 11/6/2014 4:28:53 Article column: char month_of_dob(2) NULL I. 11/6/2014 4:28:53 Article column: char sex(1) NULL I. 11/6/2014 4:28:53 Article column: char height(5) NULL I. 11/6/2014 4:28:53 Article column: numeric weight(3,0) NUL L I. 11/6/2014 4:28:53 Article column: char eye_color(2) NU LL I. 11/6/2014 4:28:53 Article column: char hair_color(2) N ULL I. 11/6/2014 4:28:53 Article column: char guarantor_last_ name(15) NULL I. 11/6/2014 4:28:53 Article column: char guarantor_first _name(15) NULL I. 11/6/2014 4:28:53 Article column: char guarantor_mi(1) NULL I. 11/6/2014 4:28:53 Article column: numeric guarantor_addre ss(6,0) NULL I. 11/6/2014 4:28:53 Article column: char guarantor_cit_s t_zip(65) NULL I. 11/6/2014 4:28:53 Article column: numeric guarantor_phone _num(14,0) NULL I. 11/6/2014 4:28:53 Article column: numeric guarantor_work_ num(14,0) NULL I. 11/6/2014 4:28:53 Article column: numeric guarantor_ssn(1 1,0) NULL I. 11/6/2014 4:28:53 Article column: varchar name_test(15) N ULL I. 11/6/2014 4:28:53 Article column: char club_account(10 ) NULL I. 11/6/2014 4:28:53 Article column: char with_another_ag ency(10) NULL I. 11/6/2014 4:28:53 Article column: char bad_address(1) NULL I. 11/6/2014 4:28:53 Article column: char bad_home_num(1) NULL I. 11/6/2014 4:28:53 Article column: char bad_work_num(1) NULL I. 11/6/2014 4:28:53 Article column: char name_relative(3 0) NULL I. 11/6/2014 4:28:53 Article column: char address_relativ e(65) NULL I. 11/6/2014 4:28:53 Article column: numeric phone_num_relat ive(14,0) NULL I. 11/6/2014 4:28:53 Article column: char name_friend(30) NULL I. 11/6/2014 4:28:53 Article column: numeric phone_num_frien d(14,0) NULL I. 11/6/2014 4:28:53 Article column: char source_code(2) NULL I. 11/6/2014 4:28:53 Article column: date contract_date N ULL I. 11/6/2014 4:28:53 Article column: date contract_expir_ date NULL I. 11/6/2014 4:28:53 Article column: char name_of_contrac t(5) NULL I. 11/6/2014 4:28:53 Article column: char term_of_contrac t(3) NULL I. 11/6/2014 4:28:53 Article column: numeric cash_price_of_c ontract(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric finance_percent age(5,2) NULL I. 11/6/2014 4:28:53 Article column: numeric amount_of_finan ce_charge(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric sales_tax_perce ntage(5,4) NULL I. 11/6/2014 4:28:53 Article column: numeric amount_of_sales _tax(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric total_of_sale(8 ,2) NULL I. 11/6/2014 4:28:53 Article column: numeric down_payment(8, 2) NULL I. 11/6/2014 4:28:53 Article column: numeric financed_amount (8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric number_of_payme nts(3,0) NULL I. 11/6/2014 4:28:53 Article column: numeric amount_of_payme nt(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric remaining_num_o f_payments(3,0) NULL I. 11/6/2014 4:28:53 Article column: numeric total_of_all_pa yments(8,2) NULL I. 11/6/2014 4:28:53 Article column: date first_payment_d ue_date NULL I. 11/6/2014 4:28:53 Article column: date next_payment_du e_date NULL I. 11/6/2014 4:28:53 Article column: char method_of_payme nt(2) NULL I. 11/6/2014 4:28:53 Article column: numeric remaining_bal_o n_contract(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric current_paymts_ due(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric deliq_1to10_day _due(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric deliq_11_to30_d ays_due(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric deliq_30to60_da ys_due(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric deliq_61to90_da ys_due(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric deliq_90to120_d ays_due(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric over_120_days(8 ,2) NULL I. 11/6/2014 4:28:53 Article column: numeric total_paymt_due (8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric late_fees_owed( 8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric return_fees_owe d(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric service_fees_ow ed(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric total_amt_due_n ow(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric payoff_amt(10,2 ) NULL I. 11/6/2014 4:28:53 Article column: numeric interest_saved( 8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric total_payoff_am t(10,2) NULL I. 11/6/2014 4:28:53 Article column: char method_of_last_ paymt_recd(3) NULL I. 11/6/2014 4:28:53 Article column: numeric total_amt_of_la st_payment(8,2) NULL I. 11/6/2014 4:28:53 Article column: date date_of_last_pa ymt NULL I. 11/6/2014 4:28:53 Article column: numeric amt_applied_to_ paymts(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric amt_applied_to_ late_fees(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric amt_applied_to_ return_fees(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric amt_applied_to_ service_fees(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric days_deliq_when _recieved(4,0) NULL I. 11/6/2014 4:28:53 Article column: numeric num_of_days_lat e(4,0) NULL I. 11/6/2014 4:28:53 Article column: numeric billing_cycle(2 ,0) NULL I. 11/6/2014 4:28:53 Article column: date renewal_date NU LL I. 11/6/2014 4:28:53 Article column: numeric renewal_amt(8,2 ) NULL I. 11/6/2014 4:28:53 Article column: char special_charg_d iscript(30) NULL I. 11/6/2014 4:28:53 Article column: numeric num_of_times_to _charge(3,0) NULL I. 11/6/2014 4:28:53 Article column: numeric num_of_times_ch arged(3,0) NULL I. 11/6/2014 4:28:53 Article column: date first_date_to_c harge NULL I. 11/6/2014 4:28:53 Article column: date next_date_to_ch arge NULL I. 11/6/2014 4:28:53 Article column: char bank_name(30) N ULL I. 11/6/2014 4:28:53 Article column: char bank_address(15 ) NULL I. 11/6/2014 4:28:53 Article column: char bank_city(10) N ULL I. 11/6/2014 4:28:53 Article column: char bank_state(2) N ULL I. 11/6/2014 4:28:53 Article column: numeric bank_zip(10,0) NULL I. 11/6/2014 4:28:53 Article column: char routing_num(9) NULL I. 11/6/2014 4:28:53 Article column: char bank_acc_num(20 ) NULL I. 11/6/2014 4:28:53 Article column: numeric monthly_draft_a mt(8,2) NULL I. 11/6/2014 4:28:53 Article column: char prenote_complet e(1) NULL I. 11/6/2014 4:28:53 Article column: char monthly_eft_due s(1) NULL I. 11/6/2014 4:28:53 Article column: char monthly_pb_dues (1) NULL I. 11/6/2014 4:28:53 Article column: char mail_invoice(1) NULL I. 11/6/2014 4:28:53 Article column: char credit_card_nam e(30) NULL I. 11/6/2014 4:28:53 Article column: char credit_card_tye (4) NULL I. 11/6/2014 4:28:53 Article column: numeric credit_card_num (17,0) NULL I. 11/6/2014 4:28:53 Article column: numeric old_credit_card _num(17,0) NULL I. 11/6/2014 4:28:53 Article column: numeric monthly_cc_draf t(8,2) NULL I. 11/6/2014 4:28:53 Article column: date credit_card_exp rtion_date NULL I. 11/6/2014 4:28:53 Article column: char last_name_on_ba ck_acct(15) NULL I. 11/6/2014 4:28:53 Article column: char first_name_on_b ank_acct(15) NULL I. 11/6/2014 4:28:53 Article column: char mi_on_bank_acct (1) NULL I. 11/6/2014 4:28:53 Article column: char last_name_on_cr edit_card(15) NULL I. 11/6/2014 4:28:53 Article column: char first_name_on_c redit_card(15) NULL I. 11/6/2014 4:28:53 Article column: char mi_on_credit_ca rd(1) NULL I. 11/6/2014 4:28:53 Article column: numeric num_of_lat_noti ces_maild(2,0) NULL I. 11/6/2014 4:28:53 Article column: date date_of_last_la te_notice NULL I. 11/6/2014 4:28:53 Article column: numeric number_of_pb_ma iled(1,0) NULL I. 11/6/2014 4:28:53 Article column: date date_of_last_pb NULL I. 11/6/2014 4:28:53 Article column: date date_1st_renewa l_mailed NULL I. 11/6/2014 4:28:53 Article column: date date_2nd_renewa l_mailed NULL I. 11/6/2014 4:28:53 Article column: numeric late_fee_waived (8,2) NULL I. 11/6/2014 4:28:53 Article column: date date_of_collect ion_letter NULL I. 11/6/2014 4:28:53 Article column: numeric return_fee_waiv ed(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric service_fee_wai ved(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric payments_waived (8,2) NULL I. 11/6/2014 4:28:53 Article column: char reason_for_canc el(2) NULL I. 11/6/2014 4:28:53 Article column: date reactivate_date NULL I. 11/6/2014 4:28:53 Article column: date last_debit_date NULL I. 11/6/2014 4:28:53 Article column: date date_of_court_h earing NULL I. 11/6/2014 4:28:53 Article column: date member_since NU LL I. 11/6/2014 4:28:53 Article column: date original_contra t_date NULL I. 11/6/2014 4:28:53 Article column: date rewrite_date NU LL I. 11/6/2014 4:28:53 Article column: numeric total_money_pai d_to_date(8,2) NULL I. 11/6/2014 4:28:53 Article column: char fist_sale_perso n(10) NULL I. 11/6/2014 4:28:53 Article column: char sec_sale_person (10) NULL I. 11/6/2014 4:28:53 Article column: char commision(1) NU LL I. 11/6/2014 4:28:53 Article column: date cancel_acc_afte r_date NULL I. 11/6/2014 4:28:53 Article column: char purge_from_sys( 1) NULL I. 11/6/2014 4:28:53 Article column: char rewitten_by(10) NULL I. 11/6/2014 4:28:53 Article column: date promise_to_pay_ date NULL I. 11/6/2014 4:28:53 Article column: numeric late_fee_charge (8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric service_fee_cha rge(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric return_fee_char ge(8,2) NULL I. 11/6/2014 4:28:53 Article column: char acct_created_by (15) NULL I. 11/6/2014 4:28:53 Article column: date date_account_en tered NULL I. 11/6/2014 4:28:53 Article column: numeric num_of_outgoin_ calls(4,0) NULL I. 11/6/2014 4:28:53 Article column: numeric num_of_incoming _calls(4,0) NULL I. 11/6/2014 4:28:53 Article column: char reason_for_free ze(60) NULL I. 11/6/2014 4:28:53 Article column: date effective_date_ freeze NULL I. 11/6/2014 4:28:53 Article column: date extend_expire_d ate NULL I. 11/6/2014 4:28:53 Article column: char misc_field(10) NULL I. 11/6/2014 4:28:53 Article column: char notes_line_one( 50) NULL I. 11/6/2014 4:28:53 Article column: char notes_line_two( 50) NULL I. 11/6/2014 4:28:53 Article column: char contract_on_hol d(1) NULL I. 11/6/2014 4:28:53 Article column: date date_status_cha nged NULL I. 11/6/2014 4:28:53 Article column: numeric old_account_num (8,0) NULL I. 11/6/2014 4:28:53 Article column: long binary id_picture NULL I. 11/6/2014 4:28:53 Article column: date date_of_last_vi sit NULL I. 11/6/2014 4:28:53 Article column: numeric number_of_visit s(5,0) NULL I. 11/6/2014 4:28:53 Article column: char personal_traine r(1) NULL I. 11/6/2014 4:28:53 Article column: numeric total_princ_plu s_fin_due(8,2) NULL I. 11/6/2014 4:28:53 Article column: char bacode_printed( 1) NULL I. 11/6/2014 4:28:53 Article column: date date_barode_pri nted NULL I. 11/6/2014 4:28:53 Article column: numeric num_times_barco de_printed(3,0) NULL I. 11/6/2014 4:28:53 Article column: date date_of_return NULL I. 11/6/2014 4:28:53 Article column: char reason_returned (25) NULL I. 11/6/2014 4:28:53 Article column: numeric amount_of_retur n(8,2) NULL I. 11/6/2014 4:28:53 Article column: date due_date_of_ret urn NULL I. 11/6/2014 4:28:53 Article column: numeric amt_of_special_ chrg(10,2) NULL I. 11/6/2014 4:28:53 Article column: char email_address(7 5) NULL I. 11/6/2014 4:28:53 Article column: char club_database(1 ) NULL I. 11/6/2014 4:28:53 Article column: numeric credit(6,2) NUL L I. 11/6/2014 4:28:53 Article column: date change_date NUL L I. 11/6/2014 4:28:53 Article column: date create_date NUL L I. 11/6/2014 4:28:53 Article column: char previous_status (10) NULL I. 11/6/2014 4:28:53 Article column: char commish_paid(1) NULL I. 11/6/2014 4:28:53 Article column: time night_mod_time NULL I. 11/6/2014 4:28:53 Article column: numeric map_member_ref_ num(8,0) NULL I. 11/6/2014 4:28:53 Article column: numeric map_num_of_cred its(4,0) NULL I. 11/6/2014 4:28:53 Article column: numeric map_credit_amt( 8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric map_credit_tota l(8,2) NULL I. 11/6/2014 4:28:53 Article column: char contract_type(5 ) NULL I. 11/6/2014 4:28:53 Article column: char ebcs_status(10) NULL I. 11/6/2014 4:28:53 Article column: date ebcs_status_dat e NULL I. 11/6/2014 4:28:53 Article column: char service_1_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service_2_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service_3_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service_4_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service_5_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service_6_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service_7_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service_8_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service_9_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service_10_yn(1 ) NULL I. 11/6/2014 4:28:53 Article column: char all_days_hours_ yn(1) NULL I. 11/6/2014 4:28:53 Article column: char monday_yn(1) NU LL I. 11/6/2014 4:28:53 Article column: char tuesday_yn(1) N ULL I. 11/6/2014 4:28:53 Article column: char wednesday_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char thursday_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char friday_yn(1) NU LL I. 11/6/2014 4:28:53 Article column: char saturday_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char sunday_yn(1) NU LL I. 11/6/2014 4:28:53 Article column: time monday_start_ti me NULL I. 11/6/2014 4:28:53 Article column: time monday_end_time NULL I. 11/6/2014 4:28:53 Article column: time tuesday_start_t ime NULL I. 11/6/2014 4:28:53 Article column: time tuesday_end_tim e NULL I. 11/6/2014 4:28:53 Article column: time wednesday_start _time NULL I. 11/6/2014 4:28:53 Article column: time wednesday_end_t ime NULL I. 11/6/2014 4:28:53 Article column: time thursday_start_ time NULL I. 11/6/2014 4:28:53 Article column: time thursday_end_ti me NULL I. 11/6/2014 4:28:53 Article column: time friday_start_ti me NULL I. 11/6/2014 4:28:53 Article column: time friday_end_time NULL I. 11/6/2014 4:28:53 Article column: time saturday_start_ time NULL I. 11/6/2014 4:28:53 Article column: time saturday_end_ti me NULL I. 11/6/2014 4:28:53 Article column: time sunday_start_ti me NULL I. 11/6/2014 4:28:53 Article column: time sunday_end_time NULL I. 11/6/2014 4:28:53 Article column: numeric cur_mod_number( 8,0) NULL I. 11/6/2014 4:28:53 Article column: char minor_yn(1) NUL L I. 11/6/2014 4:28:53 Article column: char drivers_license (25) NULL I. 11/6/2014 4:28:53 Article column: char married_single( 1) NULL I. 11/6/2014 4:28:53 Article column: char guarantor_relat ionship(20) NULL I. 11/6/2014 4:28:53 Article column: date guarantor_dob N ULL I. 11/6/2014 4:28:53 Article column: char auto_renewal(1) NULL I. 11/6/2014 4:28:53 Article column: char contract_edit_y n(1) NULL I. 11/6/2014 4:28:53 Article column: numeric initiation_fee( 8,2) NULL I. 11/6/2014 4:28:53 Article column: char cash_price_edit _yn(1) NULL I. 11/6/2014 4:28:53 Article column: numeric renewal_term(2, 0) NULL I. 11/6/2014 4:28:53 Article column: char department(20) NULL I. 11/6/2014 4:28:53 Article column: numeric cell_phone(14,0 ) NULL I. 11/6/2014 4:28:53 Article column: char relation_relati ve(20) NULL I. 11/6/2014 4:28:53 Article column: char relation(20) NU LL I. 11/6/2014 4:28:53 Article column: char source_other(20 ) NULL I. 11/6/2014 4:28:53 Article column: char referred_by(35) NULL I. 11/6/2014 4:28:53 Article column: char cancel_other(10 ) NULL I. 11/6/2014 4:28:53 Article column: numeric prorate_dues(8, 2) NULL I. 11/6/2014 4:28:53 Article column: numeric prorate_maint_f ee(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric maint_fee(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric maint_cycle(2,0 ) NULL I. 11/6/2014 4:28:53 Article column: numeric maint_month(2,0 ) NULL I. 11/6/2014 4:28:53 Article column: numeric maint_day(2,0) NULL I. 11/6/2014 4:28:53 Article column: char preenroll_yn(1) NULL I. 11/6/2014 4:28:53 Article column: numeric sales_tax_DP(8, 2) NULL I. 11/6/2014 4:28:53 Article column: numeric amount_of_payme nt_club(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric total_of_all_pa yments_club(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric prorate_dues_cl ub(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric initiation_fee_ club(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric prorate_maint_f ee_club(8,2) NULL I. 11/6/2014 4:28:53 Article column: char reciprocity_yn( 1) NULL I. 11/6/2014 4:28:53 Article table: ebcs_changes I. 11/6/2014 4:28:53 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: numeric mod_number(8,0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: varchar column_name(40) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article table: class_list I. 11/6/2014 4:28:53 Article column: numeric class_id(8,0) N OT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char class_name(60) NULL I. 11/6/2014 4:28:53 Article column: char sun(1) NULL I. 11/6/2014 4:28:53 Article column: char mon(1) NULL I. 11/6/2014 4:28:53 Article column: char tue(1) NULL I. 11/6/2014 4:28:53 Article column: char wed(1) NULL I. 11/6/2014 4:28:53 Article column: char thu(1) NULL I. 11/6/2014 4:28:53 Article column: char fri(1) NULL I. 11/6/2014 4:28:53 Article column: char sat(1) NULL I. 11/6/2014 4:28:53 Article column: date date_start NULL I. 11/6/2014 4:28:53 Article column: date date_end NULL I. 11/6/2014 4:28:53 Article column: time time_start NULL I. 11/6/2014 4:28:53 Article column: time time_end NULL I. 11/6/2014 4:28:53 Article column: char room(10) NULL I. 11/6/2014 4:28:53 Article column: numeric min_level(3,0) NULL I. 11/6/2014 4:28:53 Article column: numeric max_level(3,0) NULL I. 11/6/2014 4:28:53 Article column: numeric num_enrolled(3, 0) NULL I. 11/6/2014 4:28:53 Article column: char active(1) NULL I. 11/6/2014 4:28:53 Article column: char instructor(30) NULL I. 11/6/2014 4:28:53 Article column: numeric fee(8,2) NULL I. 11/6/2014 4:28:53 Article column: char enrolable(1) NU LL I. 11/6/2014 4:28:53 Article column: date date_added NULL I. 11/6/2014 4:28:53 Article column: date date_removed NU LL I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char tax_code(1) NUL L I. 11/6/2014 4:28:53 Article column: char department(15) NULL I. 11/6/2014 4:28:53 Article column: char sub_type(15) NU LL I. 11/6/2014 4:28:53 Article column: char age_range(20) N ULL I. 11/6/2014 4:28:53 Article column: varchar notes(250) NULL I. 11/6/2014 4:28:53 Article column: varchar class_descripti on(250) NULL I. 11/6/2014 4:28:53 Article table: class_exceptions I. 11/6/2014 4:28:53 Article column: numeric class_id(8,0) N OT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: date date_of_excp NO T NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char cancelled(1) NU LL I. 11/6/2014 4:28:53 Article column: char new_room(10) NU LL I. 11/6/2014 4:28:53 Article column: char new_instructor( 30) NULL I. 11/6/2014 4:28:53 Article column: date new_date NULL I. 11/6/2014 4:28:53 Article column: time new_time NULL I. 11/6/2014 4:28:53 Article column: char information(100 ) NULL I. 11/6/2014 4:28:53 Article column: date date_envoked NU LL I. 11/6/2014 4:28:53 Article column: char authorizer(30) NULL I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article table: xlat_cancel I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char cancel_code(2) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char description(15) NULL I. 11/6/2014 4:28:53 Article table: commission I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: numeric account_num(8,0 ) NULL I. 11/6/2014 4:28:53 Article column: numeric receipt_num(10, 0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char employee_num(10 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: numeric clerk_num(5,0) NULL I. 11/6/2014 4:28:53 Article column: numeric register_num(5, 0) NULL I. 11/6/2014 4:28:53 Article column: date commission_date NULL I. 11/6/2014 4:28:53 Article column: time commission_time NULL I. 11/6/2014 4:28:53 Article column: char plu_num(15) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char description(20) NULL I. 11/6/2014 4:28:53 Article column: char catagory(10) NU LL I. 11/6/2014 4:28:53 Article column: char department(10) NULL I. 11/6/2014 4:28:53 Article column: numeric qty(5,0) NULL I. 11/6/2014 4:28:53 Article column: numeric amount(8,2) NUL L I. 11/6/2014 4:28:53 Article column: char tender_type(10) NULL I. 11/6/2014 4:28:53 Article column: char commission_paid (1) NULL I. 11/6/2014 4:28:53 Article table: retail_credit_card I. 11/6/2014 4:28:53 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char card_num(20) NU LL I. 11/6/2014 4:28:53 Article column: char issuer(4) NULL I. 11/6/2014 4:28:53 Article column: char member_name(20) NULL I. 11/6/2014 4:28:53 Article column: char expdate(4) NULL I. 11/6/2014 4:28:53 Article table: scheduler I. 11/6/2014 4:28:53 Article column: char first_name(30) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char last_name(30) N OT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char mi(1) NULL I. 11/6/2014 4:28:53 Article column: char club_mem(1) NUL L I. 11/6/2014 4:28:53 Article column: numeric account_num(8,0 ) NULL I. 11/6/2014 4:28:53 Article column: numeric class_id(8,0) N OT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char addr(50) NULL I. 11/6/2014 4:28:53 Article column: char city(30) NULL I. 11/6/2014 4:28:53 Article column: char state(2) NULL I. 11/6/2014 4:28:53 Article column: numeric zip(5,0) NULL I. 11/6/2014 4:28:53 Article column: numeric home_phone(10,0 ) NULL I. 11/6/2014 4:28:53 Article column: numeric cell_phone(10,0 ) NULL I. 11/6/2014 4:28:53 Article column: char email(75) NULL I. 11/6/2014 4:28:53 Article column: char active(1) NULL I. 11/6/2014 4:28:53 Article column: date date_added NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: date date_removed NU LL I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article table: receipt_liability I. 11/6/2014 4:28:53 Article column: numeric id_number(2,0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char line1(40) NULL I. 11/6/2014 4:28:53 Article column: char line2(40) NULL I. 11/6/2014 4:28:53 Article column: char line3(40) NULL I. 11/6/2014 4:28:53 Article column: char line4(40) NULL I. 11/6/2014 4:28:53 Article column: char line5(40) NULL I. 11/6/2014 4:28:53 Article column: char line6(40) NULL I. 11/6/2014 4:28:53 Article column: char line7(40) NULL I. 11/6/2014 4:28:53 Article column: char line8(40) NULL I. 11/6/2014 4:28:53 Article column: char line9(40) NULL I. 11/6/2014 4:28:53 Article column: char line10(40) NULL I. 11/6/2014 4:28:53 Article column: char line11(40) NULL I. 11/6/2014 4:28:53 Article column: char line12(40) NULL I. 11/6/2014 4:28:53 Article column: char line13(40) NULL I. 11/6/2014 4:28:53 Article column: char line14(40) NULL I. 11/6/2014 4:28:53 Article column: char line15(40) NULL I. 11/6/2014 4:28:53 Article column: char line16(40) NULL I. 11/6/2014 4:28:53 Article column: char line17(40) NULL I. 11/6/2014 4:28:53 Article column: char line18(40) NULL I. 11/6/2014 4:28:53 Article column: char line19(40) NULL I. 11/6/2014 4:28:53 Article column: char line20(40) NULL I. 11/6/2014 4:28:53 Article column: char line21(40) NULL I. 11/6/2014 4:28:53 Article column: char line22(40) NULL I. 11/6/2014 4:28:53 Article column: char line23(40) NULL I. 11/6/2014 4:28:53 Article column: char line24(40) NULL I. 11/6/2014 4:28:53 Article column: char line25(40) NULL I. 11/6/2014 4:28:53 Article column: char line26(40) NULL I. 11/6/2014 4:28:53 Article column: char line27(40) NULL I. 11/6/2014 4:28:53 Article column: char line28(40) NULL I. 11/6/2014 4:28:53 Article column: char line29(40) NULL I. 11/6/2014 4:28:53 Article column: char line30(40) NULL I. 11/6/2014 4:28:53 Article column: char line31(40) NULL I. 11/6/2014 4:28:53 Article column: char line32(40) NULL I. 11/6/2014 4:28:53 Article column: char line33(40) NULL I. 11/6/2014 4:28:53 Article column: char line34(40) NULL I. 11/6/2014 4:28:53 Article column: char line35(40) NULL I. 11/6/2014 4:28:53 Article column: char line36(40) NULL I. 11/6/2014 4:28:53 Article column: char line37(40) NULL I. 11/6/2014 4:28:53 Article column: char line38(40) NULL I. 11/6/2014 4:28:53 Article column: char line39(40) NULL I. 11/6/2014 4:28:53 Article column: char line40(40) NULL I. 11/6/2014 4:28:53 Article column: char line41(40) NULL I. 11/6/2014 4:28:53 Article column: char line42(40) NULL I. 11/6/2014 4:28:53 Article column: char line43(40) NULL I. 11/6/2014 4:28:53 Article column: char line44(40) NULL I. 11/6/2014 4:28:53 Article column: char line45(40) NULL I. 11/6/2014 4:28:53 Article column: char line46(40) NULL I. 11/6/2014 4:28:53 Article column: char line47(40) NULL I. 11/6/2014 4:28:53 Article column: char line48(40) NULL I. 11/6/2014 4:28:53 Article column: char line49(40) NULL I. 11/6/2014 4:28:53 Article column: char line50(40) NULL I. 11/6/2014 4:28:53 Article table: escrow I. 11/6/2014 4:28:53 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: numeric card_num(8,0) N ULL I. 11/6/2014 4:28:53 Article column: numeric escrow_amt(8,2) NULL I. 11/6/2014 4:28:53 Article table: visits I. 11/6/2014 4:28:53 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: numeric number_of_visit s(5,0) NULL I. 11/6/2014 4:28:53 Article column: date date_of_last_vi sit NULL I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article table: escrow_history I. 11/6/2014 4:28:53 Article column: numeric account_num(8,0 ) NULL I. 11/6/2014 4:28:53 Article column: numeric receipt_num(10, 0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: date trans_date NULL I. 11/6/2014 4:28:53 Article column: time trans_time NULL I. 11/6/2014 4:28:53 Article column: decimal trans_amt(8,2) NULL I. 11/6/2014 4:28:53 Article column: decimal old_amt(8,2) NU LL I. 11/6/2014 4:28:53 Article column: decimal new_amt(8,2) NU LL I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article table: inventory_tracking I. 11/6/2014 4:28:53 Article column: char plu_num(15) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: date date_stocked NO T NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: time time_stocked NO T NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char employee_num(10 ) NULL I. 11/6/2014 4:28:53 Article column: numeric previous_qty(5, 0) NULL I. 11/6/2014 4:28:53 Article column: numeric restock_qty(5,0 ) NULL I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: numeric old_cost(8,2) N ULL I. 11/6/2014 4:28:53 Article column: numeric new_cost(8,2) N ULL I. 11/6/2014 4:28:53 Article column: numeric old_sale_price( 8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric new_sale_price( 8,2) NULL I. 11/6/2014 4:28:53 Article table: EBCS_Version I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char version(10) NOT NULL I. 11/6/2014 4:28:53 Article table: ebcs_contract_versions I. 11/6/2014 4:28:53 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: numeric mod_number(8,0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: date contract_date N ULL I. 11/6/2014 4:28:53 Article column: long binary contract_blob N ULL I. 11/6/2014 4:28:53 Article column: char ebcs_code(1) NU LL I. 11/6/2014 4:28:53 Article column: char salesperson_id( 10) NULL I. 11/6/2014 4:28:53 Article table: ebcs_pic I. 11/6/2014 4:28:53 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: long binary member_pic NULL I. 11/6/2014 4:28:53 Article table: aba_info I. 11/6/2014 4:28:53 Article column: char bank_name(30) N OT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char routing_num(9) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char notes(255) NULL I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article table: service_xlat I. 11/6/2014 4:28:53 Article column: char service_1(15) N ULL I. 11/6/2014 4:28:53 Article column: char service_2(15) N ULL I. 11/6/2014 4:28:53 Article column: char service_3(15) N ULL I. 11/6/2014 4:28:53 Article column: char service_4(15) N ULL I. 11/6/2014 4:28:53 Article column: char service_5(15) N ULL I. 11/6/2014 4:28:53 Article column: char service_6(15) N ULL I. 11/6/2014 4:28:53 Article column: char service_7(15) N ULL I. 11/6/2014 4:28:53 Article column: char service_8(15) N ULL I. 11/6/2014 4:28:53 Article column: char service_9(15) N ULL I. 11/6/2014 4:28:53 Article column: char service_10(15) NULL I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article table: contract_type I. 11/6/2014 4:28:53 Article column: char contract_type_n ame(30) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char contract_type_c ode(5) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char contract_type_d escription(50) NULL I. 11/6/2014 4:28:53 Article column: char all_days_hours_ yn(1) NULL I. 11/6/2014 4:28:53 Article column: char monday_yn(1) NU LL I. 11/6/2014 4:28:53 Article column: char tuesday_yn(1) N ULL I. 11/6/2014 4:28:53 Article column: char wednesday_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char thursday_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char friday_yn(1) NU LL I. 11/6/2014 4:28:53 Article column: char saturday_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char sunday_yn(1) NU LL I. 11/6/2014 4:28:53 Article column: time monday_start_ti me NULL I. 11/6/2014 4:28:53 Article column: time monday_end_time NULL I. 11/6/2014 4:28:53 Article column: time tuesday_start_t ime NULL I. 11/6/2014 4:28:53 Article column: time tuesday_end_tim e NULL I. 11/6/2014 4:28:53 Article column: time wednesday_start _time NULL I. 11/6/2014 4:28:53 Article column: time wednesday_end_t ime NULL I. 11/6/2014 4:28:53 Article column: time thursday_start_ time NULL I. 11/6/2014 4:28:53 Article column: time thursday_end_ti me NULL I. 11/6/2014 4:28:53 Article column: time friday_start_ti me NULL I. 11/6/2014 4:28:53 Article column: time friday_end_time NULL I. 11/6/2014 4:28:53 Article column: time saturday_start_ time NULL I. 11/6/2014 4:28:53 Article column: time saturday_end_ti me NULL I. 11/6/2014 4:28:53 Article column: time sunday_start_ti me NULL I. 11/6/2014 4:28:53 Article column: time sunday_end_time NULL I. 11/6/2014 4:28:53 Article column: decimal cash_price(8,2) NULL I. 11/6/2014 4:28:53 Article column: decimal initiation_fee( 8,2) NULL I. 11/6/2014 4:28:53 Article column: decimal payment_amt(8,2 ) NULL I. 11/6/2014 4:28:53 Article column: char service1_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service2_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service3_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service4_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service5_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service6_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service7_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service8_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service9_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char service10_yn(1) NULL I. 11/6/2014 4:28:53 Article column: long binary contract_templa te NULL I. 11/6/2014 4:28:53 Article column: char inactive_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char auto_renewal(1) NULL I. 11/6/2014 4:28:53 Article column: char contract_edit_y n(1) NULL I. 11/6/2014 4:28:53 Article column: char cash_price_edit _yn(1) NULL I. 11/6/2014 4:28:53 Article column: numeric max_num_service s(2,0) NULL I. 11/6/2014 4:28:53 Article column: char contract_term(3 ) NULL I. 11/6/2014 4:28:53 Article column: numeric sales_tax(5,4) NULL I. 11/6/2014 4:28:53 Article column: char contract_type(5 ) NULL I. 11/6/2014 4:28:53 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: numeric prorate_dues(8, 2) NULL I. 11/6/2014 4:28:53 Article column: numeric prorate_maint_f ee(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric maint_fee(8,2) NULL I. 11/6/2014 4:28:53 Article column: numeric maint_cycle(2,0 ) NULL I. 11/6/2014 4:28:53 Article column: numeric maint_month(2,0 ) NULL I. 11/6/2014 4:28:53 Article column: numeric maint_day(2,0) NULL I. 11/6/2014 4:28:53 Article column: char preenroll_yn(1) NULL I. 11/6/2014 4:28:53 Article column: char reciprocity_yn( 1) NULL I. 11/6/2014 4:28:53 Article table: cc_transaction I. 11/6/2014 4:28:53 Article column: numeric recipt_num(10,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char sequence_num(16 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:53 Article column: char ticket(10) NULL I. 11/6/2014 4:28:53 Article column: date tran_date NULL I. 11/6/2014 4:28:53 Article column: time tran_time NULL I. 11/6/2014 4:28:53 Article column: char card_num(20) NU LL I. 11/6/2014 4:28:53 Article column: char issuer(4) NULL I. 11/6/2014 4:28:53 Article column: char member_name(20) NULL I. 11/6/2014 4:28:53 Article column: integer action NULL I. 11/6/2014 4:28:53 Article column: integer manual NULL I. 11/6/2014 4:28:54 Article column: decimal tran_amount(9,2 ) NULL I. 11/6/2014 4:28:54 Article column: char int_reference(8 ) NULL I. 11/6/2014 4:28:54 Article column: char result_ref(20) NULL I. 11/6/2014 4:28:54 Article column: char result(40) NULL I. 11/6/2014 4:28:54 Article column: char auth(30) NULL I. 11/6/2014 4:28:54 Article column: char result_auth(20) NULL I. 11/6/2014 4:28:54 Article column: char street(20) NULL I. 11/6/2014 4:28:54 Article column: char zip(9) NULL I. 11/6/2014 4:28:54 Article column: char processor(4) NU LL I. 11/6/2014 4:28:54 Article column: char merch_num(32) N ULL I. 11/6/2014 4:28:54 Article column: char expdate(4) NULL I. 11/6/2014 4:28:54 Article column: char cvv2_resp(2) NU LL I. 11/6/2014 4:28:54 Article column: char cc_user(10) NUL L I. 11/6/2014 4:28:54 Article column: char troutd(10) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: vendor I. 11/6/2014 4:28:54 Article column: numeric vendor_code(6,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char vendor_company( 30) NULL I. 11/6/2014 4:28:54 Article column: char phone_1(14) NUL L I. 11/6/2014 4:28:54 Article column: char phone_2(14) NUL L I. 11/6/2014 4:28:54 Article column: char account_num(10) NULL I. 11/6/2014 4:28:54 Article column: char last_name(15) N ULL I. 11/6/2014 4:28:54 Article column: char first_name(15) NULL I. 11/6/2014 4:28:54 Article column: char street(30) NULL I. 11/6/2014 4:28:54 Article column: char city(20) NULL I. 11/6/2014 4:28:54 Article column: char state(2) NULL I. 11/6/2014 4:28:54 Article column: char zip(10) NULL I. 11/6/2014 4:28:54 Article column: char email(30) NULL I. 11/6/2014 4:28:54 Article column: char active(1) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: last_receipt_num I. 11/6/2014 4:28:54 Article column: numeric receipt_num(10, 0) NOT NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric id_num(5,0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: gift_card_history I. 11/6/2014 4:28:54 Article column: char giftcard_id(16) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric recipt_num(10,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: date trans_date NULL I. 11/6/2014 4:28:54 Article column: time trans_time NULL I. 11/6/2014 4:28:54 Article column: decimal trans_amt(8,2) NULL I. 11/6/2014 4:28:54 Article column: char trans_type(1) N ULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: gift_card I. 11/6/2014 4:28:54 Article column: char giftcard_id(16) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: decimal giftcard_bal(8, 2) NULL I. 11/6/2014 4:28:54 Article column: date last_trans_dt N ULL I. 11/6/2014 4:28:54 Article column: time last_trans_tm N ULL I. 11/6/2014 4:28:54 Article column: decimal last_trans_amt( 8,2) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: reg_master_detail I. 11/6/2014 4:28:54 Article column: numeric recipt_num(10,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char plu_num(15) NOT NULL I. 11/6/2014 4:28:54 Article column: char description(20) NULL I. 11/6/2014 4:28:54 Article column: numeric qty(5,0) NULL I. 11/6/2014 4:28:54 Article column: numeric unit_price(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric total_price(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: numeric item_num(8,0) N OT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric register_num(5, 0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: decimal tax(8,2) NULL I. 11/6/2014 4:28:54 Article column: decimal tax_total(8,2) NULL I. 11/6/2014 4:28:54 Article column: char tax_code(1) NUL L I. 11/6/2014 4:28:54 Article column: char catagory(10) NU LL I. 11/6/2014 4:28:54 Article column: char department(10) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: member_file I. 11/6/2014 4:28:54 Article column: integer id_num NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NOT NULL I. 11/6/2014 4:28:54 Article column: char account_status( 10) NULL I. 11/6/2014 4:28:54 Article column: numeric card_num(8,0) N ULL I. 11/6/2014 4:28:54 Article column: numeric joint_accont_nu m(8,0) NULL I. 11/6/2014 4:28:54 Article column: char first_name(15) NULL I. 11/6/2014 4:28:54 Article column: char last_name(15) N ULL I. 11/6/2014 4:28:54 Article column: char mi(1) NULL I. 11/6/2014 4:28:54 Article column: char generation(4) N ULL I. 11/6/2014 4:28:54 Article column: char street_num(20) NULL I. 11/6/2014 4:28:54 Article column: char street_name(20) NULL I. 11/6/2014 4:28:54 Article column: char second_line_add ress(26) NULL I. 11/6/2014 4:28:54 Article column: char city(30) NULL I. 11/6/2014 4:28:54 Article column: char state(2) NULL I. 11/6/2014 4:28:54 Article column: char zip(10) NULL I. 11/6/2014 4:28:54 Article column: char home_phone(14) NULL I. 11/6/2014 4:28:54 Article column: char work_phone(14) NULL I. 11/6/2014 4:28:54 Article column: numeric work_ext(4,0) N ULL I. 11/6/2014 4:28:54 Article column: char emp_name(20) NU LL I. 11/6/2014 4:28:54 Article column: char ssn(11) NULL I. 11/6/2014 4:28:54 Article column: date dob NULL I. 11/6/2014 4:28:54 Article column: char month_of_dob(2) NULL I. 11/6/2014 4:28:54 Article column: char sex(1) NULL I. 11/6/2014 4:28:54 Article column: char source_code(2) NULL I. 11/6/2014 4:28:54 Article column: date contract_date N ULL I. 11/6/2014 4:28:54 Article column: date contract_expir_ date NULL I. 11/6/2014 4:28:54 Article column: char name_of_contrac t(5) NULL I. 11/6/2014 4:28:54 Article column: char term_of_contrac t(3) NULL I. 11/6/2014 4:28:54 Article column: numeric cash_price_of_c ontract(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric total_of_sale(8 ,2) NULL I. 11/6/2014 4:28:54 Article column: numeric down_payment(8, 2) NULL I. 11/6/2014 4:28:54 Article column: numeric number_of_payme nts(3,0) NULL I. 11/6/2014 4:28:54 Article column: numeric amount_of_payme nt(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric remaining_num_o f_payments(3,0) NULL I. 11/6/2014 4:28:54 Article column: numeric total_of_all_pa yments(8,2) NULL I. 11/6/2014 4:28:54 Article column: date first_payment_d ue_date NULL I. 11/6/2014 4:28:54 Article column: date next_payment_du e_date NULL I. 11/6/2014 4:28:54 Article column: char method_of_payme nt(2) NULL I. 11/6/2014 4:28:54 Article column: numeric remaining_bal_o n_contract(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric current_paymts_ due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric deliq_1to10_day _due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric deliq_11_to30_d ays_due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric deliq_30to60_da ys_due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric deliq_61to90_da ys_due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric deliq_90to120_d ays_due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric over_120_days(8 ,2) NULL I. 11/6/2014 4:28:54 Article column: numeric total_paymt_due (8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric late_fees_owed( 8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric return_fees_owe d(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric service_fees_ow ed(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric total_amt_due_n ow(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric payoff_amt(10,2 ) NULL I. 11/6/2014 4:28:54 Article column: char method_of_last_ paymt_recd(3) NULL I. 11/6/2014 4:28:54 Article column: numeric total_amt_of_la st_payment(8,0) NULL I. 11/6/2014 4:28:54 Article column: date date_of_last_pa ymt NULL I. 11/6/2014 4:28:54 Article column: numeric amt_applied_to_ paymts(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric amt_applied_to_ late_fees(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric amt_applied_to_ return_fees(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric amt_applied_to_ service_fees(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric days_deliq_when _recieved(4,0) NULL I. 11/6/2014 4:28:54 Article column: numeric num_of_days_lat e(4,0) NULL I. 11/6/2014 4:28:54 Article column: numeric billing_cycle(1 ,0) NULL I. 11/6/2014 4:28:54 Article column: date renewal_date NU LL I. 11/6/2014 4:28:54 Article column: numeric renewal_amt(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: char renewal_term(1) NULL I. 11/6/2014 4:28:54 Article column: char mail_invoice(1) NULL I. 11/6/2014 4:28:54 Article column: date member_since NU LL I. 11/6/2014 4:28:54 Article column: date original_contra t_date NULL I. 11/6/2014 4:28:54 Article column: numeric total_money_pai d_to_date(8,2) NULL I. 11/6/2014 4:28:54 Article column: date date_account_en tered NULL I. 11/6/2014 4:28:54 Article column: char notes_line_one( 50) NULL I. 11/6/2014 4:28:54 Article column: char notes_line_two( 50) NULL I. 11/6/2014 4:28:54 Article column: char description(75) NULL I. 11/6/2014 4:28:54 Article column: numeric credit(6,2) NUL L I. 11/6/2014 4:28:54 Article column: char court_num(5) NU LL I. 11/6/2014 4:28:54 Article column: char court_date(3) N ULL I. 11/6/2014 4:28:54 Article column: time court_time NULL I. 11/6/2014 4:28:54 Article column: char taxable(1) NULL I. 11/6/2014 4:28:54 Article column: date date_of_last_vi sit NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric number_of_visit s(4,0) NULL I. 11/6/2014 4:28:54 Article column: char misc_field(15) NULL I. 11/6/2014 4:28:54 Article column: date cancel_acc_afte r_date NULL I. 11/6/2014 4:28:54 Article column: long binary id_picture NULL I. 11/6/2014 4:28:54 Article column: numeric number_of_pb_ma iled(1,0) NULL I. 11/6/2014 4:28:54 Article column: date date_of_last_pb NULL I. 11/6/2014 4:28:54 Article column: char email_address(2 5) NULL I. 11/6/2014 4:28:54 Article column: char with_another_ag ency(10) NULL I. 11/6/2014 4:28:54 Article column: char height(5) NULL I. 11/6/2014 4:28:54 Article column: numeric weight(3,0) NUL L I. 11/6/2014 4:28:54 Article column: char eye_color(2) NU LL I. 11/6/2014 4:28:54 Article column: char hair_color(2) N ULL I. 11/6/2014 4:28:54 Article column: char bad_address(1) NULL I. 11/6/2014 4:28:54 Article column: char bad_home_num(1) NULL I. 11/6/2014 4:28:54 Article column: char bad_work_num(1) NULL I. 11/6/2014 4:28:54 Article column: char purge_from_sys( 1) NULL I. 11/6/2014 4:28:54 Article column: numeric interest_saved( 8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric total_payoff_am t(10,2) NULL I. 11/6/2014 4:28:54 Article column: numeric monthly_draft_a mt(8,2) NULL I. 11/6/2014 4:28:54 Article column: date date_of_return NULL I. 11/6/2014 4:28:54 Article column: char reason_returned (25) NULL I. 11/6/2014 4:28:54 Article column: numeric amount_of_retur n(8,2) NULL I. 11/6/2014 4:28:54 Article column: date due_date_of_ret urn NULL I. 11/6/2014 4:28:54 Article column: char fist_sale_perso n(3) NULL I. 11/6/2014 4:28:54 Article column: char sec_sale_person (3) NULL I. 11/6/2014 4:28:54 Article column: date date_1st_renewa l_mailed NULL I. 11/6/2014 4:28:54 Article column: date date_2nd_renewa l_mailed NULL I. 11/6/2014 4:28:54 Article column: date date_of_collect ion_letter NULL I. 11/6/2014 4:28:54 Article column: date date_sent_to_tr w NULL I. 11/6/2014 4:28:54 Article column: numeric num_of_lat_noti ces_maild(2,0) NULL I. 11/6/2014 4:28:54 Article column: date date_of_last_la te_notice NULL I. 11/6/2014 4:28:54 Article column: date rewrite_date NU LL I. 11/6/2014 4:28:54 Article column: numeric finance_percent age(5,2) NULL I. 11/6/2014 4:28:54 Article column: numeric amount_of_finan ce_charge(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric financed_amount (8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric num_of_times_ch arged(4,0) NULL I. 11/6/2014 4:28:54 Article column: numeric num_of_times_to _charge(4,0) NULL I. 11/6/2014 4:28:54 Article column: char special_charg_d iscript(30) NULL I. 11/6/2014 4:28:54 Article column: date first_date_to_c harge NULL I. 11/6/2014 4:28:54 Article column: date next_date_to_ch arge NULL I. 11/6/2014 4:28:54 Article column: numeric amt_of_special_ chrg(10,2) NULL I. 11/6/2014 4:28:54 Article column: numeric total_princ_plu s_fin_due(8,2) NULL I. 11/6/2014 4:28:54 Article column: char club_database(1 ) NULL I. 11/6/2014 4:28:54 Article column: date credit_date NUL L I. 11/6/2014 4:28:54 Article column: char bank_name(30) N ULL I. 11/6/2014 4:28:54 Article column: char bank_address(15 ) NULL I. 11/6/2014 4:28:54 Article column: char bank_city(10) N ULL I. 11/6/2014 4:28:54 Article column: char bank_state(2) N ULL I. 11/6/2014 4:28:54 Article column: numeric bank_zip(10,0) NULL I. 11/6/2014 4:28:54 Article column: char routing_num(9) NULL I. 11/6/2014 4:28:54 Article column: char bank_acc_num(20 ) NULL I. 11/6/2014 4:28:54 Article column: date credit_card_exp rtion_date NULL I. 11/6/2014 4:28:54 Article column: char credit_card_nam e(30) NULL I. 11/6/2014 4:28:54 Article column: numeric credit_card_num (17,0) NULL I. 11/6/2014 4:28:54 Article column: char credit_card_tye (4) NULL I. 11/6/2014 4:28:54 Article column: numeric old_credit_card _num(17,0) NULL I. 11/6/2014 4:28:54 Article column: numeric monthly_cc_draf t(8,2) NULL I. 11/6/2014 4:28:54 Article column: char mi_on_bank_acct (1) NULL I. 11/6/2014 4:28:54 Article column: char mi_on_credit_ca rd(1) NULL I. 11/6/2014 4:28:54 Article column: char last_name_on_ba ck_acct(15) NULL I. 11/6/2014 4:28:54 Article column: char last_name_on_cr edit_card(15) NULL I. 11/6/2014 4:28:54 Article column: char first_name_on_b ank_acct(15) NULL I. 11/6/2014 4:28:54 Article column: char first_name_on_c redit_card(15) NULL I. 11/6/2014 4:28:54 Article column: char pct_day1(10) NU LL I. 11/6/2014 4:28:54 Article column: char pct_day2(10) NU LL I. 11/6/2014 4:28:54 Article column: char pct_day3(10) NU LL I. 11/6/2014 4:28:54 Article column: char pct_day4(10) NU LL I. 11/6/2014 4:28:54 Article column: time pct_time1_in NU LL I. 11/6/2014 4:28:54 Article column: time pct_time1_out N ULL I. 11/6/2014 4:28:54 Article column: time pct_time2_in NU LL I. 11/6/2014 4:28:54 Article column: time pct_time2_out N ULL I. 11/6/2014 4:28:54 Article column: time pct_time3_in NU LL I. 11/6/2014 4:28:54 Article column: time pct_time3_out N ULL I. 11/6/2014 4:28:54 Article column: time pct_time4_in NU LL I. 11/6/2014 4:28:54 Article column: time pct_time4_out N ULL I. 11/6/2014 4:28:54 Article column: char pct_court1_num( 10) NULL I. 11/6/2014 4:28:54 Article column: char pct_court2_num( 10) NULL I. 11/6/2014 4:28:54 Article column: char pct_court3_num( 10) NULL I. 11/6/2014 4:28:54 Article column: char pct_court4_num( 10) NULL I. 11/6/2014 4:28:54 Article column: numeric cell_phone(10,0 ) NULL I. 11/6/2014 4:28:54 Article table: pt_form_control I. 11/6/2014 4:28:54 Article column: integer id_num NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: date pt_date_from NU LL I. 11/6/2014 4:28:54 Article column: date pt_date_to NULL I. 11/6/2014 4:28:54 Article column: date pt_due_date1 NU LL I. 11/6/2014 4:28:54 Article column: date pt_due_date2 NU LL I. 11/6/2014 4:28:54 Article column: char pt_year(15) NUL L I. 11/6/2014 4:28:54 Article column: date return_by_date NULL I. 11/6/2014 4:28:54 Article column: date pt_date_from_co py NULL I. 11/6/2014 4:28:54 Article column: date pt_date_to_copy NULL I. 11/6/2014 4:28:54 Article column: date pt_due_date1_co py NULL I. 11/6/2014 4:28:54 Article column: date pt_due_date2_co py NULL I. 11/6/2014 4:28:54 Article column: char pt_year_copy(15 ) NULL I. 11/6/2014 4:28:54 Article column: date return_by_date_ copy NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: credit_file I. 11/6/2014 4:28:54 Article column: integer id_num NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NULL I. 11/6/2014 4:28:54 Article column: numeric card_num(8,0) N ULL I. 11/6/2014 4:28:54 Article column: char first_name(25) NULL I. 11/6/2014 4:28:54 Article column: char last_name(25) N ULL I. 11/6/2014 4:28:54 Article column: numeric credit_amt(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric invoice_applied _to(5,0) NULL I. 11/6/2014 4:28:54 Article column: date date_applied NU LL I. 11/6/2014 4:28:54 Article column: date date_recieved N ULL I. 11/6/2014 4:28:54 Article column: numeric recipt_num(10,0 ) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: tennis_codes I. 11/6/2014 4:28:54 Article column: integer id_num NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char description(30) NULL I. 11/6/2014 4:28:54 Article column: numeric code(5,0) NULL I. 11/6/2014 4:28:54 Article column: numeric price(8,2) NULL I. 11/6/2014 4:28:54 Article column: time time_start NULL I. 11/6/2014 4:28:54 Article column: time time_stop NULL I. 11/6/2014 4:28:54 Article column: numeric time_length(5,0 ) NULL I. 11/6/2014 4:28:54 Article column: char taxable(1) NULL I. 11/6/2014 4:28:54 Article column: numeric tax(3,2) NULL I. 11/6/2014 4:28:54 Article column: char pt_year(15) NUL L I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: tennis_control_file I. 11/6/2014 4:28:54 Article column: integer id_num NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char contrat_descrip tion(30) NULL I. 11/6/2014 4:28:54 Article column: char contract_type(2 ) NULL I. 11/6/2014 4:28:54 Article column: numeric price(8,2) NULL I. 11/6/2014 4:28:54 Article column: char tax(1) NULL I. 11/6/2014 4:28:54 Article column: numeric amt_of_payment( 8,2) NULL I. 11/6/2014 4:28:54 Article column: char message_line_on e(100) NULL I. 11/6/2014 4:28:54 Article column: char message_line_tw o(100) NULL I. 11/6/2014 4:28:54 Article column: char pt_year(12) NUL L I. 11/6/2014 4:28:54 Article column: date pt_date_from NU LL I. 11/6/2014 4:28:54 Article column: date pt_date_to NULL I. 11/6/2014 4:28:54 Article column: date pt_due_date1 NU LL I. 11/6/2014 4:28:54 Article column: date pt_due_date2 NU LL I. 11/6/2014 4:28:54 Article column: date return_by_date NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: history I. 11/6/2014 4:28:54 Article column: integer id_num NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NOT NULL I. 11/6/2014 4:28:54 Article column: numeric amt_paid(8,2) N ULL I. 11/6/2014 4:28:54 Article column: numeric balance_owed(8, 2) NULL I. 11/6/2014 4:28:54 Article column: date date_of_invoice NULL I. 11/6/2014 4:28:54 Article column: integer days_late NULL I. 11/6/2014 4:28:54 Article column: char description(50) NULL I. 11/6/2014 4:28:54 Article column: char fname(25) NULL I. 11/6/2014 4:28:54 Article column: numeric invoice_amt(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: char lname(25) NULL I. 11/6/2014 4:28:54 Article column: char mname(1) NULL I. 11/6/2014 4:28:54 Article column: numeric amt_rec(8,2) NU LL I. 11/6/2014 4:28:54 Article column: date date_rec NULL I. 11/6/2014 4:28:54 Article column: char mop(3) NULL I. 11/6/2014 4:28:54 Article column: char type(2) NULL I. 11/6/2014 4:28:54 Article column: date due_date NULL I. 11/6/2014 4:28:54 Article column: numeric invoice_num(8,0 ) NULL I. 11/6/2014 4:28:54 Article column: char taxable(1) NULL I. 11/6/2014 4:28:54 Article column: numeric tax_amt(8,2) NU LL I. 11/6/2014 4:28:54 Article column: numeric invoice_number( 8,0) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: cash_file I. 11/6/2014 4:28:54 Article column: integer id_num NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char lname(20) NULL I. 11/6/2014 4:28:54 Article column: char fname(20) NULL I. 11/6/2014 4:28:54 Article column: char mname(1) NULL I. 11/6/2014 4:28:54 Article column: numeric account_num(10, 0) NULL I. 11/6/2014 4:28:54 Article column: date date_rec NULL I. 11/6/2014 4:28:54 Article column: numeric amt_rec(8,2) NU LL I. 11/6/2014 4:28:54 Article column: char mop(3) NULL I. 11/6/2014 4:28:54 Article column: char posted_to_histo ry(1) NULL I. 11/6/2014 4:28:54 Article column: integer invoice_applied _to NULL I. 11/6/2014 4:28:54 Article column: numeric amt_applied(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: numeric invoice_number( 10,0) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: invoice_file I. 11/6/2014 4:28:54 Article column: char lname(25) NULL I. 11/6/2014 4:28:54 Article column: char fname(25) NULL I. 11/6/2014 4:28:54 Article column: char mname(1) NULL I. 11/6/2014 4:28:54 Article column: integer id_num NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric account_num(10, 0) NOT NULL I. 11/6/2014 4:28:54 Article column: date date_of_invoice NULL I. 11/6/2014 4:28:54 Article column: numeric invoice_amt(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: numeric amt_paid(8,2) N ULL I. 11/6/2014 4:28:54 Article column: numeric balance_owed(8, 2) NULL I. 11/6/2014 4:28:54 Article column: char posted_to_histo ry(1) NULL I. 11/6/2014 4:28:54 Article column: char description(50) NULL I. 11/6/2014 4:28:54 Article column: integer days_late NULL I. 11/6/2014 4:28:54 Article column: char satisfied(1) NU LL I. 11/6/2014 4:28:54 Article column: char type(2) NULL I. 11/6/2014 4:28:54 Article column: date due_date NULL I. 11/6/2014 4:28:54 Article column: char taxable(1) NULL I. 11/6/2014 4:28:54 Article column: numeric invoice_number( 8,0) NULL I. 11/6/2014 4:28:54 Article column: numeric tax_amt(8,2) NU LL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: card_generator_pos I. 11/6/2014 4:28:54 Article column: char new_card_genera tor(15) NULL I. 11/6/2014 4:28:54 Article column: numeric id_num(5,0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char product_name(20 ) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: courts I. 11/6/2014 4:28:54 Article column: char type_of_court(3 0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char court_num(3) NO T NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: long binary court_pic NULL I. 11/6/2014 4:28:54 Article column: char cout_pic_path(4 0) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: court_prices I. 11/6/2014 4:28:54 Article column: char type_of_court(3 0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char court_num(3) NO T NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric price_per_hour( 8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric price_per_half( 8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric price_per_perso n(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric price_per_non_m ember(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric day_rate(8,2) N ULL I. 11/6/2014 4:28:54 Article column: numeric special_rate_on e(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric special_rate_tw o(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric special_rate_th ree(8,2) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: card_generator I. 11/6/2014 4:28:54 Article column: numeric new_card_genera tor(10,1) NULL I. 11/6/2014 4:28:54 Article column: numeric id_num(5,0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: baby_sit I. 11/6/2014 4:28:54 Article column: char fname(20) NULL I. 11/6/2014 4:28:54 Article column: char lname(20) NULL I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric bacode_num(8,0) NULL I. 11/6/2014 4:28:54 Article column: numeric total_price(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: numeric per_session_pri ce(8,2) NULL I. 11/6/2014 4:28:54 Article column: char trainer_name(25 ) NULL I. 11/6/2014 4:28:54 Article column: char number_of_sessi ons(10) NULL I. 11/6/2014 4:28:54 Article column: numeric session_remanin g(3,0) NULL I. 11/6/2014 4:28:54 Article column: date date_start NULL I. 11/6/2014 4:28:54 Article column: date date_end NULL I. 11/6/2014 4:28:54 Article column: varchar misc_notes(3000 0) NULL I. 11/6/2014 4:28:54 Article column: date date_of_last_se ssion NULL I. 11/6/2014 4:28:54 Article column: date date_of_session NULL I. 11/6/2014 4:28:54 Article column: time time_of_session NULL I. 11/6/2014 4:28:54 Article column: char current_rank(15 ) NULL I. 11/6/2014 4:28:54 Article column: date date_recieved N ULL I. 11/6/2014 4:28:54 Article column: date test_date NULL I. 11/6/2014 4:28:54 Article column: numeric points(10,0) NU LL I. 11/6/2014 4:28:54 Article column: char point_type(20) NULL I. 11/6/2014 4:28:54 Article column: char belt_color(30) NULL I. 11/6/2014 4:28:54 Article column: numeric sessions_used(6 ,0) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: karate I. 11/6/2014 4:28:54 Article column: char fname(20) NULL I. 11/6/2014 4:28:54 Article column: char lname(20) NULL I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric bacode_num(8,0) NULL I. 11/6/2014 4:28:54 Article column: numeric total_price(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: numeric per_session_pri ce(8,2) NULL I. 11/6/2014 4:28:54 Article column: char trainer_name(25 ) NULL I. 11/6/2014 4:28:54 Article column: char number_of_sessi ons(10) NULL I. 11/6/2014 4:28:54 Article column: numeric session_remanin g(3,0) NULL I. 11/6/2014 4:28:54 Article column: date date_start NULL I. 11/6/2014 4:28:54 Article column: date date_end NULL I. 11/6/2014 4:28:54 Article column: varchar misc_notes(3000 0) NULL I. 11/6/2014 4:28:54 Article column: date date_of_last_se ssion NULL I. 11/6/2014 4:28:54 Article column: date date_of_session NULL I. 11/6/2014 4:28:54 Article column: time time_of_session NULL I. 11/6/2014 4:28:54 Article column: char current_rank(15 ) NULL I. 11/6/2014 4:28:54 Article column: date date_recieved N ULL I. 11/6/2014 4:28:54 Article column: date test_date NULL I. 11/6/2014 4:28:54 Article column: numeric points(10,0) NU LL I. 11/6/2014 4:28:54 Article column: char point_type(20) NULL I. 11/6/2014 4:28:54 Article column: char belt_color(30) NULL I. 11/6/2014 4:28:54 Article column: numeric sessions_used(5 ,0) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: time_clock_punches I. 11/6/2014 4:28:54 Article column: char employee_num(10 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: date actual_date NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: time actual_time NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char p_type(3) NOT N ULL I. 11/6/2014 4:28:54 Article column: integer error NULL I. 11/6/2014 4:28:54 Article column: date p_date NULL I. 11/6/2014 4:28:54 Article column: time p_time NULL I. 11/6/2014 4:28:54 Article column: char adjusted_by(10) NULL I. 11/6/2014 4:28:54 Article column: date pay_period_star t NULL I. 11/6/2014 4:28:54 Article column: date pay_period_end NULL I. 11/6/2014 4:28:54 Article column: time p_time_out NULL I. 11/6/2014 4:28:54 Article column: char notes(100) NULL I. 11/6/2014 4:28:54 Article column: char payroll_num(15) NULL I. 11/6/2014 4:28:54 Article column: date p_date_out NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: employee_profile I. 11/6/2014 4:28:54 Article column: char employee_num(10 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char card_num(10) NU LL I. 11/6/2014 4:28:54 Article column: char last_name(15) N ULL I. 11/6/2014 4:28:54 Article column: char first_name(15) NULL I. 11/6/2014 4:28:54 Article column: char middle(1) NULL I. 11/6/2014 4:28:54 Article column: char street(30) NULL I. 11/6/2014 4:28:54 Article column: char city(20) NULL I. 11/6/2014 4:28:54 Article column: char state(2) NULL I. 11/6/2014 4:28:54 Article column: char zip(9) NULL I. 11/6/2014 4:28:54 Article column: char phone(10) NULL I. 11/6/2014 4:28:54 Article column: char title(15) NULL I. 11/6/2014 4:28:54 Article column: char dept(10) NULL I. 11/6/2014 4:28:54 Article column: date hire_date NULL I. 11/6/2014 4:28:54 Article column: numeric exemptions(3,0) NULL I. 11/6/2014 4:28:54 Article column: char ssn(9) NULL I. 11/6/2014 4:28:54 Article column: char status(10) NULL I. 11/6/2014 4:28:54 Article column: numeric security_level( 1,0) NULL I. 11/6/2014 4:28:54 Article column: char password(8) NUL L I. 11/6/2014 4:28:54 Article column: date release_date NU LL I. 11/6/2014 4:28:54 Article column: numeric hour_rate(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric salary_rate(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: char notes(100) NULL I. 11/6/2014 4:28:54 Article column: numeric commision(19,4) NULL I. 11/6/2014 4:28:54 Article column: numeric bonus(19,4) NUL L I. 11/6/2014 4:28:54 Article column: numeric health(19,4) NU LL I. 11/6/2014 4:28:54 Article column: numeric car_alloance(19 ,4) NULL I. 11/6/2014 4:28:54 Article column: char employee_notes( 250) NULL I. 11/6/2014 4:28:54 Article column: char payroll_num(15) NULL I. 11/6/2014 4:28:54 Article column: char salesperson_yn( 1) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char manager_yn(1) N ULL I. 11/6/2014 4:28:54 Article table: sounds I. 11/6/2014 4:28:54 Article column: integer function_id NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char sound_location( 40) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: tanning I. 11/6/2014 4:28:54 Article column: char fname(20) NULL I. 11/6/2014 4:28:54 Article column: char lname(20) NULL I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric bacode_num(8,0) NULL I. 11/6/2014 4:28:54 Article column: numeric total_price(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: numeric per_session_pri ce(8,2) NULL I. 11/6/2014 4:28:54 Article column: char number_of_sessi ons(10) NULL I. 11/6/2014 4:28:54 Article column: numeric session_remanin g(3,0) NULL I. 11/6/2014 4:28:54 Article column: date date_start NULL I. 11/6/2014 4:28:54 Article column: date date_end NULL I. 11/6/2014 4:28:54 Article column: varchar misc_notes(3000 0) NULL I. 11/6/2014 4:28:54 Article column: date date_of_last_se ssion NULL I. 11/6/2014 4:28:54 Article column: date date_of_session NULL I. 11/6/2014 4:28:54 Article column: time time_of_session NULL I. 11/6/2014 4:28:54 Article column: char sessions_used(5 ) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: security I. 11/6/2014 4:28:54 Article column: numeric register_num(5, 0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric unit_price(1,0) NOT NULL I. 11/6/2014 4:28:54 Article column: numeric payout(1,0) NOT NULL I. 11/6/2014 4:28:54 Article column: numeric inventory(1,0) NOT NULL I. 11/6/2014 4:28:54 Article column: numeric customer(1,0) N OT NULL I. 11/6/2014 4:28:54 Article column: numeric manage(1,0) NOT NULL I. 11/6/2014 4:28:54 Article column: numeric reports(1,0) NO T NULL I. 11/6/2014 4:28:54 Article column: numeric percent_major(1 ,0) NOT NULL I. 11/6/2014 4:28:54 Article column: numeric precent_minor(1 ,0) NOT NULL I. 11/6/2014 4:28:54 Article column: numeric precent_level(2 ,0) NOT NULL I. 11/6/2014 4:28:54 Article column: numeric drawer(1,0) NUL L I. 11/6/2014 4:28:54 Article column: numeric void(1,0) NULL I. 11/6/2014 4:28:54 Article column: numeric register(1,0) N ULL I. 11/6/2014 4:28:54 Article column: numeric x_reading(1,0) NULL I. 11/6/2014 4:28:54 Article column: numeric cust_browse(1,0 ) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: clerk I. 11/6/2014 4:28:54 Article column: numeric clerk_num(5,0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char clerk_name(30) NOT NULL I. 11/6/2014 4:28:54 Article column: char clerk_password( 8) NULL I. 11/6/2014 4:28:54 Article column: numeric security_level( 1,0) NOT NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: trainer_log I. 11/6/2014 4:28:54 Article column: char fname(15) NULL I. 11/6/2014 4:28:54 Article column: char lname(15) NULL I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric barcode_num(8,0 ) NULL I. 11/6/2014 4:28:54 Article column: numeric total_price(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: numeric per_session_pri ce(8,2) NULL I. 11/6/2014 4:28:54 Article column: char number_of_sessi ons(10) NULL I. 11/6/2014 4:28:54 Article column: numeric sessions_remain ing(3,0) NULL I. 11/6/2014 4:28:54 Article column: char trainer_name(25 ) NULL I. 11/6/2014 4:28:54 Article column: date date_of_last_se ssion NULL I. 11/6/2014 4:28:54 Article column: date date_of_session NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: time time_of_session NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: date date_start NULL I. 11/6/2014 4:28:54 Article column: date date_end NULL I. 11/6/2014 4:28:54 Article column: char service_type(2) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: personal_trainer I. 11/6/2014 4:28:54 Article column: char fname(20) NULL I. 11/6/2014 4:28:54 Article column: char lname(20) NULL I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric bacode_num(8,0) NULL I. 11/6/2014 4:28:54 Article column: numeric total_price(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: numeric per_session_pri ce(8,2) NULL I. 11/6/2014 4:28:54 Article column: char trainer_name(25 ) NULL I. 11/6/2014 4:28:54 Article column: char number_of_sessi ons(10) NULL I. 11/6/2014 4:28:54 Article column: numeric session_remanin g(3,0) NULL I. 11/6/2014 4:28:54 Article column: date date_start NULL I. 11/6/2014 4:28:54 Article column: date date_end NULL I. 11/6/2014 4:28:54 Article column: varchar misc_notes(3000 0) NULL I. 11/6/2014 4:28:54 Article column: date date_of_last_se ssion NULL I. 11/6/2014 4:28:54 Article column: date date_of_session NULL I. 11/6/2014 4:28:54 Article column: time time_of_session NULL I. 11/6/2014 4:28:54 Article column: char current_rank(15 ) NULL I. 11/6/2014 4:28:54 Article column: date date_recieved N ULL I. 11/6/2014 4:28:54 Article column: date test_date NULL I. 11/6/2014 4:28:54 Article column: numeric points(10,0) NU LL I. 11/6/2014 4:28:54 Article column: char point_type(20) NULL I. 11/6/2014 4:28:54 Article column: char belt_color(30) NULL I. 11/6/2014 4:28:54 Article column: numeric sessions_used(5 ,0) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: reg_master_tender I. 11/6/2014 4:28:54 Article column: numeric recipt_num(10,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char tender(10) NOT NULL I. 11/6/2014 4:28:54 Article column: numeric amount(8,2) NUL L I. 11/6/2014 4:28:54 Article column: numeric item_num(8,0) N OT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric register_num(5, 0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: reg_master I. 11/6/2014 4:28:54 Article column: numeric recipt_num(10,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: date date NULL I. 11/6/2014 4:28:54 Article column: time time NULL I. 11/6/2014 4:28:54 Article column: numeric register_num(5, 0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric clerk_num(5,0) NULL I. 11/6/2014 4:28:54 Article column: numeric subtotal(8,2) N ULL I. 11/6/2014 4:28:54 Article column: numeric sales_tax(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric total(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric amount_paid(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: numeric change(8,2) NUL L I. 11/6/2014 4:28:54 Article column: char customer_num(10 ) NULL I. 11/6/2014 4:28:54 Article column: char posted(1) NULL I. 11/6/2014 4:28:54 Article column: char status(10) NULL I. 11/6/2014 4:28:54 Article column: date pdate NULL I. 11/6/2014 4:28:54 Article column: time ptime NULL I. 11/6/2014 4:28:54 Article column: numeric pclerk_num(5,0) NULL I. 11/6/2014 4:28:54 Article column: char change_flag(1) NULL I. 11/6/2014 4:28:54 Article column: char returnable(1) N ULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: tender I. 11/6/2014 4:28:54 Article column: char tender_type(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: register I. 11/6/2014 4:28:54 Article column: numeric register_num(5, 0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric register_totals (10,2) NULL I. 11/6/2014 4:28:54 Article column: numeric register_start_ amount(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric register_end_am ount(8,2) NULL I. 11/6/2014 4:28:54 Article column: char receipt_mesg_1( 40) NULL I. 11/6/2014 4:28:54 Article column: char receipt_mesg_2( 40) NULL I. 11/6/2014 4:28:54 Article column: char receipt_mesg_3( 40) NULL I. 11/6/2014 4:28:54 Article column: char receipt_mesg_4( 40) NULL I. 11/6/2014 4:28:54 Article column: char receipt_mesg_5( 40) NULL I. 11/6/2014 4:28:54 Article column: char receipt_mesg_6( 40) NULL I. 11/6/2014 4:28:54 Article column: numeric receipt_num(10, 0) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char description(40) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: inventory I. 11/6/2014 4:28:54 Article column: char plu_num(15) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char description(20) NULL I. 11/6/2014 4:28:54 Article column: numeric cost(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric sell_price(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric qty(5,0) NULL I. 11/6/2014 4:28:54 Article column: char catagory(10) NU LL I. 11/6/2014 4:28:54 Article column: char deparment(10) N ULL I. 11/6/2014 4:28:54 Article column: char taxable(1) NULL I. 11/6/2014 4:28:54 Article column: numeric reorder_level(5 ,0) NULL I. 11/6/2014 4:28:54 Article column: char print_barcode(1 ) NULL I. 11/6/2014 4:28:54 Article column: char report_flag(1) NULL I. 11/6/2014 4:28:54 Article column: numeric vendor_code(6,0 ) NULL I. 11/6/2014 4:28:54 Article column: decimal reorder_amt(5,0 ) NULL I. 11/6/2014 4:28:54 Article column: char attach_name(1) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: decimal register_num(5, 0) NULL I. 11/6/2014 4:28:54 Article column: char liability(1) NU LL I. 11/6/2014 4:28:54 Article column: char commission(1) N ULL I. 11/6/2014 4:28:54 Article table: people I. 11/6/2014 4:28:54 Article column: char first_name(20) NOT NULL I. 11/6/2014 4:28:54 Article column: char last_name(20) N OT NULL I. 11/6/2014 4:28:54 Article column: char phone(12) NULL I. 11/6/2014 4:28:54 Article column: char address(35) NUL L I. 11/6/2014 4:28:54 Article column: char city(20) NULL I. 11/6/2014 4:28:54 Article column: char state(2) NULL I. 11/6/2014 4:28:54 Article column: char zip(10) NULL I. 11/6/2014 4:28:54 Article column: char company_name(35 ) NULL I. 11/6/2014 4:28:54 Article column: char fax(12) NULL I. 11/6/2014 4:28:54 Article column: char mobile(12) NULL I. 11/6/2014 4:28:54 Article column: char company_address (35) NULL I. 11/6/2014 4:28:54 Article column: char company_state(2 ) NULL I. 11/6/2014 4:28:54 Article column: char company_city(20 ) NULL I. 11/6/2014 4:28:54 Article column: char company_zip(10) NULL I. 11/6/2014 4:28:54 Article column: char name_prefix(5) NULL I. 11/6/2014 4:28:54 Article column: char notes(300) NULL I. 11/6/2014 4:28:54 Article column: char company_phone(1 2) NULL I. 11/6/2014 4:28:54 Article column: char category(35) NU LL I. 11/6/2014 4:28:54 Article column: date date_last_visit NULL I. 11/6/2014 4:28:54 Article column: numeric number_of_visit s(5,0) NULL I. 11/6/2014 4:28:54 Article column: char sales_person(15 ) NULL I. 11/6/2014 4:28:54 Article column: char weights(1) NULL I. 11/6/2014 4:28:54 Article column: char tanning(1) NULL I. 11/6/2014 4:28:54 Article column: char aerobics(1) NUL L I. 11/6/2014 4:28:54 Article column: char day_care(1) NUL L I. 11/6/2014 4:28:54 Article column: char massage(1) NULL I. 11/6/2014 4:28:54 Article column: char cardiovascular( 1) NULL I. 11/6/2014 4:28:54 Article column: char childrens_fitne ss(1) NULL I. 11/6/2014 4:28:54 Article column: char circuit_trainin g(1) NULL I. 11/6/2014 4:28:54 Article column: char one_on_one_inst ruct(1) NULL I. 11/6/2014 4:28:54 Article column: integer guest_id NOT NU LL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: date join_date NULL I. 11/6/2014 4:28:54 Article column: char hit(1) NULL I. 11/6/2014 4:28:54 Article column: char miss(1) NULL I. 11/6/2014 4:28:54 Article column: char reappoint(1) NU LL I. 11/6/2014 4:28:54 Article column: date reappoint_date NULL I. 11/6/2014 4:28:54 Article column: char guest_stat(5) N ULL I. 11/6/2014 4:28:54 Article column: char apex(1) NULL I. 11/6/2014 4:28:54 Article column: char email(75) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: customer I. 11/6/2014 4:28:54 Article column: char last_name(15) N OT NULL I. 11/6/2014 4:28:54 Article column: char first_name(15) NULL I. 11/6/2014 4:28:54 Article column: char mi(1) NULL I. 11/6/2014 4:28:54 Article column: char address(30) NUL L I. 11/6/2014 4:28:54 Article column: char city(20) NULL I. 11/6/2014 4:28:54 Article column: char state(2) NULL I. 11/6/2014 4:28:54 Article column: char zip(10) NULL I. 11/6/2014 4:28:54 Article column: char home_phone(14) NULL I. 11/6/2014 4:28:54 Article column: char work_phone(14) NULL I. 11/6/2014 4:28:54 Article column: char number_of_visit s(4) NULL I. 11/6/2014 4:28:54 Article column: char notes(25) NULL I. 11/6/2014 4:28:54 Article column: char notes2(25) NULL I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: date date_last_visit NULL I. 11/6/2014 4:28:54 Article column: numeric card_num(8,0) N ULL I. 11/6/2014 4:28:54 Article column: char escrow(1) NULL I. 11/6/2014 4:28:54 Article column: numeric escrow_amt(8,2) NULL I. 11/6/2014 4:28:54 Article column: char charge(1) NULL I. 11/6/2014 4:28:54 Article column: numeric charge_limit(8, 2) NULL I. 11/6/2014 4:28:54 Article column: numeric charged_amt(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: char customer_num(10 ) NULL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: checkina I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NOT NULL I. 11/6/2014 4:28:54 Article column: char name(31) NOT NU LL I. 11/6/2014 4:28:54 Article column: date date_checked NO T NULL I. 11/6/2014 4:28:54 Article column: time time_checked NO T NULL I. 11/6/2014 4:28:54 Article column: numeric hour_of_day(2,0 ) NOT NULL I. 11/6/2014 4:28:54 Article column: char account_status( 10) NOT NULL I. 11/6/2014 4:28:54 Article column: numeric past_due_amount (8,2) NULL I. 11/6/2014 4:28:54 Article column: char company_name(25 ) NULL I. 11/6/2014 4:28:54 Article column: char misc_event(2) N ULL I. 11/6/2014 4:28:54 Article column: date expire_date NUL L I. 11/6/2014 4:28:54 Article column: integer location_num NU LL I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: integer id_num NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: notes I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: date date_of_note NO T NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char member_name(30) NULL I. 11/6/2014 4:28:54 Article column: char subject(20) NUL L I. 11/6/2014 4:28:54 Article column: char deliver(1) NULL I. 11/6/2014 4:28:54 Article column: char note(360) NOT N ULL I. 11/6/2014 4:28:54 Article column: time time_of_note NO T NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article table: ebcs I. 11/6/2014 4:28:54 Article column: numeric account_num(8,0 ) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:54 Article column: numeric card_num(8,0) N ULL I. 11/6/2014 4:28:54 Article column: numeric joint_accont_nu m(8,0) NULL I. 11/6/2014 4:28:54 Article column: char account_status( 10) NULL I. 11/6/2014 4:28:54 Article column: char first_name(15) NULL I. 11/6/2014 4:28:54 Article column: char last_name(15) N ULL I. 11/6/2014 4:28:54 Article column: char mi(1) NULL I. 11/6/2014 4:28:54 Article column: char generation(4) N ULL I. 11/6/2014 4:28:54 Article column: char street_num(20) NULL I. 11/6/2014 4:28:54 Article column: char street_name(20) NULL I. 11/6/2014 4:28:54 Article column: char second_line_add ress(26) NULL I. 11/6/2014 4:28:54 Article column: char city(35) NULL I. 11/6/2014 4:28:54 Article column: char state(2) NULL I. 11/6/2014 4:28:54 Article column: char zip(10) NULL I. 11/6/2014 4:28:54 Article column: char home_phone(14) NULL I. 11/6/2014 4:28:54 Article column: char work_phone(14) NULL I. 11/6/2014 4:28:54 Article column: numeric work_ext(4,0) N ULL I. 11/6/2014 4:28:54 Article column: char emp_name(20) NU LL I. 11/6/2014 4:28:54 Article column: numeric emp_street_num( 6,0) NULL I. 11/6/2014 4:28:54 Article column: char emp_street_name (20) NULL I. 11/6/2014 4:28:54 Article column: char emp_sec_line_ad dr(20) NULL I. 11/6/2014 4:28:54 Article column: char emp_city(15) NU LL I. 11/6/2014 4:28:54 Article column: char emp_state(2) NU LL I. 11/6/2014 4:28:54 Article column: numeric emp_zip(10,0) N ULL I. 11/6/2014 4:28:54 Article column: char ssn(11) NULL I. 11/6/2014 4:28:54 Article column: date dob NULL I. 11/6/2014 4:28:54 Article column: char month_of_dob(2) NULL I. 11/6/2014 4:28:54 Article column: char sex(1) NULL I. 11/6/2014 4:28:54 Article column: char height(5) NULL I. 11/6/2014 4:28:54 Article column: numeric weight(3,0) NUL L I. 11/6/2014 4:28:54 Article column: char eye_color(2) NU LL I. 11/6/2014 4:28:54 Article column: char hair_color(2) N ULL I. 11/6/2014 4:28:54 Article column: char guarantor_last_ name(15) NULL I. 11/6/2014 4:28:54 Article column: char guarantor_first _name(15) NULL I. 11/6/2014 4:28:54 Article column: char guarantor_mi(1) NULL I. 11/6/2014 4:28:54 Article column: numeric guarantor_addre ss(6,0) NULL I. 11/6/2014 4:28:54 Article column: char guarantor_cit_s t_zip(65) NULL I. 11/6/2014 4:28:54 Article column: numeric guarantor_phone _num(14,0) NULL I. 11/6/2014 4:28:54 Article column: numeric guarantor_work_ num(14,0) NULL I. 11/6/2014 4:28:54 Article column: numeric guarantor_ssn(1 1,0) NULL I. 11/6/2014 4:28:54 Article column: varchar name_test(15) N ULL I. 11/6/2014 4:28:54 Article column: char club_account(10 ) NULL I. 11/6/2014 4:28:54 Article column: char with_another_ag ency(10) NULL I. 11/6/2014 4:28:54 Article column: char bad_address(1) NULL I. 11/6/2014 4:28:54 Article column: char bad_home_num(1) NULL I. 11/6/2014 4:28:54 Article column: char bad_work_num(1) NULL I. 11/6/2014 4:28:54 Article column: char name_relative(3 0) NULL I. 11/6/2014 4:28:54 Article column: char address_relativ e(65) NULL I. 11/6/2014 4:28:54 Article column: numeric phone_num_relat ive(14,0) NULL I. 11/6/2014 4:28:54 Article column: char name_friend(30) NULL I. 11/6/2014 4:28:54 Article column: numeric phone_num_frien d(14,0) NULL I. 11/6/2014 4:28:54 Article column: char source_code(2) NULL I. 11/6/2014 4:28:54 Article column: date contract_date N ULL I. 11/6/2014 4:28:54 Article column: date contract_expir_ date NULL I. 11/6/2014 4:28:54 Article column: char name_of_contrac t(5) NULL I. 11/6/2014 4:28:54 Article column: char term_of_contrac t(3) NULL I. 11/6/2014 4:28:54 Article column: numeric cash_price_of_c ontract(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric finance_percent age(5,2) NULL I. 11/6/2014 4:28:54 Article column: numeric amount_of_finan ce_charge(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric sales_tax_perce ntage(5,4) NULL I. 11/6/2014 4:28:54 Article column: numeric amount_of_sales _tax(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric total_of_sale(8 ,2) NULL I. 11/6/2014 4:28:54 Article column: numeric down_payment(8, 2) NULL I. 11/6/2014 4:28:54 Article column: numeric financed_amount (8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric number_of_payme nts(3,0) NULL I. 11/6/2014 4:28:54 Article column: numeric amount_of_payme nt(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric remaining_num_o f_payments(3,0) NULL I. 11/6/2014 4:28:54 Article column: numeric total_of_all_pa yments(8,2) NULL I. 11/6/2014 4:28:54 Article column: date first_payment_d ue_date NULL I. 11/6/2014 4:28:54 Article column: date next_payment_du e_date NULL I. 11/6/2014 4:28:54 Article column: char method_of_payme nt(2) NULL I. 11/6/2014 4:28:54 Article column: numeric remaining_bal_o n_contract(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric current_paymts_ due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric deliq_1to10_day _due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric deliq_11_to30_d ays_due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric deliq_30to60_da ys_due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric deliq_61to90_da ys_due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric deliq_90to120_d ays_due(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric over_120_days(8 ,2) NULL I. 11/6/2014 4:28:54 Article column: numeric total_paymt_due (8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric late_fees_owed( 8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric return_fees_owe d(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric service_fees_ow ed(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric total_amt_due_n ow(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric payoff_amt(10,2 ) NULL I. 11/6/2014 4:28:54 Article column: numeric interest_saved( 8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric total_payoff_am t(10,2) NULL I. 11/6/2014 4:28:54 Article column: char method_of_last_ paymt_recd(3) NULL I. 11/6/2014 4:28:54 Article column: numeric total_amt_of_la st_payment(8,2) NULL I. 11/6/2014 4:28:54 Article column: date date_of_last_pa ymt NULL I. 11/6/2014 4:28:54 Article column: numeric amt_applied_to_ paymts(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric amt_applied_to_ late_fees(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric amt_applied_to_ return_fees(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric amt_applied_to_ service_fees(8,2) NULL I. 11/6/2014 4:28:54 Article column: numeric days_deliq_when _recieved(4,0) NULL I. 11/6/2014 4:28:54 Article column: numeric num_of_days_lat e(4,0) NULL I. 11/6/2014 4:28:54 Article column: numeric billing_cycle(2 ,0) NULL I. 11/6/2014 4:28:54 Article column: date renewal_date NU LL I. 11/6/2014 4:28:54 Article column: numeric renewal_amt(8,2 ) NULL I. 11/6/2014 4:28:54 Article column: char special_charg_d iscript(30) NULL I. 11/6/2014 4:28:54 Article column: numeric num_of_times_to _charge(3,0) NULL I. 11/6/2014 4:28:54 Article column: numeric num_of_times_ch arged(3,0) NULL I. 11/6/2014 4:28:54 Article column: date first_date_to_c harge NULL I. 11/6/2014 4:28:54 Article column: date next_date_to_ch arge NULL I. 11/6/2014 4:28:54 Article column: char bank_name(30) N ULL I. 11/6/2014 4:28:54 Article column: char bank_address(15 ) NULL I. 11/6/2014 4:28:54 Article column: char bank_city(10) N ULL I. 11/6/2014 4:28:54 Article column: char bank_state(2) N ULL I. 11/6/2014 4:28:55 Article column: numeric bank_zip(10,0) NULL I. 11/6/2014 4:28:55 Article column: char routing_num(9) NULL I. 11/6/2014 4:28:55 Article column: char bank_acc_num(20 ) NULL I. 11/6/2014 4:28:55 Article column: numeric monthly_draft_a mt(8,2) NULL I. 11/6/2014 4:28:55 Article column: char prenote_complet e(1) NULL I. 11/6/2014 4:28:55 Article column: char monthly_eft_due s(1) NULL I. 11/6/2014 4:28:55 Article column: char monthly_pb_dues (1) NULL I. 11/6/2014 4:28:55 Article column: char mail_invoice(1) NULL I. 11/6/2014 4:28:55 Article column: char credit_card_nam e(30) NULL I. 11/6/2014 4:28:55 Article column: char credit_card_tye (4) NULL I. 11/6/2014 4:28:55 Article column: numeric credit_card_num (17,0) NULL I. 11/6/2014 4:28:55 Article column: numeric old_credit_card _num(17,0) NULL I. 11/6/2014 4:28:55 Article column: numeric monthly_cc_draf t(8,2) NULL I. 11/6/2014 4:28:55 Article column: date credit_card_exp rtion_date NULL I. 11/6/2014 4:28:55 Article column: char last_name_on_ba ck_acct(15) NULL I. 11/6/2014 4:28:55 Article column: char first_name_on_b ank_acct(15) NULL I. 11/6/2014 4:28:55 Article column: char mi_on_bank_acct (1) NULL I. 11/6/2014 4:28:55 Article column: char last_name_on_cr edit_card(15) NULL I. 11/6/2014 4:28:55 Article column: char first_name_on_c redit_card(15) NULL I. 11/6/2014 4:28:55 Article column: char mi_on_credit_ca rd(1) NULL I. 11/6/2014 4:28:55 Article column: numeric num_of_lat_noti ces_maild(2,0) NULL I. 11/6/2014 4:28:55 Article column: date date_of_last_la te_notice NULL I. 11/6/2014 4:28:55 Article column: numeric number_of_pb_ma iled(1,0) NULL I. 11/6/2014 4:28:55 Article column: date date_of_last_pb NULL I. 11/6/2014 4:28:55 Article column: date date_1st_renewa l_mailed NULL I. 11/6/2014 4:28:55 Article column: date date_2nd_renewa l_mailed NULL I. 11/6/2014 4:28:55 Article column: numeric late_fee_waived (8,2) NULL I. 11/6/2014 4:28:55 Article column: date date_of_collect ion_letter NULL I. 11/6/2014 4:28:55 Article column: numeric return_fee_waiv ed(8,2) NULL I. 11/6/2014 4:28:55 Article column: numeric service_fee_wai ved(8,2) NULL I. 11/6/2014 4:28:55 Article column: numeric payments_waived (8,2) NULL I. 11/6/2014 4:28:55 Article column: char reason_for_canc el(2) NULL I. 11/6/2014 4:28:55 Article column: date reactivate_date NULL I. 11/6/2014 4:28:55 Article column: date last_debit_date NULL I. 11/6/2014 4:28:55 Article column: date date_of_court_h earing NULL I. 11/6/2014 4:28:55 Article column: date member_since NU LL I. 11/6/2014 4:28:55 Article column: date original_contra t_date NULL I. 11/6/2014 4:28:55 Article column: date rewrite_date NU LL I. 11/6/2014 4:28:55 Article column: numeric total_money_pai d_to_date(8,2) NULL I. 11/6/2014 4:28:55 Article column: char fist_sale_perso n(10) NULL I. 11/6/2014 4:28:55 Article column: char sec_sale_person (10) NULL I. 11/6/2014 4:28:55 Article column: char commision(1) NU LL I. 11/6/2014 4:28:55 Article column: date cancel_acc_afte r_date NULL I. 11/6/2014 4:28:55 Article column: char purge_from_sys( 1) NULL I. 11/6/2014 4:28:55 Article column: char rewitten_by(10) NULL I. 11/6/2014 4:28:55 Article column: date promise_to_pay_ date NULL I. 11/6/2014 4:28:55 Article column: numeric late_fee_charge (8,2) NULL I. 11/6/2014 4:28:55 Article column: numeric service_fee_cha rge(8,2) NULL I. 11/6/2014 4:28:55 Article column: numeric return_fee_char ge(8,2) NULL I. 11/6/2014 4:28:55 Article column: char acct_created_by (15) NULL I. 11/6/2014 4:28:55 Article column: date date_account_en tered NULL I. 11/6/2014 4:28:55 Article column: numeric num_of_outgoin_ calls(4,0) NULL I. 11/6/2014 4:28:55 Article column: numeric num_of_incoming _calls(4,0) NULL I. 11/6/2014 4:28:55 Article column: char reason_for_free ze(60) NULL I. 11/6/2014 4:28:55 Article column: date effective_date_ freeze NULL I. 11/6/2014 4:28:55 Article column: date extend_expire_d ate NULL I. 11/6/2014 4:28:55 Article column: char misc_field(10) NULL I. 11/6/2014 4:28:55 Article column: char notes_line_one( 50) NULL I. 11/6/2014 4:28:55 Article column: char notes_line_two( 50) NULL I. 11/6/2014 4:28:55 Article column: char contract_on_hol d(1) NULL I. 11/6/2014 4:28:55 Article column: date date_status_cha nged NULL I. 11/6/2014 4:28:55 Article column: numeric old_account_num (8,0) NULL I. 11/6/2014 4:28:55 Article column: long binary id_picture NULL I. 11/6/2014 4:28:55 Article column: date date_of_last_vi sit NULL I. 11/6/2014 4:28:55 Article column: numeric number_of_visit s(5,0) NULL I. 11/6/2014 4:28:55 Article column: char personal_traine r(1) NULL I. 11/6/2014 4:28:55 Article column: numeric total_princ_plu s_fin_due(8,2) NULL I. 11/6/2014 4:28:55 Article column: char bacode_printed( 1) NULL I. 11/6/2014 4:28:55 Article column: date date_barode_pri nted NULL I. 11/6/2014 4:28:55 Article column: numeric num_times_barco de_printed(3,0) NULL I. 11/6/2014 4:28:55 Article column: date date_of_return NULL I. 11/6/2014 4:28:55 Article column: char reason_returned (25) NULL I. 11/6/2014 4:28:55 Article column: numeric amount_of_retur n(8,2) NULL I. 11/6/2014 4:28:55 Article column: date due_date_of_ret urn NULL I. 11/6/2014 4:28:55 Article column: numeric amt_of_special_ chrg(10,2) NULL I. 11/6/2014 4:28:55 Article column: char email_address(7 5) NULL I. 11/6/2014 4:28:55 Article column: char club_database(1 ) NULL I. 11/6/2014 4:28:55 Article column: numeric credit(6,2) NUL L I. 11/6/2014 4:28:55 Article column: date change_date NUL L I. 11/6/2014 4:28:55 Article column: date create_date NUL L I. 11/6/2014 4:28:55 Article column: char previous_status (10) NULL I. 11/6/2014 4:28:55 Article column: char commish_paid(1) NULL I. 11/6/2014 4:28:55 Article column: time night_mod_time NULL I. 11/6/2014 4:28:55 Article column: numeric map_member_ref_ num(8,0) NULL I. 11/6/2014 4:28:55 Article column: numeric map_num_of_cred its(4,0) NULL I. 11/6/2014 4:28:55 Article column: numeric map_credit_amt( 8,2) NULL I. 11/6/2014 4:28:55 Article column: numeric map_credit_tota l(8,2) NULL I. 11/6/2014 4:28:55 Article column: char contract_type(5 ) NULL I. 11/6/2014 4:28:55 Article column: char ebcs_status(10) NULL I. 11/6/2014 4:28:55 Article column: date ebcs_status_dat e NULL I. 11/6/2014 4:28:55 Article column: char service_1_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char service_2_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char service_3_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char service_4_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char service_5_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char service_6_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char service_7_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char service_8_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char service_9_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char service_10_yn(1 ) NULL I. 11/6/2014 4:28:55 Article column: char all_days_hours_ yn(1) NULL I. 11/6/2014 4:28:55 Article column: char monday_yn(1) NU LL I. 11/6/2014 4:28:55 Article column: char tuesday_yn(1) N ULL I. 11/6/2014 4:28:55 Article column: char wednesday_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char thursday_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char friday_yn(1) NU LL I. 11/6/2014 4:28:55 Article column: char saturday_yn(1) NULL I. 11/6/2014 4:28:55 Article column: char sunday_yn(1) NU LL I. 11/6/2014 4:28:55 Article column: time monday_start_ti me NULL I. 11/6/2014 4:28:55 Article column: time monday_end_time NULL I. 11/6/2014 4:28:55 Article column: time tuesday_start_t ime NULL I. 11/6/2014 4:28:55 Article column: time tuesday_end_tim e NULL I. 11/6/2014 4:28:55 Article column: time wednesday_start _time NULL I. 11/6/2014 4:28:55 Article column: time wednesday_end_t ime NULL I. 11/6/2014 4:28:55 Article column: time thursday_start_ time NULL I. 11/6/2014 4:28:55 Article column: time thursday_end_ti me NULL I. 11/6/2014 4:28:55 Article column: time friday_start_ti me NULL I. 11/6/2014 4:28:55 Article column: time friday_end_time NULL I. 11/6/2014 4:28:55 Article column: time saturday_start_ time NULL I. 11/6/2014 4:28:55 Article column: time saturday_end_ti me NULL I. 11/6/2014 4:28:55 Article column: time sunday_start_ti me NULL I. 11/6/2014 4:28:55 Article column: time sunday_end_time NULL I. 11/6/2014 4:28:55 Article column: numeric cur_mod_number( 8,0) NULL I. 11/6/2014 4:28:55 Article column: char minor_yn(1) NUL L I. 11/6/2014 4:28:55 Article column: char drivers_license (25) NULL I. 11/6/2014 4:28:55 Article column: char married_single( 1) NULL I. 11/6/2014 4:28:55 Article column: char guarantor_relat ionship(20) NULL I. 11/6/2014 4:28:55 Article column: date guarantor_dob N ULL I. 11/6/2014 4:28:55 Article column: char auto_renewal(1) NULL I. 11/6/2014 4:28:55 Article column: char contract_edit_y n(1) NULL I. 11/6/2014 4:28:55 Article column: numeric initiation_fee( 8,2) NULL I. 11/6/2014 4:28:55 Article column: char cash_price_edit _yn(1) NULL I. 11/6/2014 4:28:55 Article column: numeric renewal_term(2, 0) NULL I. 11/6/2014 4:28:55 Article column: char department(20) NULL I. 11/6/2014 4:28:55 Article column: numeric cell_phone(14,0 ) NULL I. 11/6/2014 4:28:55 Article column: char relation_relati ve(20) NULL I. 11/6/2014 4:28:55 Article column: char relation(20) NU LL I. 11/6/2014 4:28:55 Article column: char source_other(20 ) NULL I. 11/6/2014 4:28:55 Article column: char referred_by(35) NULL I. 11/6/2014 4:28:55 Article column: char cancel_other(10 ) NULL I. 11/6/2014 4:28:55 Article column: numeric prorate_dues(8, 2) NULL I. 11/6/2014 4:28:55 Article column: numeric prorate_maint_f ee(8,2) NULL I. 11/6/2014 4:28:55 Article column: numeric maint_fee(8,2) NULL I. 11/6/2014 4:28:55 Article column: numeric maint_cycle(2,0 ) NULL I. 11/6/2014 4:28:55 Article column: numeric maint_month(2,0 ) NULL I. 11/6/2014 4:28:55 Article column: numeric maint_day(2,0) NULL I. 11/6/2014 4:28:55 Article column: char preenroll_yn(1) NULL I. 11/6/2014 4:28:55 Article column: numeric sales_tax_DP(8, 2) NULL I. 11/6/2014 4:28:55 Article column: numeric amount_of_payme nt_club(8,2) NULL I. 11/6/2014 4:28:55 Article column: numeric total_of_all_pa yments_club(8,2) NULL I. 11/6/2014 4:28:55 Article column: numeric prorate_dues_cl ub(8,2) NULL I. 11/6/2014 4:28:55 Article column: numeric initiation_fee_ club(8,2) NULL I. 11/6/2014 4:28:55 Article column: numeric prorate_maint_f ee_club(8,2) NULL I. 11/6/2014 4:28:55 Article column: char reciprocity_yn( 1) NULL I. 11/6/2014 4:28:55 Article table: password I. 11/6/2014 4:28:55 Article column: char manager_number( 10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:55 Article column: char client_num(10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:55 Article table: stgcntrc I. 11/6/2014 4:28:55 Article column: char company_name(30 ) NOT NULL I. 11/6/2014 4:28:55 Article column: char company_address (30) NULL I. 11/6/2014 4:28:55 Article column: char company_city(10 ) NULL I. 11/6/2014 4:28:55 Article column: char company_state(2 ) NULL I. 11/6/2014 4:28:55 Article column: char company_zip(10) NULL I. 11/6/2014 4:28:55 Article column: char company_county( 4) NULL I. 11/6/2014 4:28:55 Article column: date date_in_club NU LL I. 11/6/2014 4:28:55 Article column: numeric number_in_club( 6,0) NULL I. 11/6/2014 4:28:55 Article column: numeric next_invoice_nu mber(6,0) NULL I. 11/6/2014 4:28:55 Article column: numeric next_voucher_nu mber(6,0) NULL I. 11/6/2014 4:28:55 Article column: numeric next_order_numb er(6,0) NULL I. 11/6/2014 4:28:55 Article column: char welcome_message (75) NULL I. 11/6/2014 4:28:55 Article column: char print_dispositi on(1) NULL I. 11/6/2014 4:28:55 Article column: char print_to_screen _printer(1) NULL I. 11/6/2014 4:28:55 Article column: date start_date_to_p rint NULL I. 11/6/2014 4:28:55 Article column: date end_date_to_pri nt NULL I. 11/6/2014 4:28:55 Article column: numeric start_member_to _print(8,0) NULL I. 11/6/2014 4:28:55 Article column: numeric end_member_to_p rint(8,0) NULL I. 11/6/2014 4:28:55 Article column: numeric total_number_of _records(8,0) NULL I. 11/6/2014 4:28:55 Article column: numeric sales_tax_rate( 5,4) NULL I. 11/6/2014 4:28:55 Article column: numeric annual_percenta ge_rate(5,0) NULL I. 11/6/2014 4:28:55 Article column: decimal total_sales_tax (5,4) NULL I. 11/6/2014 4:28:55 Article column: char facility_number (10) NOT NULL PRIMARY KEY I. 11/6/2014 4:28:55 Article column: char phone_num(14) N ULL I. 11/6/2014 4:28:55 Article column: char fax_num(14) NUL L I. 11/6/2014 4:28:55 Article column: char e_mail(30) NULL I. 11/6/2014 4:28:55 Article column: numeric check_in_time_d elay(4,0) NULL I. 11/6/2014 4:28:55 Article column: char bank_name(30) N ULL I. 11/6/2014 4:28:55 Article column: char branch(30) NULL I. 11/6/2014 4:28:55 Article column: char bank_phone_num( 14) NULL I. 11/6/2014 4:28:55 Article column: numeric routing_num(9,0 ) NULL I. 11/6/2014 4:28:55 Article column: char bank_account_nu m(16) NULL I. 11/6/2014 4:28:55 Article column: numeric co_fed_id_num(9 ,0) NULL I. 11/6/2014 4:28:55 Article column: char company_trade_n ame(30) NULL I. 11/6/2014 4:28:55 Article column: numeric starting_barcod e_num(10,0) NULL I. 11/6/2014 4:28:55 Article column: date last_update NUL L I. 11/6/2014 4:28:55 Article column: time time_update NUL L I. 11/6/2014 4:28:55 Article column: time time_update3 NU LL I. 11/6/2014 4:28:55 Article column: varchar custom_code(10) NULL I. 11/6/2014 4:28:55 Article column: numeric stop_amt(5,2) N ULL I. 11/6/2014 4:28:55 Article column: integer location_num NU LL I. 11/6/2014 4:28:55 Article column: numeric next_invoice_nu m(6,0) NULL I. 11/6/2014 4:28:55 Article column: numeric days_late_stop( 6,0) NULL I. 11/6/2014 4:28:55 Article column: numeric deliq_stop_amt( 8,2) NULL I. 11/6/2014 4:28:55 Article column: char invoice_message _one(100) NULL I. 11/6/2014 4:28:55 Article column: char invoice_message _two(100) NULL I. 11/6/2014 4:28:55 Article column: date change_date NUL L I. 11/6/2014 4:28:55 Article column: date create_date NUL L I. 11/6/2014 4:28:55 Article column: char port_type(5) NU LL I. 11/6/2014 4:28:55 Article column: date statement_date NULL I. 11/6/2014 4:28:55 Article column: char due_date(15) NU LL I. 11/6/2014 4:28:55 Article column: time night_mod_time NULL I. 11/6/2014 4:28:55 Article column: integer night_time_dela y NULL I. 11/6/2014 4:28:55 Article column: time night_mod_end_t ime NULL I. 11/6/2014 4:28:55 Article column: integer age_limit NULL I. 11/6/2014 4:28:55 Article column: char day_change(1) N ULL I. 11/6/2014 4:28:55 Article column: numeric deliq_late_stop (8,2) NULL I. 11/6/2014 4:28:55 Article column: char control_code(10 ) NULL I. 11/6/2014 4:28:55 Table Upload Order: ebcs_special_charges,ebcs_te mp_changes,ebcs_changes,class_list,class_exceptions,xlat_cancel,commission,retail_credit_card,scheduler,receipt_liability,escrow,visits,escrow_history,inventory_tracking,EBCS_Version,ebcs_contract_versions,e I. 11/6/2014 4:28:55 Uploading table operations I. 11/6/2014 4:28:55 # rows inserted in table ebcs_special_charges : 0 I. 11/6/2014 4:28:55 # rows deleted in table ebcs_special_charges : 0 I. 11/6/2014 4:28:55 # rows updated in table ebcs_special_charges : 0 I. 11/6/2014 4:28:55 # rows inserted in table ebcs_temp_changes : 1 I. 11/6/2014 4:28:55 # rows deleted in table ebcs_temp_changes : 7 I. 11/6/2014 4:28:55 # rows updated in table ebcs_temp_changes : 0 I. 11/6/2014 4:28:55 # rows inserted in table ebcs_changes : 3 I. 11/6/2014 4:28:55 # rows deleted in table ebcs_changes : 0 I. 11/6/2014 4:28:55 # rows updated in table ebcs_changes : 0 I. 11/6/2014 4:28:55 # rows inserted in table class_list : 0 I. 11/6/2014 4:28:55 # rows deleted in table class_list : 0 I. 11/6/2014 4:28:55 # rows updated in table class_list : 0 I. 11/6/2014 4:28:55 # rows inserted in table class_exceptions : 0 I. 11/6/2014 4:28:55 # rows deleted in table class_exceptions : 0 I. 11/6/2014 4:28:55 # rows updated in table class_exceptions : 0 I. 11/6/2014 4:28:55 # rows inserted in table xlat_cancel : 0 I. 11/6/2014 4:28:55 # rows deleted in table xlat_cancel : 0 I. 11/6/2014 4:28:55 # rows updated in table xlat_cancel : 0 I. 11/6/2014 4:28:55 # rows inserted in table commission : 0 I. 11/6/2014 4:28:55 # rows deleted in table commission : 0 I. 11/6/2014 4:28:55 # rows updated in table commission : 0 I. 11/6/2014 4:28:55 # rows inserted in table retail_credit_card : 0 I. 11/6/2014 4:28:55 # rows deleted in table retail_credit_card : 0 I. 11/6/2014 4:28:55 # rows updated in table retail_credit_card : 0 I. 11/6/2014 4:28:55 # rows inserted in table scheduler : 0 I. 11/6/2014 4:28:55 # rows deleted in table scheduler : 0 I. 11/6/2014 4:28:55 # rows updated in table scheduler : 0 I. 11/6/2014 4:28:55 # rows inserted in table receipt_liability : 0 I. 11/6/2014 4:28:55 # rows deleted in table receipt_liability : 0 I. 11/6/2014 4:28:55 # rows updated in table receipt_liability : 0 I. 11/6/2014 4:28:55 # rows inserted in table escrow : 0 I. 11/6/2014 4:28:55 # rows deleted in table escrow : 0 I. 11/6/2014 4:28:55 # rows updated in table escrow : 0 I. 11/6/2014 4:28:55 # rows inserted in table visits : 0 I. 11/6/2014 4:28:55 # rows deleted in table visits : 0 I. 11/6/2014 4:28:55 # rows updated in table visits : 0 I. 11/6/2014 4:28:55 # rows inserted in table escrow_history : 0 I. 11/6/2014 4:28:55 # rows deleted in table escrow_history : 0 I. 11/6/2014 4:28:55 # rows updated in table escrow_history : 0 I. 11/6/2014 4:28:55 # rows inserted in table inventory_tracking : 0 I. 11/6/2014 4:28:55 # rows deleted in table inventory_tracking : 0 I. 11/6/2014 4:28:55 # rows updated in table inventory_tracking : 0 I. 11/6/2014 4:28:55 # rows inserted in table EBCS_Version : 0 I. 11/6/2014 4:28:55 # rows deleted in table EBCS_Version : 0 I. 11/6/2014 4:28:55 # rows updated in table EBCS_Version : 0 I. 11/6/2014 4:28:55 # rows inserted in table ebcs_contract_versions : 2 I. 11/6/2014 4:28:55 # rows deleted in table ebcs_contract_versions : 0 I. 11/6/2014 4:28:55 # rows updated in table ebcs_contract_versions : 0 I. 11/6/2014 4:28:55 # rows inserted in table ebcs_pic : 0 I. 11/6/2014 4:28:55 # rows deleted in table ebcs_pic : 0 I. 11/6/2014 4:28:55 # rows updated in table ebcs_pic : 0 I. 11/6/2014 4:28:55 # rows inserted in table aba_info : 0 I. 11/6/2014 4:28:55 # rows deleted in table aba_info : 0 I. 11/6/2014 4:28:55 # rows updated in table aba_info : 0 I. 11/6/2014 4:28:55 # rows inserted in table service_xlat : 0 I. 11/6/2014 4:28:55 # rows deleted in table service_xlat : 0 I. 11/6/2014 4:28:55 # rows updated in table service_xlat : 0 I. 11/6/2014 4:28:55 # rows inserted in table contract_type : 0 I. 11/6/2014 4:28:55 # rows deleted in table contract_type : 0 I. 11/6/2014 4:28:55 # rows updated in table contract_type : 0 I. 11/6/2014 4:28:55 # rows inserted in table cc_transaction : 0 I. 11/6/2014 4:28:55 # rows deleted in table cc_transaction : 0 I. 11/6/2014 4:28:55 # rows updated in table cc_transaction : 0 I. 11/6/2014 4:28:55 # rows inserted in table vendor : 0 I. 11/6/2014 4:28:55 # rows deleted in table vendor : 0 I. 11/6/2014 4:28:55 # rows updated in table vendor : 0 I. 11/6/2014 4:28:55 # rows inserted in table last_receipt_num : 0 I. 11/6/2014 4:28:55 # rows deleted in table last_receipt_num : 0 I. 11/6/2014 4:28:55 # rows updated in table last_receipt_num : 1 I. 11/6/2014 4:28:55 # rows inserted in table gift_card_history : 0 I. 11/6/2014 4:28:55 # rows deleted in table gift_card_history : 0 I. 11/6/2014 4:28:55 # rows updated in table gift_card_history : 0 I. 11/6/2014 4:28:55 # rows inserted in table gift_card : 0 I. 11/6/2014 4:28:55 # rows deleted in table gift_card : 0 I. 11/6/2014 4:28:55 # rows updated in table gift_card : 0 I. 11/6/2014 4:28:55 # rows inserted in table reg_master_detail : 51 I. 11/6/2014 4:28:55 # rows deleted in table reg_master_detail : 0 I. 11/6/2014 4:28:55 # rows updated in table reg_master_detail : 0 I. 11/6/2014 4:28:55 # rows inserted in table member_file : 0 I. 11/6/2014 4:28:55 # rows deleted in table member_file : 0 I. 11/6/2014 4:28:55 # rows updated in table member_file : 0 I. 11/6/2014 4:28:55 # rows inserted in table pt_form_control : 0 I. 11/6/2014 4:28:55 # rows deleted in table pt_form_control : 0 I. 11/6/2014 4:28:55 # rows updated in table pt_form_control : 0 I. 11/6/2014 4:28:55 # rows inserted in table credit_file : 5 I. 11/6/2014 4:28:55 # rows deleted in table credit_file : 0 I. 11/6/2014 4:28:55 # rows updated in table credit_file : 0 I. 11/6/2014 4:28:55 # rows inserted in table tennis_codes : 0 I. 11/6/2014 4:28:55 # rows deleted in table tennis_codes : 0 I. 11/6/2014 4:28:55 # rows updated in table tennis_codes : 0 I. 11/6/2014 4:28:55 # rows inserted in table tennis_control_file : 0 I. 11/6/2014 4:28:55 # rows deleted in table tennis_control_file : 0 I. 11/6/2014 4:28:55 # rows updated in table tennis_control_file : 0 I. 11/6/2014 4:28:55 # rows inserted in table history : 0 I. 11/6/2014 4:28:55 # rows deleted in table history : 0 I. 11/6/2014 4:28:55 # rows updated in table history : 0 I. 11/6/2014 4:28:55 # rows inserted in table cash_file : 0 I. 11/6/2014 4:28:55 # rows deleted in table cash_file : 0 I. 11/6/2014 4:28:55 # rows updated in table cash_file : 0 I. 11/6/2014 4:28:55 # rows inserted in table invoice_file : 0 I. 11/6/2014 4:28:55 # rows deleted in table invoice_file : 0 I. 11/6/2014 4:28:55 # rows updated in table invoice_file : 0 I. 11/6/2014 4:28:55 # rows inserted in table card_generator_pos : 0 I. 11/6/2014 4:28:55 # rows deleted in table card_generator_pos : 0 I. 11/6/2014 4:28:55 # rows updated in table card_generator_pos : 0 I. 11/6/2014 4:28:55 # rows inserted in table courts : 0 I. 11/6/2014 4:28:55 # rows deleted in table courts : 0 I. 11/6/2014 4:28:55 # rows updated in table courts : 0 I. 11/6/2014 4:28:55 # rows inserted in table court_prices : 0 I. 11/6/2014 4:28:55 # rows deleted in table court_prices : 0 I. 11/6/2014 4:28:55 # rows updated in table court_prices : 0 I. 11/6/2014 4:28:55 # rows inserted in table card_generator : 0 I. 11/6/2014 4:28:55 # rows deleted in table card_generator : 0 I. 11/6/2014 4:28:55 # rows updated in table card_generator : 0 I. 11/6/2014 4:28:55 # rows inserted in table baby_sit : 0 I. 11/6/2014 4:28:55 # rows deleted in table baby_sit : 0 I. 11/6/2014 4:28:55 # rows updated in table baby_sit : 0 I. 11/6/2014 4:28:55 # rows inserted in table karate : 0 I. 11/6/2014 4:28:55 # rows deleted in table karate : 0 I. 11/6/2014 4:28:55 # rows updated in table karate : 0 I. 11/6/2014 4:28:55 # rows inserted in table time_clock_punches : 11 I. 11/6/2014 4:28:55 # rows deleted in table time_clock_punches : 0 I. 11/6/2014 4:28:55 # rows updated in table time_clock_punches : 1 I. 11/6/2014 4:28:55 # rows inserted in table employee_profile : 0 I. 11/6/2014 4:28:55 # rows deleted in table employee_profile : 0 I. 11/6/2014 4:28:55 # rows updated in table employee_profile : 0 I. 11/6/2014 4:28:55 # rows inserted in table sounds : 0 I. 11/6/2014 4:28:55 # rows deleted in table sounds : 0 I. 11/6/2014 4:28:55 # rows updated in table sounds : 0 I. 11/6/2014 4:28:55 # rows inserted in table tanning : 0 I. 11/6/2014 4:28:55 # rows deleted in table tanning : 0 I. 11/6/2014 4:28:55 # rows updated in table tanning : 0 I. 11/6/2014 4:28:55 # rows inserted in table security : 0 I. 11/6/2014 4:28:55 # rows deleted in table security : 0 I. 11/6/2014 4:28:55 # rows updated in table security : 0 I. 11/6/2014 4:28:55 # rows inserted in table clerk : 0 I. 11/6/2014 4:28:55 # rows deleted in table clerk : 0 I. 11/6/2014 4:28:55 # rows updated in table clerk : 0 I. 11/6/2014 4:28:55 # rows inserted in table trainer_log : 0 I. 11/6/2014 4:28:55 # rows deleted in table trainer_log : 0 I. 11/6/2014 4:28:55 # rows updated in table trainer_log : 0 I. 11/6/2014 4:28:55 # rows inserted in table personal_trainer : 0 I. 11/6/2014 4:28:55 # rows deleted in table personal_trainer : 0 I. 11/6/2014 4:28:55 # rows updated in table personal_trainer : 0 I. 11/6/2014 4:28:55 # rows inserted in table reg_master_tender : 43 I. 11/6/2014 4:28:55 # rows deleted in table reg_master_tender : 0 I. 11/6/2014 4:28:55 # rows updated in table reg_master_tender : 0 I. 11/6/2014 4:28:55 # rows inserted in table reg_master : 43 I. 11/6/2014 4:28:55 # rows deleted in table reg_master : 0 I. 11/6/2014 4:28:55 # rows updated in table reg_master : 0 I. 11/6/2014 4:28:55 # rows inserted in table tender : 0 I. 11/6/2014 4:28:55 # rows deleted in table tender : 0 I. 11/6/2014 4:28:55 # rows updated in table tender : 0 I. 11/6/2014 4:28:55 # rows inserted in table register : 0 I. 11/6/2014 4:28:55 # rows deleted in table register : 0 I. 11/6/2014 4:28:55 # rows updated in table register : 1 I. 11/6/2014 4:28:55 # rows inserted in table inventory : 0 I. 11/6/2014 4:28:55 # rows deleted in table inventory : 0 I. 11/6/2014 4:28:55 # rows updated in table inventory : 14 I. 11/6/2014 4:28:55 # rows inserted in table people : 0 I. 11/6/2014 4:28:55 # rows deleted in table people : 0 I. 11/6/2014 4:28:55 # rows updated in table people : 0 I. 11/6/2014 4:28:55 # rows inserted in table customer : 5 I. 11/6/2014 4:28:55 # rows deleted in table customer : 0 I. 11/6/2014 4:28:55 # rows updated in table customer : 0 I. 11/6/2014 4:28:55 # rows inserted in table checkina : 565 I. 11/6/2014 4:28:55 # rows deleted in table checkina : 0 I. 11/6/2014 4:28:55 # rows updated in table checkina : 0 I. 11/6/2014 4:28:55 # rows inserted in table notes : 7 I. 11/6/2014 4:28:55 # rows deleted in table notes : 0 I. 11/6/2014 4:28:55 # rows updated in table notes : 0 I. 11/6/2014 4:28:56 # rows inserted in table ebcs : 0 I. 11/6/2014 4:28:56 # rows deleted in table ebcs : 0 I. 11/6/2014 4:28:56 # rows updated in table ebcs : 544 I. 11/6/2014 4:28:56 # rows inserted in table password : 0 I. 11/6/2014 4:28:56 # rows deleted in table password : 0 I. 11/6/2014 4:28:56 # rows updated in table password : 0 I. 11/6/2014 4:28:56 # rows inserted in table stgcntrc : 0 I. 11/6/2014 4:28:56 # rows deleted in table stgcntrc : 0 I. 11/6/2014 4:28:56 # rows updated in table stgcntrc : 1 I. 11/6/2014 4:28:56 Waiting for MobiLink to apply upload I. 11/6/2014 4:28:56 The user authentication value is 1000. I. 11/6/2014 4:28:56 Setting last upload time to 2014-11-06 04:28:52. 93 I. 11/6/2014 4:28:56 Setting generation number for subscription 2681_ upload to 1. I. 11/6/2014 4:28:56 COMMIT I. 11/6/2014 4:29:40 Download stream: received 39353994 bytes from Mo biLink server. I. 11/6/2014 4:29:40 Processing download stream ... I. 11/6/2014 4:29:40 Downloading into table: ebcs_special_charges I. 11/6/2014 4:29:40 # rows inserted/updated into table ebcs_special_ charges : 0 I. 11/6/2014 4:29:40 # rows deleted in table ebcs_special_charges : 0 I. 11/6/2014 4:29:40 Downloading into table: ebcs_temp_changes I. 11/6/2014 4:29:40 # rows inserted/updated into table ebcs_temp_cha nges : 0 I. 11/6/2014 4:29:40 # rows deleted in table ebcs_temp_changes : 0 I. 11/6/2014 4:29:40 13 delete operations downloaded for table "ebcs_ temp_changes" were for rows not found in the remote database. I. 11/6/2014 4:29:40 Downloading into table: ebcs_changes I. 11/6/2014 4:29:40 # rows inserted/updated into table ebcs_changes : 0 I. 11/6/2014 4:29:40 # rows deleted in table ebcs_changes : 0 I. 11/6/2014 4:29:40 Downloading into table: class_list I. 11/6/2014 4:29:40 # rows inserted/updated into table class_list : 0 I. 11/6/2014 4:29:40 # rows deleted in table class_list : 0 I. 11/6/2014 4:29:40 Downloading into table: class_exceptions I. 11/6/2014 4:29:40 # rows inserted/updated into table class_excepti ons : 0 I. 11/6/2014 4:29:40 # rows deleted in table class_exceptions : 0 I. 11/6/2014 4:29:40 Downloading into table: xlat_cancel I. 11/6/2014 4:29:40 # rows inserted/updated into table xlat_cancel : 0 I. 11/6/2014 4:29:40 # rows deleted in table xlat_cancel : 0 I. 11/6/2014 4:29:40 Downloading into table: commission I. 11/6/2014 4:29:40 # rows inserted/updated into table commission : 0 I. 11/6/2014 4:29:40 # rows deleted in table commission : 0 I. 11/6/2014 4:29:40 Downloading into table: retail_credit_card I. 11/6/2014 4:29:40 # rows inserted/updated into table retail_credit _card : 0 I. 11/6/2014 4:29:40 # rows deleted in table retail_credit_card : 0 I. 11/6/2014 4:29:40 Downloading into table: scheduler I. 11/6/2014 4:29:40 # rows inserted/updated into table scheduler : 0 I. 11/6/2014 4:29:40 # rows deleted in table scheduler : 0 I. 11/6/2014 4:29:40 Downloading into table: receipt_liability I. 11/6/2014 4:29:40 # rows inserted/updated into table receipt_liabi lity : 0 I. 11/6/2014 4:29:40 # rows deleted in table receipt_liability : 0 I. 11/6/2014 4:29:40 Downloading into table: escrow I. 11/6/2014 4:29:40 # rows inserted/updated into table escrow : 0 I. 11/6/2014 4:29:40 # rows deleted in table escrow : 0 I. 11/6/2014 4:29:40 Downloading into table: visits I. 11/6/2014 4:29:40 # rows inserted/updated into table visits : 0 I. 11/6/2014 4:29:40 # rows deleted in table visits : 0 I. 11/6/2014 4:29:40 Downloading into table: escrow_history I. 11/6/2014 4:29:40 # rows inserted/updated into table escrow_histor y : 0 I. 11/6/2014 4:29:40 # rows deleted in table escrow_history : 0 I. 11/6/2014 4:29:40 Downloading into table: inventory_tracking I. 11/6/2014 4:29:40 # rows inserted/updated into table inventory_tra cking : 0 I. 11/6/2014 4:29:40 # rows deleted in table inventory_tracking : 0 I. 11/6/2014 4:29:40 Downloading into table: EBCS_Version I. 11/6/2014 4:29:40 # rows inserted/updated into table EBCS_Version : 0 I. 11/6/2014 4:29:40 # rows deleted in table EBCS_Version : 0 I. 11/6/2014 4:29:40 Downloading into table: ebcs_contract_versions I. 11/6/2014 4:29:40 # rows inserted/updated into table ebcs_contract _versions : 0 I. 11/6/2014 4:29:40 # rows deleted in table ebcs_contract_versions : 0 I. 11/6/2014 4:29:40 Downloading into table: ebcs_pic I. 11/6/2014 4:29:40 # rows inserted/updated into table ebcs_pic : 0 I. 11/6/2014 4:29:40 # rows deleted in table ebcs_pic : 0 I. 11/6/2014 4:29:40 Downloading into table: aba_info I. 11/6/2014 4:29:40 # rows inserted/updated into table aba_info : 0 I. 11/6/2014 4:29:40 # rows deleted in table aba_info : 0 I. 11/6/2014 4:29:40 Downloading into table: service_xlat I. 11/6/2014 4:29:40 # rows inserted/updated into table service_xlat : 0 I. 11/6/2014 4:29:40 # rows deleted in table service_xlat : 0 I. 11/6/2014 4:29:40 Downloading into table: contract_type I. 11/6/2014 4:29:40 # rows inserted/updated into table contract_type : 0 I. 11/6/2014 4:29:40 # rows deleted in table contract_type : 0 I. 11/6/2014 4:29:40 Downloading into table: cc_transaction I. 11/6/2014 4:29:40 # rows inserted/updated into table cc_transactio n : 0 I. 11/6/2014 4:29:40 # rows deleted in table cc_transaction : 0 I. 11/6/2014 4:29:40 Downloading into table: vendor I. 11/6/2014 4:29:40 # rows inserted/updated into table vendor : 0 I. 11/6/2014 4:29:40 # rows deleted in table vendor : 0 I. 11/6/2014 4:29:40 Downloading into table: last_receipt_num I. 11/6/2014 4:29:40 # rows inserted/updated into table last_receipt_ num : 0 I. 11/6/2014 4:29:40 # rows deleted in table last_receipt_num : 0 I. 11/6/2014 4:29:40 Downloading into table: gift_card_history I. 11/6/2014 4:29:40 # rows inserted/updated into table gift_card_his tory : 0 I. 11/6/2014 4:29:40 # rows deleted in table gift_card_history : 0 I. 11/6/2014 4:29:40 Downloading into table: gift_card I. 11/6/2014 4:29:40 # rows inserted/updated into table gift_card : 0 I. 11/6/2014 4:29:40 # rows deleted in table gift_card : 0 I. 11/6/2014 4:29:40 Downloading into table: reg_master_detail I. 11/6/2014 4:29:40 # rows inserted/updated into table reg_master_de tail : 16 I. 11/6/2014 4:29:40 # rows deleted in table reg_master_detail : 0 I. 11/6/2014 4:29:40 Downloading into table: member_file I. 11/6/2014 4:29:40 # rows inserted/updated into table member_file : 0 I. 11/6/2014 4:29:40 # rows deleted in table member_file : 0 I. 11/6/2014 4:29:40 Downloading into table: pt_form_control I. 11/6/2014 4:29:40 # rows inserted/updated into table pt_form_contr ol : 0 I. 11/6/2014 4:29:40 # rows deleted in table pt_form_control : 0 I. 11/6/2014 4:29:40 Downloading into table: credit_file I. 11/6/2014 4:29:40 # rows inserted/updated into table credit_file : 0 I. 11/6/2014 4:29:40 # rows deleted in table credit_file : 0 I. 11/6/2014 4:29:40 Downloading into table: tennis_codes I. 11/6/2014 4:29:40 # rows inserted/updated into table tennis_codes : 0 I. 11/6/2014 4:29:40 # rows deleted in table tennis_codes : 0 I. 11/6/2014 4:29:40 Downloading into table: tennis_control_file I. 11/6/2014 4:29:40 # rows inserted/updated into table tennis_contro l_file : 0 I. 11/6/2014 4:29:40 # rows deleted in table tennis_control_file : 0 I. 11/6/2014 4:29:40 Downloading into table: history I. 11/6/2014 4:29:40 # rows inserted/updated into table history : 0 I. 11/6/2014 4:29:40 # rows deleted in table history : 0 I. 11/6/2014 4:29:40 Downloading into table: cash_file I. 11/6/2014 4:29:40 # rows inserted/updated into table cash_file : 0 I. 11/6/2014 4:29:40 # rows deleted in table cash_file : 0 I. 11/6/2014 4:29:40 Downloading into table: invoice_file I. 11/6/2014 4:29:40 # rows inserted/updated into table invoice_file : 0 I. 11/6/2014 4:29:40 # rows deleted in table invoice_file : 0 I. 11/6/2014 4:29:40 Downloading into table: card_generator_pos I. 11/6/2014 4:29:40 # rows inserted/updated into table card_generato r_pos : 0 I. 11/6/2014 4:29:40 # rows deleted in table card_generator_pos : 0 I. 11/6/2014 4:29:40 Downloading into table: courts I. 11/6/2014 4:29:40 # rows inserted/updated into table courts : 0 I. 11/6/2014 4:29:40 # rows deleted in table courts : 0 I. 11/6/2014 4:29:40 Downloading into table: court_prices I. 11/6/2014 4:29:40 # rows inserted/updated into table court_prices : 0 I. 11/6/2014 4:29:40 # rows deleted in table court_prices : 0 I. 11/6/2014 4:29:40 Downloading into table: card_generator I. 11/6/2014 4:29:40 # rows inserted/updated into table card_generato r : 0 I. 11/6/2014 4:29:40 # rows deleted in table card_generator : 0 I. 11/6/2014 4:29:40 Downloading into table: baby_sit I. 11/6/2014 4:29:40 # rows inserted/updated into table baby_sit : 0 I. 11/6/2014 4:29:40 # rows deleted in table baby_sit : 0 I. 11/6/2014 4:29:40 Downloading into table: karate I. 11/6/2014 4:29:40 # rows inserted/updated into table karate : 0 I. 11/6/2014 4:29:40 # rows deleted in table karate : 0 I. 11/6/2014 4:29:40 Downloading into table: time_clock_punches I. 11/6/2014 4:29:40 # rows inserted/updated into table time_clock_pu nches : 0 I. 11/6/2014 4:29:40 # rows deleted in table time_clock_punches : 0 I. 11/6/2014 4:29:40 Downloading into table: employee_profile I. 11/6/2014 4:29:40 # rows inserted/updated into table employee_prof ile : 0 I. 11/6/2014 4:29:40 # rows deleted in table employee_profile : 0 I. 11/6/2014 4:29:40 Downloading into table: sounds I. 11/6/2014 4:29:40 # rows inserted/updated into table sounds : 0 I. 11/6/2014 4:29:40 # rows deleted in table sounds : 0 I. 11/6/2014 4:29:40 Downloading into table: tanning I. 11/6/2014 4:29:40 # rows inserted/updated into table tanning : 0 I. 11/6/2014 4:29:40 # rows deleted in table tanning : 0 I. 11/6/2014 4:29:40 Downloading into table: security I. 11/6/2014 4:29:40 # rows inserted/updated into table security : 0 I. 11/6/2014 4:29:40 # rows deleted in table security : 0 I. 11/6/2014 4:29:40 Downloading into table: clerk I. 11/6/2014 4:29:40 # rows inserted/updated into table clerk : 0 I. 11/6/2014 4:29:40 # rows deleted in table clerk : 0 I. 11/6/2014 4:29:40 Downloading into table: trainer_log I. 11/6/2014 4:29:40 # rows inserted/updated into table trainer_log : 0 I. 11/6/2014 4:29:40 # rows deleted in table trainer_log : 0 I. 11/6/2014 4:29:40 Downloading into table: personal_trainer I. 11/6/2014 4:29:40 # rows inserted/updated into table personal_trai ner : 0 I. 11/6/2014 4:29:40 # rows deleted in table personal_trainer : 0 I. 11/6/2014 4:29:40 Downloading into table: reg_master_tender I. 11/6/2014 4:29:40 # rows inserted/updated into table reg_master_te nder : 0 I. 11/6/2014 4:29:40 # rows deleted in table reg_master_tender : 0 I. 11/6/2014 4:29:40 Downloading into table: reg_master I. 11/6/2014 4:29:40 # rows inserted/updated into table reg_master : 0 I. 11/6/2014 4:29:40 # rows deleted in table reg_master : 0 I. 11/6/2014 4:29:40 Downloading into table: tender I. 11/6/2014 4:29:40 # rows inserted/updated into table tender : 0 I. 11/6/2014 4:29:40 # rows deleted in table tender : 0 I. 11/6/2014 4:29:40 Downloading into table: register I. 11/6/2014 4:29:40 # rows inserted/updated into table register : 0 I. 11/6/2014 4:29:40 # rows deleted in table register : 0 I. 11/6/2014 4:29:40 Downloading into table: inventory I. 11/6/2014 4:29:40 # rows inserted/updated into table inventory : 0 I. 11/6/2014 4:29:40 # rows deleted in table inventory : 0 I. 11/6/2014 4:29:40 Downloading into table: people I. 11/6/2014 4:29:40 # rows inserted/updated into table people : 0 I. 11/6/2014 4:29:40 # rows deleted in table people : 0 I. 11/6/2014 4:29:40 Downloading into table: customer I. 11/6/2014 4:29:40 # rows inserted/updated into table customer : 0 I. 11/6/2014 4:29:40 # rows deleted in table customer : 0 I. 11/6/2014 4:29:40 Downloading into table: checkina I. 11/6/2014 4:29:40 # rows inserted/updated into table checkina : 0 I. 11/6/2014 4:29:40 # rows deleted in table checkina : 0 I. 11/6/2014 4:29:40 Downloading into table: notes I. 11/6/2014 4:29:40 # rows inserted/updated into table notes : 0 I. 11/6/2014 4:29:40 # rows deleted in table notes : 0 I. 11/6/2014 4:29:40 Downloading into table: ebcs I. 11/6/2014 4:30:02 # rows inserted/updated into table ebcs : 80149 I. 11/6/2014 4:30:02 # rows deleted in table ebcs : 0 I. 11/6/2014 4:30:02 Downloading into table: password I. 11/6/2014 4:30:02 # rows inserted/updated into table password : 0 I. 11/6/2014 4:30:02 # rows deleted in table password : 0 I. 11/6/2014 4:30:02 Downloading into table: stgcntrc I. 11/6/2014 4:30:02 # rows inserted/updated into table stgcntrc : 0 I. 11/6/2014 4:30:02 # rows deleted in table stgcntrc : 0 I. 11/6/2014 4:30:02 COMMIT I. 11/6/2014 4:30:02 Completed processing of download stream I. 11/6/2014 4:30:02 End synchronizing subscription(s) '2681_upload' I. 11/6/2014 4:30:02 Disconnecting from MobiLink server I. 11/6/2014 4:30:03 Complete log scan required. I. 11/6/2014 4:30:03 Synchronization completed I. 11/6/2014 4:30:03 Disconnecting from remote database