A^z) X @δ======Y H DBAZ DBA create domain /*==============================================================*/ d_1_0_code char(1) /* Domain: d_1_0_code */ /*==============================================================*/ check(@column is null or(@column in( '1','0') ))DBA%create domain /*==============================================================*/ d_bact_c_s_code char(1) /* Domain: d_bact_c_s_code */ /*==============================================================*/ check(@column is null or(@column in( 'C','S') ))DBA)create domain /*==============================================================*/ d_cadr_rent_own char(1) /* Domain: d_cadr_rent_own */ /*==============================================================*/ check(@column is null or(@column in( 'R','O','H') ))DBA,create domain /*==============================================================*/ d_clcmt_act_code char(4) /* Domain: d_clcmt_act_code */ /*==============================================================*/ check(@column is null or(@column in( 'LMTC','????') ))DBAcreate domain /*==============================================================*/ d_comment long varchar /* Domain: d_comment */ /*==============================================================*/ DBA$create domain /*==============================================================*/ d_dlr_rent_own char(1) /* Domain: d_dlr_rent_own */ /*==============================================================*/ check(@column is null or(@column in( 'O','R') ))DBA3create domain /*==============================================================*/ d_dlr_status_code char(1) /* Domain: d_dlr_status_code */ /*=============G','III===========================================*/ check(@column is null or(@column in( 'A','I','H','P','D') ))DBA#create domain /*==============================================================*/ d_gender_code char(1) /* Domain: d_gender_code */ /*==============================================================*/ check(@column is null or(@column in( 'M','F') ))DBA*create domain /*==============================================================*/ d_lcmt_comt_code char(1) /* Domain: d_lcmt_comt_code */ /*==============================================================*/ check(@column is null or(@column in( 'D','Q','N') ))DBA*create domain /*==============================================================*/ d_loan_or_quote_code char(1) /* Domain: d_loan_or_quote_code */ /*==============================================================*/ check(@column is null or(@column in( 'Q','L') ))DBA3create domain /*==============================================================*/ d_marital_st_code char(1) /* Domain: d_marital_st_code */ /*==============================================================*/ check(@column is null or(@column in( 'M','S','D','P','W') ))DBAMcreate domain /*==============================================================*/ d_nada_region_code char(2) /* Domain: d_nada_region_code */ /*==============================================================*/ check(@column is null or(@column in( 'NE','EA','MW','CE','PN','SW','SE','PS','MS') ))DBA<create domain /*==============================================================*/ d_name_suffix_code char(1) /* Domain: d_name_suffix_code */ /*==============================================================*/ check(@column is null or(@column in( 'J','SGde ','IV','') ))DBAcreate domain /*==============================================================*/ d_phone char(10) /* Domain: d_phone */ /*==============================================================*/ DBAcreate domain /*==============================================================*/ d_phone_ext char(4) /* Domain: d_phone_ext */ /*==============================================================*/ DBA.create domain /*==============================================================*/ d_rper_func_code char(1) /* Domain: d_rper_func_code */ /*==============================================================*/ check(@column is null or(@column in( 'V','U','D','I') ))DBAcreate domain /*==============================================================*/ d_ssn char(9) /* Domain: d_ssn */ /*==============================================================*/ DBA+create domain /*==============================================================*/ d_st_code char(1) /* Domain: d_st_code */ /*==============================================================*/ check(@column is null or(@column in( 'S','B','A','W','L') ))DBAcreate domain /*==============================================================*/ d_state char(2) /* Domain: d_state */ /*==============================================================*/ DBAcreate domain /*==============================================================*/ d_updated_by integer /* Domain: d_updated_by */ /*==============================================================*/ DBA create domain /*==============================================================*/ d_y_n_code char(1) /* Domain: d_y_n_coGll,  */ /*==============================================================*/ check(@column is null or(@column in( 'Y','N') ))DBAcreate domain /*==============================================================*/ d_zip char(9) /* Domain: d_zip */ /*==============================================================*/ DBANcreate table /*==============================================================*/ /* Table: bank_account */ /*==============================================================*/ DBA.bank_account( bact_id integer not null default autoincrement, loan_id integer not null, bnk_id integer null, bact_chk_sav_code char(1) null, bact_ach_ind char(1) null, bact_account_number char(30) null, bact_updated_by integer null, bact_updated_date date null, bact_bank_routing_code numeric(9) null, bact_bank_name char(60) null, bact_bank_branch_name char(60) null, bact_bank_contact_name char(60) null, bact_bank_phone char(10) null, bact_bank_fax char(10) null, bact_bank_email char(30) null, bact_confirmed_code char(1) null, constraint PK_BANK_ACCOUNT primary key( bact_id) , )DBA create index COLLECTS_FROM_FK on /*==============================================================*/ /* Index: COLLECTS_FROM_FK */ /*==============================================================*/ bank_account(loan_id asc)DBAcreate table /*==============================================================*/ /* Table: clcmt_comment */ /*==============================================================*/ DBA.clcmt_comment( clcmt_id integer not null default autoincrement, loan_id integer not null, clcmt_comment long varchar null, clcmt_action_code char(4) null, clcmt_follow_up_date date null, clcmt_resolved_y_n_code char(1) nuG crclcmt_created_by integer null, clcmt_created_date date null, clcmt_updated_by integer null, clcmt_updated_date date null, constraint PK_CLCMT_COMMENT primary key( clcmt_id) , )DBA create index HAS_COLLECTION_FK on /*==============================================================*/ /* Index: HAS_COLLECTION_FK */ /*==============================================================*/ clcmt_comment(loan_id asc)DBAcreate table /*==============================================================*/ /* Table: cust_address */ /*==============================================================*/ DBA.cust_address( cadr_id integer not null default autoincrement, cust_id integer not null, cadr_movin_in_date date null, cadr_time_at_res_mo numeric(2) null, cadr_time_at_res_yr numeric(2) null, cadr_street char(30) null, cadr_st_code char(1) null, cadr_apt_po char(30) null, cadr_city char(20) null, cadr_state char(2) null, cadr_zip char(9) null, cadr_home_phone char(10) null, cadr_cell_phone char(10) null, cadr_fax_phone char(10) null, cadr_work_phone char(10) null, cadr_email_address char(30) null, cadr_work_ext char(4) null, cadr_other_phone char(10) null, cadr_other_phone_desc char(30) null, cadr_rent_own_code char(1) null, cadr_confirmed_code char(1) null, cadr_updated_by integer null, cadr_updated_date date null, mrtg_id integer null, cadr_apt char(6) null, cadr_po char(6) null, cadr_mrtg_name char(60) null, cadr_mrtg_street char(30) null, cadr_mrtg_st_code char(1) null, cadr_mrtg_apt char(6) null, cadr_mrtg_po char(6) null, cadr_mrtg_city char(20) null, cadr_mrtg_state char(2) null, cadr_mrtg_zip char(9) null, cadr_mrtg_phone char(10) null, cadr_mrtg_fax char(10) null, cadr_mrtg_email char(60) null, cadr_mrtg_monthly_pymt_amt decimal(7,2) null, constraint PK_CUST_ADDRESS primary key( cadr_id) , )DBAGUST_EMeate index HAS_HISTORICAL_FK on /*==============================================================*/ /* Index: HAS_HISTORICAL_FK */ /*==============================================================*/ cust_address(cust_id asc)DBAcreate table /*==============================================================*/ /* Table: cust_comment */ /*==============================================================*/ DBA.cust_comment( ccmt_id integer not null default autoincrement, cust_id integer not null, ccmt_comment long varchar null, ccmt_updated_by integer null, ccmt_updated_date date null, constraint PK_CUST_COMMENT primary key( ccmt_id) , )DBAcreate index HAS_COMMENTS_FK on /*==============================================================*/ /* Index: HAS_COMMENTS_FK */ /*==============================================================*/ cust_comment(cust_id asc)DBAcreate table /*==============================================================*/ /* Table: cust_employer */ /*==============================================================*/ DBA.cust_employer( cemp_id integer not null default autoincrement, cust_id integer not null, cemp_job_position char(30) null, cemp_name char(60) null, cemp_salary decimal(7,2) null, cadr_time_at_job_mo numeric(2) null, cadr_time_at_job_yr numeric(2) null, cemp_other_income decimal(7,2) null, cemp_email char(30) null, cemp_street char(30) null, cemp_st_code char(1) null, cemp_apt_po char(30) null, cemp_city char(20) null, cemp_state char(2) null, cemp_zip char(9) null, cemp_phone char(10) null, cemp_phone_ext char(4) null, cemp_fax char(10) null, cemp_confirmed_code char(1) null, cemp_updated_by integer null, cemp_updated_date date null, cemp_po char(6) null, cemp_apt char(6) null, constraint PK_CGr(1) nPLOYER primary key( cemp_id) , )DBA create index IS_EMPLOYED_BY_FK on /*==============================================================*/ /* Index: IS_EMPLOYED_BY_FK */ /*==============================================================*/ cust_employer(cust_id asc)DBAcreate table /*==============================================================*/ /* Table: cust_reference */ /*==============================================================*/ DBA.cust_reference( cref_id integer not null default autoincrement, cust_id integer not null, cref_first_name char(30) null, cref_mid_initial char(1) null, cref_last_name char(30) null, cref_suffix_code char(1) null, cref_email char(30) null, cref_street char(30) null, cref_st_code char(1) null, cref_apt_po char(30) null, cref_city char(20) null, cref_state char(2) null, cref_zip char(9) null, cref_phone char(10) null, cref_phone_ext char(4) null, cref_fax char(10) null, cref_confirmed_code char(1) null, cref_updated_by integer null, cref_updated_date date null, cref_po char(6) null, cref_apt char(6) null, constraint PK_CUST_REFERENCE primary key( cref_id) , )DBAcreate index PROVIDES_FK on /*==============================================================*/ /* Index: PROVIDES_FK */ /*==============================================================*/ cust_reference(cust_id asc)DBAcreate table /*==============================================================*/ /* Table: customer */ /*==============================================================*/ DBA.customer( cust_id integer not null default autoincrement, cust_first_name char(30) null, cust_mid_initial char(1) null, cust_last_name char(30) null, cust_suffix_code char(1) null, cust_ssn char(9) null, cust_gender chaGreate ull, cust_marital_status char(1) null, cust_dob date null, cust_previous_repo_code char(1) null, cust_num_dependents numeric(2) null, cust_updated_by integer null, cust_updated_date date null, cadr_id integer null, cemp_id integer null, constraint PK_CUSTOMER primary key( cust_id) , )DBAucreate table /*==============================================================*/ /* Table: dealer */ /*==============================================================*/ DBA.dealer( dlr_id integer not null default autoincrement, empl_id integer not null, stat_id integer not null, dlr_dba_name char(60) null, dlr_legal_name char(60) null, dlr_status_code char(1) null, dlr_rent_own_code char(1) null, dlr_credit_score numeric(3) null, dlr_withold_amt decimal(7,2) null, dlr_withold_always_code char(1) null, dlr_street char(30) null, dlr_st_code char(1) null, dlr_apt_po char(30) null, dlr_city char(20) null, dlr_state char(2) null, dlr_zip char(9) null, dlr_phone char(10) null, dlr_fax char(10) null, dlr_updated_by integer null, dlr_updated_date date null, dlr_real_estate_value_amt decimal(10,2) null, dlr_apt char(6) null, dlr_po char(6) null, dlr_number_by_state integer null, dlr_too_many_repos_ind char(1) null, dlr_stat_number decimal(2) null, dlr_repo_count decimal(3) null, constraint PK_DEALER primary key( dlr_id) , )DBAcreate index HAS_A_REP_FK on /*==============================================================*/ /* Index: HAS_A_REP_FK */ /*==============================================================*/ dealer(empl_id asc)DBAcreate index RESIDES_IN_FK on /*==============================================================*/ /* Index: RESIDES_IN_FK */ /*==============================================================*/ dealer(stat_id asc)DBAcGult table /*==============================================================*/ /* Table: dlr_comment */ /*==============================================================*/ DBA.dlr_comment( dcmt_id integer not null default autoincrement, dlr_id integer not null, dcmt_comment long varchar null, dcmt_updated_by integer null, dcmt_updated_date date null, constraint PK_DLR_COMMENT primary key( dcmt_id) , )DBAcreate index HAS_COMMENT_FK on /*==============================================================*/ /* Index: HAS_COMMENT_FK */ /*==============================================================*/ dlr_comment(dlr_id asc)DBAcreate table /*==============================================================*/ /* Table: dlr_employee */ /*==============================================================*/ DBA.dlr_employee( demp_id integer not null default autoincrement, dlr_id integer not null, demp_first_name char(30) null, demp_last_name char(30) null, demp_title char(30) null, demp_email char(60) null, demp_auth_signer__code char(1) null, demp_cell char(10) null, demp_phone_ext char(4) null, demp_updated_by integer null, demp_updated_date date null, demp_owner_code char(1) null, demp_dob date null, constraint PK_DLR_EMPLOYEE primary key( demp_id) , )DBAcreate index EMPLOYS_FK on /*==============================================================*/ /* Index: EMPLOYS_FK */ /*==============================================================*/ dlr_employee(dlr_id asc)DBAUcreate table /*==============================================================*/ /* Table: doc_checklist */ /*==============================================================*/ DBA.doc_checklist( dchk_id integer not null defa Goles(rautoincrement, dchk_approval_wrksht_code char(1) null, dchk_registration_code char(1) null, dchk_rmv_code char(1) null, dchk_orig_contract_code char(1) null, dchk_recourse_sig_code char(1) null, dchk_ach_signed_code char(1) null, dchk_1st_payment_code char(1) null, dchk_ext_warranty_code char(1) null, dchk_orig_credit_appl_code char(1) null, dchk_ins_binder_code char(1) null, dchk_p_s_agreement_code char(1) null, dchk_30_60_90_code char(1) null, dchk_signed_quest_code char(1) null, dchk_signed_co_borrow_code char(1) null, dchk_title_code char(1) null, dchk_dlr_reg_fee_form_code char(1) null, dchk_keys_code char(1) null, dchk_drivers_license_code char(1) null, dchk_references_code char(1) null, dchk_pay_stubs_code char(1) null, dchk_utility_bill_code char(1) null, dchk_int_license_code char(1) null, dchk_privacy_act_code char(1) null, dchk_updated_by integer null, dchk_updated_date date null, dchk_override_ind char(1) null, dchk_partial_purchase_code char(1) null, constraint PK_DOC_CHECKLIST primary key( dchk_id) , )DBAmcreate table /*==============================================================*/ /* Table: empl_has_roles */ /*==============================================================*/ DBA.empl_has_roles( empl_id integer not null, role_id integer not null, constraint PK_EMPL_HAS_ROLES primary key( empl_id, role_id) , )DBA create index EMPL_HAS_ROLES_FK on /*==============================================================*/ /* Index: EMPL_HAS_ROLES_FK */ /*==============================================================*/ empl_has_roles(empl_id asc)DBA create index EMPL_HAS_ROLES_FK2 on /*==============================================================*/ /* Index: EMPL_HAS_ROLES_FK2 */ /*==============================================================*/ empl_has_r GAS_POLole_id asc)DBAcreate table /*==============================================================*/ /* Table: employee */ /*==============================================================*/ DBA.employee( empl_id integer not null default autoincrement, empl_first_name char(30) null, empl_mid_initial char(1) null, empl_last_name char(30) null, empl_home_phone char(10) null, empl_work_phone_ext char(4) null, empl_cell char(10) null, empl_fax char(10) null, empl_email char(30) null, empl_bkgrnd_color integer null, empl_nada_region char(2) null, empl_logon_id char(20) null, empl_password char(10) null, empl_updated_by integer null, empl_updated_date date null, empl_bg_color decimal(9) null, empl_dept_code numeric(2) null, empl_max_nada_to_dlr_adv_pct decimal(4,4) null, empl_dob date null, empl_dot date null, empl_doh date null, constraint PK_EMPLOYEE primary key( empl_id) , )DBA|create table /*==============================================================*/ /* Table: ins_policy */ /*==============================================================*/ DBA.ins_policy( inp_id integer not null default autoincrement, loan_id integer not null, ins_id integer null, inp_effective_date date null, inp_expiration_date date null, inp_cancelled_date date null, inp_verified_date date null, inp_policy_number char(30) null, inp_comp_deduct_amt numeric(5) null, inp_collision_deduct_amt numeric(5) null, inp_insured_name char(30) null, inp_updated_by integer null, inp_updated_date date null, inp_ins_name char(60) null, inp_ins_agent_name char(60) null, inp_ins_phone char(10) null, inp_ins_fax char(10) null, inp_defaulted_ind char(1) null, constraint PK_INS_POLICY primary key( inp_id) , )DBAcreate index HAS_POLICY_FK on /*==============================================================*/ /* Index: H G decimICY_FK */ /*==============================================================*/ ins_policy(loan_id asc)DBAcreate table /*==============================================================*/ /* Table: loan */ /*==============================================================*/ DBA.loan( loan_id integer not null default autoincrement, inp_id integer null, dchk_id integer null, wrty_id integer null, bact_id integer null, dlr_id integer not null, empl_id integer not null, loan_status_code numeric(1) null, loan_type_code numeric(1) null, loan_vin char(16) null, loan_delivery_date date null, loan_first_pymt_date date null, loan_cash_price_amt decimal(7,2) null, loan_cash_down_amt decimal(7,2) null, loan_trade_in_amt decimal(7,2) null, loan_trade_in_lien_amt decimal(7,2) null, loan_trade_in_net_amt decimal(7,2) null, loan_state_sales_tax_amt decimal(7,2) null, loan_warranty_retail_amt decimal(7,2) null, loan_conv_fee_amt decimal(7,2) null, loan_title_fees_amt decimal(7,2) null, loan_gap_retail_amt decimal(7,2) null, loan_other_fee_amt decimal(7,2) null, loan_other_fee_amt_desc char(30) null, loan_contract_financed_amt decimal(7,2) null, loan_cust_weekly_pymt_amt decimal(7,2) null, loan_cust_weeks_to_payoff integer null, loan_partial_purchase_amt decimal(7,2) null, loan_pymts_purchased numeric(3) null, loan_acq_fee_amt decimal(7,2) null, loan_partial_purchase_net_amt decimal(7,2) null, loan_vsi_premium_amt decimal(2) null, loan_wrty_cost_amt decimal(7,2) null, loan_wrty_cost_withhold_amt decimal(7,2) null, loan_gap_cost_amt decimal(7,2) null, loan_dlr_advance decimal(7,2) null, loan_stat_code char(2) null, loan_stat_tax_rate decimal(2,2) null, loan_vehicle_mileage integer null, loan_nada_batch_date date null, loan_nada_loan_amt decimal(7,2) null, loan_nada_trade_in_amt decimal(7,2) null, loan_nada_retail_amt Geate ial(7,2) null, loan_vehicle_color char(20) null, loan_nada_vehicle_year integer null, loan_nada_vehicle_make char(30) null, loan_nada_vechicle_model char(30) null, loan_payout_other_fee_amt decimal(7,2) null, loan_payout_dlr_rsrv_adj_amt decimal(7,2) null, loan_payout_discount_adj_amt decimal(7,2) null, loan_payout_interest_amt decimal(7,2) null, loan_payout_fee_adj decimal(7,2) null, loan_ext_num_granted numeric(2) null, loan_ext_granted_by integer null, loan_ext_last_granted_date date null, loan_in_house_reg_code char(1) null, loan_in_house_title_code char(1) null, loan_first1_lein_holder_code char(1) null, loan_updated_by integer null, loan_updated_date date null, loan_created_date date null, loan_cust_name char(60) null, loan_term integer null, loan_apr decimal(4,4) null, loan_dlr_pymt_weeks integer null, loan_dlr_pymt_amt decimal(7,2) null, loan_not_funded_code char(10) null, loan_tot_interest_owed_amt decimal(7,2) null, loan_balance_current_amt decimal(7,2) null, loan_date_maturity date null, loan_stat_number decimal(2) null, cust_id integer null, loan_override_apr_ind char(1) null, loan_override_term_ind char(1) null, loan_override_contract_financed_amt_ind char(1) null, loan_override_cust_weekly_pymt_ind char(1) null, loan_override_acq_fee_amt_ind char(1) null, loan_override_nada_loan_to_advance_pct_ind char(1) null, loan_override_override_by integer null, loan_override_override_date date null, loan_override_override_required_ind char(1) null, cust_co_id integer null, nada_id integer null, loan_quote_or_loan_code char(1) null, loan_last_weekly_pymt_amt decimal(7,2) null, constraint PK_LOAN primary key( loan_id) , )DBAcreate index IS_ISSUED_BY_FK on /*==============================================================*/ /* Index: IS_ISSUED_BY_FK */ /*==============================================================*/ loan(dlr_id asc)DBAcr G ndex HAS_POLICY_FK on /*==============================================================*/ /* Index: HAS_POLICY_FK */ /*==============================================================*/ loan(inp_id asc)DBAcreate index COLLECTS_FROM_FK on /*==============================================================*/ /* Index: COLLECTS_FROM_FK */ /*==============================================================*/ loan(bact_id asc)DBAcreate index HAS_WARRANTY_FK on /*==============================================================*/ /* Index: HAS_WARRANTY_FK */ /*==============================================================*/ loan(wrty_id asc)DBAcreate index IS_APPROVED_BY_FK on /*==============================================================*/ /* Index: IS_APPROVED_BY_FK */ /*==============================================================*/ loan(empl_id asc)DBAcreate index HAS_DOCS_LIST_FK on /*==============================================================*/ /* Index: HAS_DOCS_LIST_FK */ /*==============================================================*/ loan(dchk_id asc)DBAcreate table /*==============================================================*/ /* Table: loan_comment */ /*==============================================================*/ DBA.loan_comment( lcmt_id integer not null default autoincrement, loan_id integer not null, lcmt_comment_code char(1) null, lcmt_comment long varchar null, lcmt_updated_by integer null, lcmt_updated_date date null, constraint PK_LOAN_COMMENT primary key( lcmt_id) , )DBAcreate index HAS_COMMENTS_FK on /*==============================================================*/ /* Index: HAS_COMMENTS_FK G*/ D */ /*==============================================================*/ loan_comment(loan_id asc)DBAcreate table /*==============================================================*/ /* Table: payments */ /*==============================================================*/ DBA.payments( pymt_id integer not null default autoincrement, loan_id integer not null, pymt_number numeric(3) null, pymt_posted_date date null, pymt_effective_date date null, pymt_ach_trans_status char(12) null, pymt_ach_trans_id char(20) null, pymt_amt decimal(7,2) null, pymt_nsf_fee decimal(7,2) null, pymt_reversal_date date null, pymt_reversed_pymt_number numeric(3) null, pymt_check_number integer null, pymt_desc char(30) null, pymt_posted_by integer null, pymt_updated_by integer null, pymt_updated_date date null, pymt_late_fee_amt decimal(7,2) null, pymt_late_fee_pymt_no integer null, constraint PK_PAYMENTS primary key( pymt_id) , )DBAcreate index HAS_PAYMENTS_FK on /*==============================================================*/ /* Index: HAS_PAYMENTS_FK */ /*==============================================================*/ payments(loan_id asc)DBAcreate table /*==============================================================*/ /* Table: role */ /*==============================================================*/ DBA.role( role_id integer not null default autoincrement, role_name char(20) null, role_description char(60) not null, role_updated_by integer not null, role_updated_date date not null, constraint PK_ROLE primary key( role_id) , )DBAcreate table /*==============================================================*/ /* Table: schd_of_pymts */ /*==============================================================Gtat_maBA.schd_of_pymts( schd_id integer not null default autoincrement, loan_id integer not null, schd_pymt_number numeric(3) null, schd_pymt_date date null, schd_pymt_amt decimal(7,2) null, schd_principal_amt decimal(7,2) null, schd_interest_amt decimal(7,2) null, schd_paid_amt decimal(7,2) null, schd_schd_balance_amt decimal(7,2) null, schd_actual_balance_amt decimal(7,2) null, schd_acq_fee_amt decimal(7,2) null, schd_late_fee_amt decimal(7,2) null, schd_late_fee_pymt_number numeric(3) null, schd_updated_by integer null, schd_updated_date date null, schd_paid_date date null, schd_late_fee_tot_amt decimal(7,2) null, schd_acq_fee_tot_amt decimal(7,2) null, constraint PK_SCHD_OF_PYMTS primary key( schd_id) , )DBA create index HAS_AMORT_SCHD_FK on /*==============================================================*/ /* Index: HAS_AMORT_SCHD_FK */ /*==============================================================*/ schd_of_pymts(loan_id asc)DBAcreate table /*==============================================================*/ /* Table: state */ /*==============================================================*/ DBA.state( stat_id integer not null default autoincrement, stat_abbr char(2) null, stat_number decimal(2) null, stat_name char(30) null, stat_nada_region char(2) null, stat_nsf_check_fee decimal(2) null, stat_nsf_check_fee_pct decimal(4,4) null, stat_tax_rate decimal(4,4) null, stat_late_fee_pct decimal(4,4) null, stat_vsi_premium decimal(3) null, stat_max_gap_retail decimal(3) null, stat_gap_cost decimal(3) null, stat_max_doc_fee decimal(3) null, stat_pct_not_paid_b4_overdue decimal(4,4) null, stat_updated_by integer null, stat_updated_date date null, stat_late_fee_amt decimal(4,2) null, stat_late_fee_days decimal(2) null, stat_max_financed_amt decimal(7,2) null, stat_max_term decimal(3) null, sG======x_weekly_pymt_amt decimal(7,2) null, stat_max_acq_fee_amt decimal(7,2) null, stat_min_acq_fee_amt decimal(7,2) null, stat_min_acq_fee_week_count decimal(3) null, stat_min_weekly_pymt decimal(7,2) null, stat_min_dlr_pymt_amt decimal(7,2) null, constraint PK_STATE primary key( stat_id) , )DBAcreate table /*==============================================================*/ /* Table: state_acq_fees */ /*==============================================================*/ DBA.state_acq_fees( staf_id integer not null default autoincrement, stat_id integer not null, staf_start_week integer null, staf_end_week integer null, staf_updated_by integer null, staf_updated_date date null, staf_acq_fee_pct decimal(4,4) null, constraint PK_STATE_ACQ_FEES primary key( staf_id) , )DBA create index AN_ACQ_FEES_FK on /*==============================================================*/ /* Index: AN_ACQ_FEES_FK */ /*==============================================================*/ state_acq_fees(stat_id asc)DBA%create table /*==============================================================*/ /* Table: state_int_rates */ /*==============================================================*/ DBA.state_int_rates( sint_id integer not null default autoincrement, stat_id integer not null, sint_start_year decimal(4) null, sint_end_year decimal(4) null, sint_default_apr decimal(4,4) null, sint_updated_by integer null, sint_updated_date date null, constraint PK_STATE_INT_RATES primary key( sint_id) , )DBAcreate index HAS_RATES_FK on /*==============================================================*/ /* Index: HAS_RATES_FK */ /*==============================================================*/ state_int_rates(stat_id asc)DBAcreate table /*======G========================================================*/ /* Table: sys_info */ /*==============================================================*/ DBA.sys_info( sys_id integer not null default autoincrement, sys_name char(30) null, sys_street_1 char(30) null, sys_street_2 char(30) null, sys_city char(20) null, sys_state char(2) null, sys_zip char(9) null, sys_phone char(10) null, sys_fax char(10) null, sys_toll_free_phone char(10) null, sys_nada_userid char(12) null, sys_nada__password char(12) null, sys_ach_userid char(12) null, sys_ach_password char(12) null, sys_email char(30) null, sys_days_alwd_before_1st_pymt numeric(2) null, sys_dealer_comment long varchar null, sys_updated_by integer null, sys_updated_date date null, constraint PK_SYS_INFO primary key( sys_id) , )DBAcreate table /*==============================================================*/ /* Table: ticket */ /*==============================================================*/ DBA.ticket( tkt_open_date date null, tkt_open_desc long varchar null, tkt_status_code char(1) null, tkt_comment long varchar null, tkt_priority char(1) null, empl_id integer null, tkt_closed_date date null, tkt_resolution_desc long varchar null, tkt_id integer not null default autoincrement, tkt_updated_by integer null, tkt_update_date date null, tkm_id integer null, tkt_report_type char(1) null, tkt_fixed_in_version char(8) null, constraint PK_TICKET primary key( tkt_id) , )DBAZcreate table /*==============================================================*/ /* Table: tkt_module */ /*==============================================================*/ DBA.tkt_module( tkm_id integer null default autoincrement, tkm_module_name char(45) null, tkm_desc char(120) null, )DBAYcreate table /*=======Gter ta=================================================*/ /* Table: warranty_co */ /*==============================================================*/ DBA.warranty_co( wrty_id integer not null default autoincrement, wrty_company_name char(60) null, wrty_warranty_name char(60) null, wrty_street char(30) null, wrty_st_code char(1) null, wrty_apt_po char(30) null, wrty_city char(20) null, wrty_state char(2) null, wrty_zip char(9) null, wrty_phone char(10) null, wrty_fax char(10) null, wrty_email char(30) null, wrty_default_wrty_cost_amt decimal(7,2) null, wrty_dlr_check_amt decimal(7,2) null, wrty_cut_check_to_dlr_code char(1) null, wrty_updated_by integer null, wrty_updated_date date null, constraint PK_WARRANTY_CO primary key( wrty_id) , )H DBAZ L Z =o DBADBAalter table bank_account add FK_BANK_ACC_COLLECTS__LOAN foreign key(loan_id) references loan(loan_id) on update restrict on delete restrictZ Mo DBADBAalter table clcmt_comment add FK_CLCMT_CO_HAS_COLLE_LOAN foreign key(loan_id) references loan(loan_id) on update restrict on delete restrictZ o DBADBAalter table cust_address add FK_CUST_ADD_HAS_HISTO_CUSTOMER foreign key(cust_id) references customer(cust_id) on update restrict on delete restrictZ }o DBADBAalter table cust_comment add FK_CUST_COM_HAS_COMME_CUSTOMER foreign key(cust_id) references customer(cust_id) on update restrict on delete restrictZ }<o DBADBAalter table cust_employer add FK_CUST_EMP_IS_EMPLOY_CUSTOMER foreign key(cust_id) references customer(cust_id) on update restrict on delete restrictZ <o DBADBAalter table cust_reference add FK_CUST_REF_PROVIDES_CUSTOMER foreign key(cust_id) references customer(cust_id) on update restrict on delete restrictZ o DBADBAalG add ble dealer add FK_DEALER_HAS_A_REP_EMPLOYEE foreign key(empl_id) references employee(empl_id) on update restrict on delete restrictZ o DBADBAalter table dealer add FK_DEALER_RESIDES_I_STATE foreign key(stat_id) references state(stat_id) on update restrict on delete restrictZ 8o DBADBAalter table dlr_comment add FK_DLR_COMM_HAS_COMME_DEALER foreign key(dlr_id) references dealer(dlr_id) on update restrict on delete restrictZ 8o DBADBAalter table dlr_employee add FK_DLR_EMPL_EMPLOYS_DEALER foreign key(dlr_id) references dealer(dlr_id) on update restrict on delete restrictZ o DBADBAalter table empl_has_roles add FK_EMPL_HAS_EMPL_HAS__EMPLOYEE foreign key(empl_id) references employee(empl_id) on update restrict on delete restrictZ ho DBADBAalter table empl_has_roles add FK_EMPL_HAS_EMPL_HAS__ROLE foreign key(role_id) references role(role_id) on update restrict on delete restrictZ h!o DBADBAalter table ins_policy add FK_INS_POLI_HAS_POLIC_LOAN foreign key(loan_id) references loan(loan_id) on update restrict on delete restrictZ !֬o DBADBAalter table loan add FK_LOAN_COLLECTS__BANK_ACC foreign key(bact_id) references bank_account(bact_id) on update restrict on delete restrictZ ֬o DBADBAalter table loan add FK_LOAN_HAS_DOCS__DOC_CHEC foreign key(dchk_id) references doc_checklist(dchk_id) on update restrict on delete restrictZ Eo DBADBAalter table loan add FK_LOAN_HAS_POLIC_INS_POLI foreign key(inp_id) references ins_policy(inp_id) on update restrict on delete restrictZ Eo DBADBAalter table loan add FK_LOAN_HAS_WARRA_WARRANTY foreign key(wrty_id) references warranty_co(wrty_id) on update restrict on delete restrictZ o DBADBAalter table loanG add  FK_LOAN_IS_APPROV_EMPLOYEE foreign key(empl_id) references employee(empl_id) on update restrict on delete restrictZ uo DBADBAalter table loan add FK_LOAN_IS_ISSUED_DEALER foreign key(dlr_id) references dealer(dlr_id) on update restrict on delete restrictZ u"o DBADBAalter table loan_comment add FK_LOAN_COM_HAS_COMME_LOAN foreign key(loan_id) references loan(loan_id) on update restrict on delete restrictZ "ٱo DBADBAalter table payments add FK_PAYMENTS_HAS_PAYME_LOAN foreign key(loan_id) references loan(loan_id) on update restrict on delete restrictZ ٱo DBADBAalter table schd_of_pymts add FK_SCHD_OF__HAS_AMORT_LOAN foreign key(loan_id) references loan(loan_id) on update restrict on delete restrictZ Do DBADBAalter table state_acq_fees add FK_STATE_AC_AN_ACQ_FE_STATE foreign key(stat_id) references state(stat_id) on update restrict on delete restrictZ Do DBADBAalter table state_int_rates add FK_STATE_IN_HAS_RATES_STATE foreign key(stat_id) references state(stat_id) on update restrict on delete restrictI Z o DBAZ Z δ֬o DBADBAalter table loan add FK_LOAN_COLLECTS__BANK_ACC foreign key(bact_id) references bank_account(bact_id) on update restrict on delete restrictZ ֬o DBADBAalter table loan add FK_LOAN_HAS_DOCS__DOC_CHEC foreign key(dchk_id) references doc_checklist(dchk_id) on update restrict on delete restrictZ Eo DBADBAalter table loan add FK_LOAN_HAS_POLIC_INS_POLI foreign key(inp_id) references ins_policy(inp_id) on update restrict on delete restrictZ Eo DBADBAalter table loan add FK_LOAN_HAS_WARRA_WARRANTY foreign key(wrty_id) references warranty_co(wrty_id) on update restrict on delete restrictZ o DBADBAalter table loanGGGGGGGGGGG G!G"G#G$G%G&G'G(G)G*G+G,G-G.G/G0G1G2G3G4G5G6G7G8G9G:G;G<G=G>G?G