-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtable_create_orig.sql
77 lines (77 loc) · 2.61 KB
/
table_create_orig.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
create or replace TABLE PRPSL (
PRPSL_KEY VARCHAR(250) NOT NULL,
TRANS_STRT_TMSTMP TIMESTAMP_TZ(9) NOT NULL,
PRPSL_ID NUMBER(38,0) NOT NULL,
BI_SRC_SYS_KEY NUMBER(38,0) NOT NULL,
PRPSL_VERS_NBR NUMBER(38,0) NOT NULL,
PRPSL_NM VARCHAR(255) NOT NULL,
PRPSL_CD VARCHAR(64) NOT NULL,
DEAL_ID NUMBER(38,0) NOT NULL,
DEAL_NM VARCHAR(255) NOT NULL,
PRPSL_REF_NBR NUMBER(38,0) NOT NULL,
PRPSL_STG_REVSN_NBR NUMBER(38,0) NOT NULL,
LIAB_GRP_KEY VARCHAR(250) NOT NULL,
PROMD_TO_PRPSL_ID NUMBER(38,0),
PRPSL_SUBTY_CD VARCHAR(10) NOT NULL,
PRPSL_SUBTY_DESC VARCHAR(255) NOT NULL,
AE_USR_KEY VARCHAR(250) NOT NULL,
ADVRT_KEY VARCHAR(250) NOT NULL,
BILL_TO_AGCY_KEY VARCHAR(250) NOT NULL,
BUYING_AGCY_KEY VARCHAR(250) NOT NULL,
BRND_KEY VARCHAR(250) NOT NULL,
CAMPGN_KEY VARCHAR(250) NOT NULL,
CRNCY_KEY VARCHAR(250) NOT NULL,
DEAL_SEASON_YR_NBR NUMBER(38,0),
DEAL_SEASON_CD VARCHAR(64),
SRC_PRPSL_STAT_ID NUMBER(38,0),
SRC_PRPSL_STAT_NM VARCHAR(64),
SRC_PRPSL_STAT_CD VARCHAR(64),
PRPSL_STAT_KEY VARCHAR(250),
PRPSL_VERS_ON_ORDR_IND VARCHAR(1) NOT NULL,
PRPSL_STG_KEY VARCHAR(250),
PRPSL_CURR_VERS_IND VARCHAR(1) NOT NULL,
PRPSL_SAVE_STAT_KEY VARCHAR(250),
FLGHT_ID NUMBER(38,0),
FLGHT_END_TMSTMP TIMESTAMP_TZ(9),
FLGHT_STRT_TMSTMP TIMESTAMP_TZ(9),
MKTPLC_KEY VARCHAR(250),
CAL_TY_KEY VARCHAR(250),
REV_CD VARCHAR(64) NOT NULL,
DIV_ID NUMBER(38,0),
DIV_CD VARCHAR(10),
COMBD_PKG_IND VARCHAR(1) NOT NULL,
ORDR_TY_KEY VARCHAR(250),
HH_DEMO_KEY VARCHAR(250) NOT NULL,
GUAR_DEMO_KEY VARCHAR(250) NOT NULL,
PRIM_DEMO_KEY VARCHAR(250) NOT NULL,
SEC_DEMO_KEY VARCHAR(250) NOT NULL,
ESTD_DLVRY_STREAM_KEY VARCHAR(250) NOT NULL,
EQV_CD VARCHAR(255),
PRPSL_EMERG_PROP_IND VARCHAR(1) NOT NULL,
PRPSL_ADU_TY_CD VARCHAR(64),
PEEL_PRPSL_XREF_ID NUMBER(38,0),
PEEL_PRPSL_ID NUMBER(38,0),
PRPSL_PREM_DR_IND VARCHAR(1) NOT NULL,
PRPSL_ROS_DR_IND VARCHAR(1) NOT NULL,
EXCHG_RT_TMSTMP TIMESTAMP_TZ(9),
EXCHG_RT_UTC_TMSTMP TIMESTAMP_TZ(9) NOT NULL,
USD_CRNCY_EXCHG_RT_ID NUMBER(38,0),
USD_EXCHG_RT NUMBER(38,15),
UNIT_SLOT_ALLOC_IND VARCHAR(1) NOT NULL,
UNIT_SCHD_WKLY_ALLOCTN_IND VARCHAR(1) NOT NULL,
UNIT_SCHD_ALLOCTN_TY_KEY VARCHAR(250) NOT NULL,
DGTL_IMPRSN_SRC_KEY VARCHAR(250),
DGTL_CMPSTN_SRC_KEY VARCHAR(250),
TM_ZN_KEY VARCHAR(250) NOT NULL,
CRT_BY VARCHAR(100),
CRT_CAL_DT DATE,
CRT_UTC_TMSTMP TIMESTAMP_TZ(9),
CRT_TMSTMP TIMESTAMP_TZ(9),
LAST_MODFD_DT TIMESTAMP_TZ(9),
LAST_MODFD_BY VARCHAR(100),
SRC_COMMIT_TMSTMP TIMESTAMP_TZ(9) NOT NULL,
SRC_PUBSHD_TMSTMP TIMESTAMP_TZ(9) NOT NULL,
DELETD_FRM_SRC_IND VARCHAR(1) NOT NULL,
CNFRMNC_UPTD_TMSTMP TIMESTAMP_TZ(9) NOT NULL,
CNFRMNC_UPTD_PROCS_NM VARCHAR(255) NOT NULL
);