I
Chff
2
ID
l
CL
ID(FK)
I
1!2
fK:
TIME_ID,
LDC
ID,
WUJD,
MCL
ID,
PACKING
-
lD
,
WARRANTY_ID, COND!TlON_ID
Fie!rl
TyJl>'
Length
J MileraJmg.-<11
Sm:orce
Dtntabs.se
T:;bhe
J!f]cld
Vall!lle
TIME_lD
!nt
4
IDumuk
Col.tcction
MST _DET_SALES
(PKI/FK)
v..-aklu
ID tlnl \
MDS TGL
Transform
?ROD
·· · ·
LOC
lD(FK)
Chat
3
cabmtg
CoHccti.on
MST
_DET_Sf.LES
LDC_LD
Tra1'lsform
LBU_ID(FK)
2
ID illlluk
c:.:,Hecrion
MST_DET_SALES
,
LBU ID
i
Transform.
hllinis unit
MCL_ID
Char
13
ID un1lik
ColJ:ection
MST_DET_SALES
MCL ID
Transform
PK2/FK'
nasabah
?ACKING_
l01mtuk
Marine
TSPPA
PACKING_
Inmsfann
lD(FK)
pacldn.g
ID
WARRANTY_
Ch
4
lD untuk
Marine
TSPPA
WJ\.R... "'TY_
Transfurm
warranty
CONDITION_
Ch
4
IDtmt'uk
Marine
TSPPi\
CONDITION
Transform
ID(FK)
condition
!D
MDS
S'L'M
-
Moocy
19
Totcl preiDi
Cdlecl.ioo
MST_DET_SALES
MDS
SUM
Transform
PREMIT
PR!EMT
20.
Metadata !abel
KLAll'v1
Sumber :
basis
data
operasimmJ. no.
2, 3, 4, 5
PK:
MKL NO
SPK
fK:
NO_SPA, MKE
NO
ID,
TIME_ID,
LDC_ID, LRU_ID, MCL
ID,
Sl!IP_ID, CONVEYA.NCE_ID, MTL_Jl),
DIAGNOSIS
lD
S(!Ul"CIE:
Table
Fielrl
!
Value
MKL
NO
SPK(PK)
Char
12
ID lill uk
kiuim
MllU/
Marine!
Fire/
Medicare
MSTJ..LAlMJ
TCLAlMI
T_CLATh1/
T CLAJM
MKL
NO
SPK/
REG_NO/REG_NO/
Tr!illsform.
R.E(i-
S'J't':I{_NO
1 NO SP'A
(FK)
Char
Cluu
I
I
lDunfmk
1.2
regi.strasi
polis
1D n:ntnk
5
kendara:tll.111
yangke
l
MBU/
Moind
F1J'"e/
Medicare
MBU
MST_KLAIM/
TC'!..AL\11
'l'J
T,AHvf/
I
T CLA.h"""\1
MST
KEN"DARAAN
MSP_NO_SPAK/
0
NO
SPPA!
SPPA_NO/
SPPA_NO
MKR_NO_[[)
Tnmsform
Transform
berapa
I
 |