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)