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