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