Lpoint

Tables (6)

br (CopyOfCopyOfCopyOftable2)

  • br_c (Field4) — String — Primary key
  • cop_c (Field3) — String
  • zon_mcls (Field7) — String
  • zon_hlv (Field6) — String — Z01 ~ Z17

cop_u (CopyOfCopyOftable)

  • cust (Field) — String
  • rct_no (Key) — String — NOT NULL
  • chnl_dv (Field2) — Int — 1 or 2
  • cop_c (Field3) — String — B01, C01, C02, D01, D02, E01
  • br_c (Field4) — String — can be Null
  • de_dt (Field6) — DateTime — YYYYMMDD
  • de_hr (Field7) — Int — 0 ~ 23
  • vst_dt (Field9) — DateTime — YYYYMMDD
  • buy_am (Field8) — Int

demo (table)

  • cust (Field) — String — Primary key
  • ma_fem_dv (Field2) — String — 남성 or 여성
  • ages (Field3) — String — 20대 ~ 70대
  • zon_hlv (Field4) — String — Z01 ~ Z17

lpay (CopyOfCopyOfCopyOftable)

  • cust (Field) — String
  • rct_no (Key) — String — NOT NULL
  • chnl_dv (Field2) — Int — 1 or 2
  • cop_c (Field3) — String
  • de_dt (Field6) — DateTime — YYYYMMDD
  • de_hr (Field7) — Int — 0 ~ 23
  • buy_am (Field8) — Int

pd_clac (CopyOfCopyOftable2)

  • pd_c (Field5) — String — Primary key
  • pd_nm (Field) — String
  • clac_mcls_nm (Field3) — String
  • clac_hlv_nm (Field2) — String

pdde (CopyOftable)

  • cust (Field) — String
  • rct_no (Key) — String — NOT NULL
  • chnl_dv (Field2) — Int — 1 or 2
  • cop_c (Field3) — String — A01 ~ A06
  • br_c (Field4) — String — can be Null
  • pd_c (Field5) — String
  • de_dt (Field6) — DateTime — YYYYMMDD
  • de_hr (Field7) — Int — 0 ~ 23
  • buy_am (Field8) — Int
  • buy_ct (Field9) — Int