erd

Tables (5)

cm_acacdemy_service_status_log (Untitled3)

  • log_idx (Key) — Primary key — NOT NULL
  • ac_idx (Field)
  • service_status (Field2)
  • change_user_idx (Field3)
  • Field4
  • ac_idx (Key2) — Foreign key → cm_academy.ac_idx — NOT NULL

cm_academy (Untitled)

  • ac_idx (Key) — Primary key — NOT NULL
  • ac_onwer_user_idx (Field)
  • ac_name (Field2)
  • ac_onwer_name (Field3)
  • ac_tel (Field4)
  • ac_addr (Field5)
  • ad_logo_img (Field6)
  • ac_brand_top_msg (Field7)
  • ac_brand_bottom_msg (Field8)
  • ac_brand_tel (Field9)
  • reg_date (Field10)
  • service_status (Field11)
  • max_std_cnt (Field12)
  • list_price (Field13)
  • monthly_price (Field14)
  • monthly_price_end_date (Field15)
  • discount_rate (Field16)
  • service_start_date (Field17)
  • service_end_date (Field18)
  • last_success_paid_date (Field19)
  • billkey (Field20)
  • card_code (Field21)
  • card_name (Field22)
  • memo (Field23)
  • service_from_date (Field24)
  • service_to_date (Field25)
  • exp_status (Field26)
  • exp_end_date (Field27)
  • school_yn (Field28)
  • cc_user_idx (Field29)

cm_academy_bill (Untitled2)

  • bill_idx (Key) — Primary key — NOT NULL
  • ac_idx (Field)
  • cancel_yn (Field3)
  • max_std_cnt (Field4)
  • list_price (Field5)
  • monthly_price (Field7)
  • discount_rate (Field8)
  • service_from (Field9)
  • next_pay_date (Field10)
  • service_to (Field13)
  • pay_date (Field2)
  • next_pay_date (Field6)
  • pay_status (Field11)
  • cancel_text (Field12)
  • reg_date (Field14)
  • ac_idx (Key2) — Foreign key → cm_academy.ac_idx — NOT NULL

cm_academy_price_change_log (Untitled4)

  • log_idx (Key) — Primary key — NOT NULL
  • ac_idx (Field)
  • max_std_cnt (Field2)
  • list_price (Field3)
  • monthly_price (Field4)
  • discount_rate (Field5)
  • request_date (Field6)
  • active_date (Field7)
  • ac_idx (Key2) — Foreign key → cm_academy.ac_idx — NOT NULL

fm_b2b_school_bill_pay (Untitled5)

  • bill_pay_idx (Field)
  • bill_idx (Field2)
  • billkey (Field3)
  • TID (Field4)
  • result_code (Field5)
  • result_msg (Field6)
  • auth_code (Field7)
  • card_code (Field8)
  • card_name (Field9)
  • reg_date (Field10)