Contract-Practice
Tables (6)
Contract (계약)
- id (ID)
- able (식제여부)
- access_amount (Field4)
- account_name (Field5)
- account_nubmer (Field2)
- adjust_rate (Field6)
- all_stock_number (단체증권번호)
- business_id (Field8)
- car_number (차량번호)
- collect_date (이체희망일)
- compony_id (회사구분)
- contract_concept (Field12)
- contract_end_date (계약만기일)
- contract_id (Field14)
- contract_start_date (계약시작일)
- contract_status_code (Field16)
- contract_status_detail_code (Field17)
- createtime (작성시간)
- insurance_period (Field19)
- insurance_period_kind (Field20)
- insure_id (보험사ID)
- insured1 (Field22)
- insured2 (Field23)
- last_payment_time (Field24)
- memo (Field25)
- network (Field26)
- next_month_fee_apply_yn (Field27)
- payment_means_code (Field28)
- payment_means_type_code (Field29)
- payment_method_code (납입방법코드)
- payment_period (Field31)
- payment_period_kind (Field32)
- payment_time (Field33)
- pension_start_year (Field34)
- personal_info_consent (Field35)
- pre_payment (Field36)
- pre_payment_month (Field37)
- product_gubun_id (Field38)
- product_id (Field39)
- reject_code (Field40)
- renewal (Field41)
- self_contract (Field42)
- approval (Field43)
- stock_number (증권번호)
- writer (작성자)
- temp_date (Field46)
- updater (수정자)
- updatetime (수정시간)
- compare_info_confirm (Field49)
- closing (Field50)
- customer_policyholder_id (Field51)
- customer_insured_id (Field52)
- old_stock_number (구 증권번호)
- automatic_transfer_date (Field54)
- analysis (Field55)
- contract_score_id (Field56)
- contract_receipt_id (Field57)
- adjust_pay_rate1 (Field58)
- adjust_pay_rate2 (Field59)
- adjust_pay_rate3 (Field60)
- … +13
Contract_arrange_share (섭외/DB)
- id (Field)
- able (Field2)
- collect_id (Field3)
- company_id (Field4)
- contract_id (Field5)
- createtime (Field6)
- recruite_id (Field7)
- create_time (Field8)
- recruit_id (Field9)
- share_gubun_code (Field10)
- share_rate (Field11)
- writer (Field12)
- orders (Field13)
Contract_customer (계약고객)
- id (Field)
- able (Field2)
- ceo_name (Field3)
- company_id (Field4)
- contract_id (Field5)
- createtime (Field6)
- customer_gubun (Field7)
- customer_name (Field8)
- customer_type_code (Field9)
- home_address (Field10)
- home_address_detail (Field11)
- home_phone (Field12)
- home_zipcode (Field13)
- maid_address (Field14)
- memo (Field15)
- mobile_phone (Field16)
- office_address (Field17)
- office_address_detail (Field18)
- office_phone (Field19)
- office_zipcode (Field20)
- registraction_number (Field21)
- writer (Field22)
Contract_score (성적)
- id (Field)
- able (Field2)
- before_premium (Field3)
- company_idc (Field4)
- createtime (Field5)
- insure_score1 (Field6)
- insure_score2 (Field7)
- insure_score3 (Field8)
- main_score1 (Field9)
- main_score2 (Field10)
- main_score3 (Field11)
- pay_month (Field12)
- payment_status_code (Field13)
- payment_time (Field14)
- premium (Field15)
- score1 (Field16)
- score2 (Field17)
- score3 (Field18)
- writer (Field19)
- change_date (Field20)
- upload_yn (Field21)
- refund_yn (Field22)
- memo (Field23)
Contract_share (모집인)
- id (Field)
- able (Field2)
- createtime (Field3)
- writer (Field4)
- contract_id (Field5)
- company_id (Field6)
- recruit_id (Field7)
- collect_id (Field8)
- share_gubun_code (Field9)
- share_rate (Field10)
- main_yn (Field11)
- change_collect_id (Field12)
- memo (Field13)