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)

Month (Untitled)