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