erd
테이블 (13)
account회원 (Untitled7)
- acc_num (Key) — varchar(4) — 기본 키 — NOT NULL
- mm_num (Key2) — varchar(4) — 외래 키 → 회원 Member.mm_num — NOT NULL
- mm_nm (Key3) — varchar(4) — 외래 키 → 회원 Member.mm_nm — NOT NULL
- create_dt (Field) — timestamp
- edit_dt (Field2) — timestamp
n2n_face회원 (Untitled8)
- n2n_num (Key) — varchar(4) — 기본 키 — NOT NULL
- mm_num (Key2) — varchar(4) — 외래 키 → 회원 Member.mm_num — NOT NULL
- mm_nm (Key3) — varchar(4) — 외래 키 → 회원 Member.mm_nm — NOT NULL
- mm_bupnu (Field) — bigint(20)
- mm_tnum (Field2) — bigint(20)
- mm_balance (Field3) — decimal(15,2)
- creat_dt (Field4) — timestamp
- edit_dt (Field5) — timestamp
name회원 (Untitled6)
- name_num (Key3) — varchar(4) — 기본 키 — NOT NULL
- mm_num (Key) — varchar(4) — 외래 키 → 회원 Member.mm_num — NOT NULL
- create_dt (Field) — timestamp
- edit_dt (Field2) — timestamp
국가코드 countrycode (Untitled13)
- ct_code (Key) — 기본 키 — NOT NULL
메세지message (Untitled10)
- mes_num (Key) — varchar(4) — 기본 키 — NOT NULL
- or_nu (Key2) — varchar(4) — 외래 키 → 주문번호Order number.or_nu — NOT NULL
- coi (Key3) — varchar(4) — 외래 키 → 신용개설정보 Credit opening information.coi — NOT NULL
- mm_num (Key22) — varchar(15) — 외래 키 → 신용개설정보 Credit opening information.mm_num — NOT NULL
- ct_code (Key32) — 외래 키 → 신용개설정보 Credit opening information.ct_code — NOT NULL
- send_num (Field) — bigint(10)
- rece_num (Field2) — bigint(10)
- message (Field3) — varchar(40)
- send_dt (Field4) — timestamp
- rece_dt (Field5) — timestamp
- in_file_yn (Field6) — char(1)
- t_num (Field7) — varchar(4)
- create_dt (Field8) — timestamp
- edit_dt (Field9) — timestamp
변경사항changlist (Untitled4)
- cl_cod (Key) — char(2) — 기본 키 — NOT NULL
신용개설정보 Credit opening information (Untitled9)
- coi (Key) — varchar(15) — 기본 키 — NOT NULL
- mm_num (Key2) — varchar(15) — 외래 키 → 회원 Member.mm_num — NOT NULL
- ct_code (Key3) — 외래 키 → 국가코드 countrycode.ct_code — NOT NULL
- coi_sdt (Field) — timestamp
- coi_fdt (Field2) — timestamp
- coi_limit amt (Field3) — decimal(15,2)
- coi_fullpay_dt (Field4) — timestamp
- coi_f_fullpay_dt (Field5) — timestamp
- coi_f_status_dt (Field6) — timestamp
- coi_f_status (Field7) — char(12)
- coi_r_dt (Field8) — timestamp
- coi_credit rate (Field9) — decimal(15,2)
- create_dt (Field10) — timestamp
- edit_dt (Field11) — timestamp
신용거래관리Credit transaction management (Untitled)
- ctm_od (Key) — varchar(4) — 기본 키 — NOT NULL
- or_nu (Key2) — varchar(4) — 외래 키 → 주문번호Order number.or_nu — NOT NULL
- ctm_day (Field) — timestamp
- ctm_ac (Field2) — varchar(4)
- cum_balance (Field3) — decimal(15,2)
- cum_ud (Field4) — varchar(4)
- cum_aof (Field5) — decimal(15,2)
- create_dt (Field6) — timestamp
- edit_dt (Field7) — timestamp
신용거래변경이력Credit transaction change history (Untitled3)
- ctch_stdy (Key) — timestamp — 기본 키 — NOT NULL
- ctch_fd (Key2) — timestamp — 기본 키 — NOT NULL
- ctm_od (Key3) — varchar(4) — 외래 키 → 신용거래관리Credit transaction management.ctm_od — NOT NULL
- cl_cod (Key4) — varchar(20) — 외래 키 → 변경사항changlist.cl_cod — NOT NULL
- ctch_reason (Field) — varchar(20)
- ctch_status (Field2) — varchar(20)
- ctch_create_dt (Field3) — timestamp
- create_dt (Field4) — timestamp
- edit_dt (Field5) — timestamp
은행계좌history (Untitled11)
- hs_seq (Key3) — varchar(4) — 기본 키 — NOT NULL
- seq (Key) — varchar(4) — 외래 키 → 은행계좌거래내역.seq — NOT NULL
- coi (Key1) — varchar(15) — 외래 키 → 은행계좌거래내역.coi — NOT NULL
- mm_num (Key2) — varchar(15) — 외래 키 → 은행계좌거래내역.mm_num — NOT NULL
- ct_code (Key32) — 외래 키 → 은행계좌거래내역.ct_code — NOT NULL
- mem_edit_dt (Field) — timestamp
은행계좌거래내역 (Untitled12)
- seq (Key) — varchar(4) — 기본 키 — NOT NULL
- coi (Key1) — varchar(15) — 외래 키 → 신용개설정보 Credit opening information.coi — NOT NULL
- mm_num (Key2) — varchar(15) — 외래 키 → 신용개설정보 Credit opening information.mm_num — NOT NULL
- ct_code (Key3) — 외래 키 → 신용개설정보 Credit opening information.ct_code — NOT NULL
- mem_type (Field) — varchar(4)
- mem_act (Field2) — decimal(15,2)
- mem_create_dt (Field3) — timestamp
- mem_use_dt (Field4) — timestamp
- mem_edit_dt (Field5) — timestamp
주문번호Order number (Untitled2)
- or_nu (Key) — varchar(4) — 기본 키 — NOT NULL
회원 Member (Untitled5)
- mm_num (Key) — varchar(4) — 기본 키 — NOT NULL
- mm_nm (Key3) — varchar(4) — 기본 키 — NOT NULL
- mm_id (Field) — varchar(20)
- mm_pw (Field2) — varchar(20)
- mm_cp (Field3) — varchar(20)
- mm_key (Field4) — varchar(3)
- mm_guid (Field5) — varchar(20)
- mm_phone (Field6) — bigint(10)
- mm_addr (Field7) — varchar(20)
- mm_dt (Field8) — timestamp
- mm_balance (Field10) — decimal(15,2)
- mm_rrm (Field11) — bigint(20)
- mm_email (Field12) — varchar(20)
- mm_tnum (Field13) — bigint(20)
- mm_bupnu (Field14) — bigint(20)
- create_dt (Field9) — timestamp
- edit_dt (Field15) — timestamp