EXEC pkg_dwh_common_proc.stpr_dwh_drop_tbl('tbl_maprg_pp_vst_usr_maint_u', 'N');
CREATE TABLE tbl_maprg_pp_vst_usr_maint_u
(
month number(6,0) unique NOT NULL, --整数
txn_amt number NOT NULL,
guest_vst_amt_usd number NOT NULL,
guest_vst_amt_cny number NOT NULL,
pnlty_amt number NOT NULL,
APROV_FLG VARCHAR2(1),
APROV_BY VARCHAR2(30),
APROV_TS DATE,
LST_UPDATED_BY VARCHAR2(30),
LST_UPDATED_TS DATE,
check(month>200000 and month<300000)
)
pctfree 0
tablespace TBS_MAPG_OUT_MEDIUM
nologging;
commit;
CREATE TABLE tbl_maprg_pp_vst_usr_maint_u
(
month number(6,0) unique NOT NULL, --整数
txn_amt number NOT NULL,
guest_vst_amt_usd number NOT NULL,
guest_vst_amt_cny number NOT NULL,
pnlty_amt number NOT NULL,
APROV_FLG VARCHAR2(1),
APROV_BY VARCHAR2(30),
APROV_TS DATE,
LST_UPDATED_BY VARCHAR2(30),
LST_UPDATED_TS DATE,
check(month>200000 and month<300000)
)
pctfree 0
tablespace TBS_MAPG_OUT_MEDIUM
nologging;
commit;