test
Tables (50)
AMPLT_FD
- PRDT_NO — NUMBER — Primary key — NOT NULL
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
CALC_AOTAX
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
- COST_AOTAX_IEM_NO — NUMBER — Primary key — NOT NULL
- PRDT_NO — NUMBER — Primary key — NOT NULL
- CALC_AMOUNT — NUMBER
CAR_TRNSPRT_DRVER
- OFC_NO — NUMBER — Primary key — NOT NULL
CAR_TRNSPRT_DRVERS
- TRNSPRT_MEANS_NO — NUMBER — Primary key — NOT NULL
- OFC_NO — NUMBER — Primary key — NOT NULL
- TRNSPRT_MEANS_OFC_SE — VARCHAR2(20) — Primary key — NOT NULL
- OFC_SN — NUMBER — Primary key — NOT NULL
CONTN
- CONTN_UNQ_NO — NUMBER — Primary key — NOT NULL
- OWN_NO — NUMBER — NOT NULL
- SPCFCT — VARCHAR2(150)
- MTRQLT — VARCHAR2(150)
- DSRBTR_FRGHT_KND — VARCHAR2(90)
COST_AOTAX_IEM
- COST_AOTAX_IEM_NO — NUMBER — Primary key — NOT NULL
- COST_AOTAX_IEM_NM — VARCHAR2(150)
CPR
- OFC_NO — NUMBER — Primary key — NOT NULL
- CPR_NO — VARCHAR2(30)
- ENT_SCALE_SE — VARCHAR2(20)
CSTBRKR
- OFC_NO — NUMBER — Primary key — NOT NULL
- GEN — VARCHAR2(20)
- BIR_DATE — DATE
- QLFC_AOQ_DATE — DATE
- FIN_EDU — DATE
- QLFC_CERTI_NO — VARCHAR2(100)
CSTMR
- OFC_NO — NUMBER — Primary key — NOT NULL
- ENTR_UNQ_BH — VARCHAR2(30)
CSTMR_ISPT
- OFC_NO — NUMBER — Primary key — NOT NULL
ENTR
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
- REQEST_DATE — DATE
- TRADE_SE — VARCHAR2(20)
- CSMHSE_STTEMNT_TY — VARCHAR2(20)
- CSMHSE_STTEMNT_PREARNGE_DATE — DATE
- CSMHSE_STTEMNT_DATE — DATE
- TRADE_PREARNGE_DATE — DATE
- TRADE_DATE — DATE
- TRADE_PORT — VARCHAR2(90)
- PURPS_NATION — VARCHAR2(90)
ENTR_COST_AOTAX
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
- COST_AOTAX_IEM_NO — NUMBER — Primary key — NOT NULL
- COST_AOTAX_SE — VARCHAR2(20)
- COMPUT_AMOUNT — NUMBER
ENTR_DOCU
- DOCU_NO — NUMBER — Primary key — NOT NULL
- TRADE_SE — VARCHAR2(20)
ENTR_OFC
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
- OFC_SN — NUMBER — Primary key — NOT NULL
- OFC_NO — NUMBER — NOT NULL
- OFC_SE — VARCHAR2(20)
ENTR_PRESENTN_DOCU
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
- DOCU_NO — NUMBER — Primary key — NOT NULL
- FLAW_WHET — VARCHAR2(20)
ENTR_TRGET_PROD
- PRDT_NO — NUMBER — Primary key — NOT NULL
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
- PROD_QUAL — VARCHAR2(90)
- UPRIC — NUMBER
- AMO — NUMBER
- AMO_UNIT — VARCHAR2(20)
- AMOUNT — NUMBER
- PACK_MET — VARCHAR2(90)
- PACK_AMO — NUMBER
- NET_WT — NUMBER
- PACK_WT — NUMBER
- VOLM — NUMBER
- TRD_MNY — VARCHAR2(90)
- ORIN — VARCHAR2(150)
- ORIN_CRTF_NO — NUMBER
- TRNSPRT_MET — VARCHAR2(90)
- TRNSPRT_MEANS — VARCHAR2(90)
- FLGH_SRVC_NO — NUMBER — NOT NULL
- WYBL_NO — NUMBER
- NR_CONTN_NMBR — NUMBER
- PROD_TY — VARCHAR2(90)
ETC
- PRDT_NO — NUMBER — Primary key — NOT NULL
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
FRGNR
- OFC_NO — NUMBER — Primary key — NOT NULL
- NATIOYCODE — VARCHAR2(20)
- FRGNR_IDNTFC_NO_SE — VARCHAR2(20)
- FRGNR_IDNTFC_NO — NUMBER
GROU_TRNSPRT_CMPNY
- TRNSPRT_CMPNY_NO — NUMBER — Primary key — NOT NULL
- CAR_POSS_UNUM — NUMBER
- PASNGER_TRNSPRT_CAR_POSS_UNUM — NUMBER
- FRGHT_TRNSPRT_CAR_POSS_UNUM — NUMBER
GRUP
- OFC_NO — NUMBER — Primary key — NOT NULL
- BSNM_REGIST_NO — VARCHAR2(20)
- MF_FIELD_SE — VARCHAR2(20)
IC_CARD
- IC_CARD_NO — NUMBER — Primary key — NOT NULL
- EXP_START_DATE — DATE — Primary key — NOT NULL
- EXP_END_DATE — DATE — Primary key — NOT NULL
- OFC_NO — NUMBER — NOT NULL
- ISS_TRGET_SE — VARCHAR2(20)
- ISS_SE — VARCHAR2(20)
- EXP_PRD_EXPN_DATE — DATE
- TRNSPRT_MEANS_NO — NUMBER — NOT NULL
INDVDL
- OFC_NO — NUMBER — Primary key — NOT NULL
- DOFG_SE — VARCHAR2(20)
INDVDLBSNM
- OFC_NO — NUMBER — Primary key — NOT NULL
INSPCT_IEM
- INSPCT_IEM_NO — NUMBER — Primary key — NOT NULL
- INSPCT_IEM_NM — VARCHAR2(150)
- INSPCT_MTH — VARCHAR2(150)
- INSPCT_APPLC_TY — VARCHAR2(20)
INSPCT_QRNT
- INSPCT_NO — NUMBER — Primary key — NOT NULL
- FLFL_DT — DATE
- FLFL_PLACE — VARCHAR2(90)
- OFC_NO — NUMBER — NOT NULL
INSPCT_QRNT_RESULT
- PRDT_NO — NUMBER — Primary key — NOT NULL
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
- INSPCT_NO — NUMBER — Primary key — NOT NULL
- INSPCT_APPLC_TY — VARCHAR2(20) — Primary key — NOT NULL
- INSPCT_IEM_NO — NUMBER — Primary key — NOT NULL
- PASS_WHET — VARCHAR2(10)
INSPCT_QRNT_TRGET_PROD
- PRDT_NO — NUMBER — Primary key — NOT NULL
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
- INSPCT_NO — NUMBER — Primary key — NOT NULL
- INSPCT_APPLC_TY — VARCHAR2(20) — Primary key — NOT NULL
- INSPCT_RESULT — VARCHAR2(30)
KR_SW_MTR
- PRDT_NO — NUMBER — Primary key — NOT NULL
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
- EXP_START_DATE — DATE — Primary key — NOT NULL
- EXP_END_DATE — DATE — Primary key — NOT NULL
- PRDUCT_NM — VARCHAR2(150)
- PRDUCT_TY — VARCHAR2(90)
- MNFCTURR — VARCHAR2(150)
- ORIN — VARCHAR2(150)
- IMPORT_SALESPER_NM — VARCHAR2(150)
- IMPORT_SALESPER_POC — VARCHAR2(90)
- MNFCTUR_YEARMTDAY — DATE
- DISTB_TMLMT — DATE
- WT — NUMBER
- CNQY — NUMBER
- MTRL_NM_CONT — NUMBER
- IRDNT_NM_CONT — NUMBER
- RTNGUD_EXCHNG_PLACE — VARCHAR2(90)
- ATTNMTR — CLOB
- CSTDY_MTH — VARCHAR2(1000)
- PACK_MTRQLT — VARCHAR2(90)
MF_PRDT
- OFC_NO — NUMBER — Primary key — NOT NULL
- PRDT_NO — NUMBER — Primary key — NOT NULL
MTRL_IRDNT
- PRDT_NO — NUMBER — Primary key — NOT NULL
- ENTR_MANAGE_NO — NUMBER — Primary key — NOT NULL
- WRITING_SE — VARCHAR2(20) — Primary key — NOT NULL
- MTTR — VARCHAR2(150) — Primary key — NOT NULL
- EXP_START_DATE — DATE — NOT NULL
- EXP_END_DATE — DATE — NOT NULL
- MTRL_NM — VARCHAR2(150)
- IRDNT_NM — VARCHAR2(150)
- CONT — NUMBER
NATIVE
- OFC_NO — NUMBER — Primary key — NOT NULL
- IHIDNUM — VARCHAR2(20)
- CLSF — VARCHAR2(150)
- ENCPN — DATE
- EMPNO — NUMBER
OFC
- OFC_NO — NUMBER — Primary key — NOT NULL
- EXP_START_DATE — DATE
- EXP_END_DATE — DATE
- OFC_NM — VARCHAR2(150)
- OFC_IDNTFC_NO — NUMBER
- IHIDNUM — VARCHAR2(20)
- FRGNRIDNTFCNO — VARCHAR2(20)
- BSNM_REGIST_NO — VARCHAR2(20)
- OFC_SE — VARCHAR2(20)
OFC_CTTPC
- OFC_NO — NUMBER — Primary key — NOT NULL
- CTTPC_SN — NUMBER — Primary key — NOT NULL
- EXP_START_DATE — DATE — Primary key — NOT NULL
- EXP_END_DATE — DATE — Primary key — NOT NULL
- CTTPC_SE — VARCHAR2(20)
- CTTPC_PRC — VARCHAR2(30)
OFC_RLTI
- RLTI_MBY_OFC_NO — NUMBER — Primary key — NOT NULL
- RLTI_TRGET_OFC_NO — NUMBER — Primary key — NOT NULL
- EXP_START_DATE — DATE — Primary key — NOT NULL
- EXP_END_DATE — DATE — Primary key — NOT NULL
- OFC_RLTI_SE — VARCHAR2(20)
ORGNZT
- OFC_NO — NUMBER — Primary key — NOT NULL
- ORGNZT_SE — VARCHAR2(20)
PNSH
- OFC_NO — NUMBER — Primary key — NOT NULL
- SRLNO — NUMBER — Primary key — NOT NULL
- VIOLT_CN — CLOB
- MTPN_SE — VARCHAR2(20)
- FNE — NUMBER
- FFNLG — NUMBER
PRDT
- PRDT_NO — NUMBER — Primary key — NOT NULL
- PRDT_NM — VARCHAR2(150)
- HS_Code — VARCHAR2(20)
SANC
- OFC_NO — NUMBER — Primary key — NOT NULL
- SRLNO — NUMBER — Primary key — NOT NULL
- TOT_STTEMNT_CO — NUMBER
- TOT_ITM_CO — NUMBER
- ERR_TOTALSCR — NUMBER
- ERR_RATE — NUMBER
- SANC_CN — CLOB
- SANC_START_DATE — DATE
- SANC_END_DATE — DATE
- DECSN_CSMHSE — VARCHAR2(150)
SANC_PNSH
- OFC_NO — NUMBER — Primary key — NOT NULL
- SRLNO — NUMBER — Primary key — NOT NULL
- SANC_PNSH_SE — VARCHAR2(20)
SHIPG_CMPNY
- TRNSPRT_CMPNY_NO — NUMBER — Primary key — NOT NULL
- SHIP_OPER_POSS_UNUM — NUMBER
- OPEC_SE — VARCHAR2(20)
SHIP_MEANS
- TRNSPRT_MEANS_NO — NUMBER — Primary key — NOT NULL
- IMO_REGIST_NO — NUMBER
- CALL_NO — NUMBER
- SHIP_NM — VARCHAR2(150)
- SHIP_NATIOY — VARCHAR2(150)
- BUILD_DATE — DATE
- SHIP_TY_SE — VARCHAR2(20)
- COURSE_SE — VARCHAR2(20)
- MAX_MTCAP — NUMBER
- MAX_SAIL_SPD — NUMBER
- TOT_TONGRADE — VARCHAR2(20)
- LDADNG_TONGRADE — VARCHAR2(20)
- CREW_MAXMAN — NUMBER
- PASNGER_MAXMAN — NUMBER
SHIP_PRPOS
- TRNSPRT_MEANS_NO — NUMBER — Primary key — NOT NULL
- SHIP_SE — VARCHAR2(20)
SHIP_SCREW
- OFC_NO — NUMBER — Primary key — NOT NULL
- SHIP_SCREW_SE — VARCHAR2(20)
SHIP_SCREW_SE
- TRNSPRT_MEANS_NO — NUMBER — Primary key — NOT NULL
- OFC_NO — NUMBER — Primary key — NOT NULL
- TRNSPRT_MEANS_OFC_SE — VARCHAR2(20) — Primary key — NOT NULL
- OFC_SN — NUMBER — Primary key — NOT NULL
- SHIP_SCREW_SE — VARCHAR2(20)
STTEMNT_ERR
- MANAGE_SE — NUMBER — Primary key — NOT NULL
- MANAGE_SN — VARCHAR2(20) — Primary key — NOT NULL
- OFC_NO — NUMBER — Primary key — NOT NULL
- APPLC_START_DATE — DATE
- APPLC_END_DATE — DATE
STTEMNT_ERR_ACCMLT
- OFC_NO — NUMBER — Primary key — NOT NULL
- ACCMLT_ERR_SCORE — NUMBER
- TOT_STTEMNT_CO — NUMBER
- ERR_OCCRRNC_WORK_SE — VARCHAR2(20)
STTEMNT_ERR_HIST
- OFC_NO — NUMBER — Primary key — NOT NULL
- STTEMNT_ERR_SCORE — NUMBER
- IMPT_SE — VARCHAR2(20)
- STTEMNT_ERR_OCCRRNC_ENTR_MANAG — NUMBER
TRNSPRT_CAR_MEANS
- TRNSPRT_MEANS_NO — NUMBER — Primary key — NOT NULL
- CAR_MANAGE_NO — NUMBER
- MODEL_NM — VARCHAR2(150)
- DSPLVL — NUMBER
- VHCLE_NO — NUMBER
- DLIVY_DATE — DATE
- CAR_NOPLT_NO — NUMBER
- TOT_WT — NUMBER
- LDADNG_WT — NUMBER
- TKCAR_MAXMAN — NUMBER
TRNSPRT_CAR_PRPOS
- TRNSPRT_MEANS_NO — NUMBER — Primary key — NOT NULL
- TRNSPRT_CAR_SE — VARCHAR2(20)
TRNSPRT_CMPNY
- TRNSPRT_CMPNY_NO — NUMBER — Primary key — NOT NULL
- TRNSPRT_MEANS_OPER_POSS_UNUM — NUMBER
- CAR_POSS_UNUM — NUMBER
- SHIP_OPER_POSS_UNUM — NUMBER
- TRNSPRT_MEANS_SE — VARCHAR2(20)
- OFC_NO — NUMBER — NOT NULL