sdfsfds
Tables (9)
agrment_chnnel_list
- ACL_SEQ — bigint(20) — Primary key — NOT NULL
- RCVR_GRP_CHN_ID — varchar(4) — Primary key — NOT NULL
- AV_SEQ — bigint(20) — Foreign key → agrment_ver.ACV_SEQ — NOT NULL
- DEL_YN — char(1)
agrment_ver
- ACV_SEQ — bigint(20) — Primary key — NOT NULL
- AGRMENT_VER — varchar(10) — NOT NULL
- DEL_YN — char(1)
alpha_ci
- AC_SEQ — bigint(20) — Primary key — NOT NULL
- CUST_CI — varchar(90) — Primary key — NOT NULL
- RCV_CHN_ID — varchar(10) — Primary key — NOT NULL
- AGRMENT_VER — varchar(10)
- AD_RCV_AGRMENT_YN — char(1)
- AD_RCV_MEDIA_CD — varchar(70)
- CUST_STATUS_TYPE — varchar(10)
- CREATE_DT — datetime
- UPDATE_DT — datetime
- MKT001 — varchar(10)
- MKT002 — varchar(10)
- MKT003 — varchar(10)
- MKT004 — varchar(255)
- MKT005 — varchar(50)
- MKT006 — varchar(50)
- DEL_YN — char(1)
alpha_ci_ad_agrment
- ACAA_SEQ — bigint(20) — Primary key — NOT NULL
- RCV_CHN_ID — varchar(10)
- AD_RCV_AGRMENT_YN — char(1)
- AD_RCV_MEDIA_CD — varchar(70)
- CREATE_DT — datetime
alpha_ci_agrment_list
- ACAA_SEQ — bigint(20) — Primary key — NOT NULL
- PRVDR_GRP_CHN_ID — varchar(4)
- RCVR_GRP_CHN_ID — varchar(4)
- AGRMENT_YN — char(1)
alpha_ci_agrment_update
- ACAU_SEQ — bigint(20) — Primary key — NOT NULL
- CREATE_DT — datetime
alpha_ci_basic
- ACB_SEQ — bigint(20) — Primary key — NOT NULL
- CUST_STATUS_TYPE — varchar(10)
- MKT001 — varchar(10)
- MKT002 — varchar(10)
- MKT003 — varchar(10)
- MKT004 — varchar(255)
- MKT005 — varchar(50)
- MKT006 — varchar(50)
- CREATE_DT — datetime
alpha_ci_history
- ACH_SEQ — bigint(20) — Primary key — NOT NULL
- AC_SEQ — bigint(20) — Foreign key → alpha_ci.AC_SEQ
- ACB_SEQ — bigint(20) — Foreign key → alpha_ci_basic.ACB_SEQ
- ACAU_SEQ — bigint(20) — Foreign key → alpha_ci_agrment_update.ACAU_SEQ
- ACAA_SEQ — bigint(20) — Foreign key → alpha_ci_ad_agrment.ACAA_SEQ
- REG_ID — varchar(20)
- UPDATE_DT — datetime
alpha_ci_transmit_request
- ACTR_SEQ — bigint(20) — Primary key — NOT NULL
- ACH_SEQ — bigint(20) — Foreign key → alpha_ci_history.ACH_SEQ — NOT NULL
- TRANSACTION_ID — varchar(50)
- TRY_CNT — int(11)
- CREATE_DT — datetime
- UPDATE_DT — datetime