test

Tables (5)

CIL_CLINIC_MANUF

  • RECEIPT_NO — varchar2(30 char) — Primary key — NOT NULL
  • MANUF_SEQ — DEFAULT — Primary key — NOT NULL — MANUF_SEQ
  • ENTP_SEQ — DEFAULT — ENTP_SEQ
  • MANUF_CODE — varchar2(1 char) — MANUF_CODE
  • MANUF_NAME — varchar2(3000 char) — MANUF_NAME
  • MANUF_COUNTRY_CODE — varchar2(2 char) — MANUF_COUNTRY_CODE
  • MANUF_PLACE — varchar2(2000 char) — MANUF_PLACE
  • REGIST_TS — timestamp — NOT NULL — REGIST_TS
  • REGISTER_ID — varchar2(50 char) — NOT NULL — REGISTER_ID
  • UPDATE_TS — timestamp — NOT NULL — UPDATE_TS
  • UPDATER_ID — varchar2(50 char) — NOT NULL — UPDATER_ID

CIP_PETITION

  • RECEIPT_NO — varchar2(30 char) — Primary key — NOT NULL
  • CP_BIZ_CLASS_CODE — varchar2(20 char) — CP_BIZ_CLASS_CODE
  • CP_IEM_NAME — varchar2(4000 char) — CP_IEM_NAME
  • MBER_ID — varchar2(50 char) — MBER_ID
  • CITY_CGG_CODE — varchar2(2 char) — CITY_CGG_CODE
  • APPLY_DT — date — APPLY_DT
  • CANCEL_DT — date — CANCEL_DT
  • LAST_PG_PAY_NO — varchar2(30 char) — LAST_PG_PAY_NO
  • PAY_DT — date — PAY_DT
  • PAY_FEE — DEFAULT — PAY_FEE
  • LAST_PAY_STATUS_CODE — varchar2(1 char) — LAST_PAY_STATUS_CODE
  • BELONG_ORG_CODE — varchar2(5 char) — BELONG_ORG_CODE
  • RECEIPT_DT — date — RECEIPT_DT
  • RECEIPT_DEPT_CODE — varchar2(7 char) — RECEIPT_DEPT_CODE
  • RECEIPT_ID — varchar2(50 char) — RECEIPT_ID
  • RECEIPT_METHOD_CODE — varchar2(5 char) — RECEIPT_METHOD_CODE
  • TREAT_PLAN_DE_CNT — DEFAULT — TREAT_PLAN_DE_CNT
  • TREAT_PLAN_DATE — date — TREAT_PLAN_DATE
  • TREAT_DEPT_CODE — varchar2(7 char) — TREAT_DEPT_CODE
  • TREATR_ID — varchar2(50 char) — TREATR_ID
  • REAL_TREAT_FINISH_DATE — date — REAL_TREAT_FINISH_DATE
  • CP_TREAT_PGS_CODE — varchar2(1 char) — CP_TREAT_PGS_CODE
  • CP_TREAT_GB_CODE — varchar2(2 char) — CP_TREAT_GB_CODE
  • ARVL_YN — varchar2(1 char) — ARVL_YN
  • ARVL_DATE — date — ARVL_DATE
  • DOC_PG_YN — varchar2(1 char) — DOC_PG_YN
  • DOC_FINISH_ID — varchar2(50 char) — DOC_FINISH_ID
  • DOC_FINISH_DT — date — DOC_FINISH_DT
  • ENTP_NAME — varchar2(200 char) — ENTP_NAME
  • CPR_YN — varchar2(1 char) — CPR_YN
  • CPR_NAME — varchar2(150 char) — CPR_NAME
  • CPR_NO — varchar2(30 char) — CPR_NO
  • BIZRNO — varchar2(30 char) — BIZRNO
  • APPLY_FN_YN — varchar2(1 char) — APPLY_FN_YN
  • APPLY_COUNTRY_CODE — varchar2(2 char) — APPLY_COUNTRY_CODE
  • APPLY_PASPORT_NO — varchar2(50 char) — APPLY_PASPORT_NO
  • APPLY_PERSONAL_ID — varchar2(50 char) — APPLY_PERSONAL_ID
  • APPLY_NAME — varchar2(60 char) — APPLY_NAME
  • APPLY_TEL_NO — varchar2(100 char) — APPLY_TEL_NO
  • APPLY_PTP_NO — varchar2(100 char) — APPLY_PTP_NO
  • APPLY_EMAIL — varchar2(150 char) — APPLY_EMAIL
  • APPLY_ZIP_NO — varchar2(6 char) — APPLY_ZIP_NO
  • APPLY_ADDR1 — varchar2(500 char) — APPLY_ADDR1
  • APPLY_ADDR2 — varchar2(500 char) — APPLY_ADDR2
  • CHARGE_NAME — varchar2(60 char) — CHARGE_NAME
  • CHARGE_TEL_NO — varchar2(100 char) — CHARGE_TEL_NO
  • CHARGE_PTP_NO — varchar2(100 char) — CHARGE_PTP_NO
  • CHARGE_FAX_NO — varchar2(100 char) — CHARGE_FAX_NO
  • CHARGE_EMAIL — varchar2(150 char) — CHARGE_EMAIL
  • INFO_PRTC_YN — varchar2(1 char) — INFO_PRTC_YN
  • LAST_TREAT_CONT — varchar2(3000 char) — LAST_TREAT_CONT
  • MIX_CP_RECEIPT_NO — varchar2(30 char) — MIX_CP_RECEIPT_NO
  • MIX_CP_YN — varchar2(1 char) — MIX_CP_YN
  • ST_CP_CLASS_CODE — varchar2(20 char) — ST_CP_CLASS_CODE
  • SAFEEFF_CP_CLASS_CODE — varchar2(20 char) — SAFEEFF_CP_CLASS_CODE
  • CHANGE_COMP_DOC_NO — varchar2(30 char) — CHANGE_COMP_DOC_NO
  • PERMIT_RECV_CODE — varchar2(1 char) — PERMIT_RECV_CODE
  • TRANS_STATUS — varchar2(10 char) — TRANS_STATUS
  • REMARK — varchar2(3000 char) — REMARK
  • ARVL_DOC_DT — date — ARVL_DOC_DT
  • … +47

DRA_ENTP_FACTORY

  • FACTORY_NO — NOT — Primary key — NOT NULL — FACTORY_NO
  • ENTP_SEQ — NOT — Foreign key → DRA_ENTP_PERMIT.ENTP_SEQ — NOT NULL
  • FACTORY_NAME — varchar2(150 char) — FACTORY_NAME
  • FACTORY_ZIP_NO — varchar2(6 char) — FACTORY_ZIP_NO
  • FACTORY_ADDR1 — varchar2(2000 char) — FACTORY_ADDR1
  • FACTORY_ADDR2 — varchar2(500 char) — FACTORY_ADDR2
  • FACTORY_TEL_NO — varchar2(100 char) — FACTORY_TEL_NO
  • FACTORY_FAX_NO — varchar2(100 char) — FACTORY_FAX_NO
  • FACTORY_EMAIL — varchar2(150 char) — FACTORY_EMAIL
  • WH_ZIP_NO — varchar2(6 char) — WH_ZIP_NO
  • WH_ADDR1 — varchar2(2000 char) — WH_ADDR1
  • WH_ADDR2 — varchar2(500 char) — WH_ADDR2
  • MANAGE_KFDA_CODE — varchar2(5 char) — MANAGE_KFDA_CODE
  • CANCEL_CODE — varchar2(1 char) — CANCEL_CODE
  • CANCEL_DATE — date — CANCEL_DATE
  • REMARK — varchar2(3000 char) — REMARK
  • LAB_ADDR1 — varchar2(2000 char) — LAB_ADDR1
  • LAB_ADDR2 — varchar2(500 char) — LAB_ADDR2
  • BEF_ADDR1 — varchar2(500 char) — BEF_ADDR1
  • BEF_ADDR2 — varchar2(500 char) — BEF_ADDR2
  • BEF_FACTORY_ADDR1 — varchar2(500 char) — BEF_FACTORY_ADDR1
  • BEF_FACTORY_ADDR2 — varchar2(500 char) — BEF_FACTORY_ADDR2
  • ADDR_CNVR_GB — varchar2(2 char) — ADDR_CNVR_GB
  • STD_ENTP_CODE — varchar2(11 char) — STD_ENTP_CODE
  • OFFICE_AR — varchar2(100 char) — OFFICE_AR
  • WH_AR — varchar2(100 char) — WH_AR
  • GMP_GRADE_CODE — varchar2(1 char) — GMP_GRADE_CODE
  • TRUSTEE_WH_NAME — varchar2(150 char) — TRUSTEE_WH_NAME
  • TRUSTEE_WH_PERMIT_NO — varchar2(200 char) — TRUSTEE_WH_PERMIT_NO
  • INSTT_STREET_NAME_CODE — varchar2(100 char) — INSTT_STREET_NAME_CODE
  • INSTT_STREET_NAME_DETAIL_ADDR — varchar2(500 char) — INSTT_STREET_NAME_DETAIL_ADDR
  • REGIST_TS — timestamp — NOT NULL — REGIST_TS
  • REGISTER_ID — varchar2(50 char) — NOT NULL — REGISTER_ID
  • UPDATE_TS — timestamp — NOT NULL — UPDATE_TS
  • UPDATER_ID — varchar2(50 char) — NOT NULL — UPDATER_ID

DRA_ENTP_PERMIT

  • ENTP_SEQ — NOT — Primary key — NOT NULL
  • INDUTY_CODE — varchar2(2 char) — INDUTY_CODE
  • ENTP_NO — varchar2(10 char) — ENTP_NO
  • PERMIT_KIND_CODE — varchar2(1 char) — PERMIT_KIND_CODE
  • KFDA_PERMIT_CODE — varchar2(5 char) — KFDA_PERMIT_CODE
  • ENTP_NAME — varchar2(300 char) — ENTP_NAME
  • BIZRNO — varchar2(30 char) — BIZRNO
  • UNION_BOSS_YN — varchar2(1 char) — NOT NULL — UNION_BOSS_YN
  • FN_YN — varchar2(1 char) — NOT NULL — FN_YN
  • BOSS_NAME — varchar2(60 char) — BOSS_NAME
  • BOSS_PERSONAL_ID — varchar2(50 char) — BOSS_PERSONAL_ID
  • BOSS_ZIP_NO — varchar2(30 char) — BOSS_ZIP_NO
  • BOSS_ADDR1 — varchar2(500 char) — BOSS_ADDR1
  • BOSS_ADDR2 — varchar2(500 char) — BOSS_ADDR2
  • BOSS_PRMDMCL_ADDR — varchar2(500 char) — BOSS_PRMDMCL_ADDR
  • ENTP_PERMIT_DATE — date — ENTP_PERMIT_DATE
  • CANCEL_CODE — varchar2(1 char) — CANCEL_CODE
  • CANCEL_DATE — date — CANCEL_DATE
  • PERMIT_YN1 — varchar2(1 char) — NOT NULL — PERMIT_YN1
  • PERMIT_YN2 — varchar2(1 char) — NOT NULL — PERMIT_YN2
  • PERMIT_YN3 — varchar2(1 char) — NOT NULL — PERMIT_YN3
  • PERMIT_YN4 — varchar2(1 char) — NOT NULL — PERMIT_YN4
  • PERMIT_YN5 — varchar2(1 char) — NOT NULL — PERMIT_YN5
  • PERMIT_COND — varchar2(4000 char) — PERMIT_COND
  • REMARK — varchar2(3000 char) — REMARK
  • NRCLG_CODE — varchar2(1 char) — NRCLG_CODE
  • TRTMNT_NARCOTIC_YN1 — varchar2(1 char) — NOT NULL — TRTMNT_NARCOTIC_YN1
  • TRTMNT_NARCOTIC_YN2 — varchar2(1 char) — NOT NULL — TRTMNT_NARCOTIC_YN2
  • TRTMNT_NARCOTIC_YN3 — varchar2(1 char) — NOT NULL — TRTMNT_NARCOTIC_YN3
  • TRTMNT_NARCOTIC_YN4 — varchar2(1 char) — NOT NULL — TRTMNT_NARCOTIC_YN4
  • SCHLSHP_STUDY_START_DATE — date — SCHLSHP_STUDY_START_DATE
  • SCHLSHP_STUDY_END_DATE — date — SCHLSHP_STUDY_END_DATE
  • SCHLSHP_PLAN_SCOPE — varchar2(3000 char) — SCHLSHP_PLAN_SCOPE
  • GMP_ENTP_YN — varchar2(1 char) — NOT NULL — GMP_ENTP_YN
  • BGMP_ENTP_YN — varchar2(1 char) — NOT NULL — BGMP_ENTP_YN
  • RECEIPT_NO — varchar2(30 char) — RECEIPT_NO
  • OLD_ENTP_NO — varchar2(200 char) — OLD_ENTP_NO
  • DATA_IMPRMN_GB — varchar2(1 char) — DATA_IMPRMN_GB
  • DATA_IMPRMN_REMARK — varchar2(3000 char) — DATA_IMPRMN_REMARK
  • MBER_ID — varchar2(50 char) — MBER_ID
  • PERMIT_YN6 — varchar2(1 char) — PERMIT_YN6
  • PERMIT_YN7 — varchar2(1 char) — PERMIT_YN7
  • PERMIT_YN8 — varchar2(1 char) — PERMIT_YN8
  • BOSS_BIRTHDAY — varchar2(30 char) — BOSS_BIRTHDAY
  • KCS_YN — varchar2(1 char) — NOT NULL — KCS_YN
  • COSMETIC_INDUTY_CODE — varchar2(1 char) — COSMETIC_INDUTY_CODE
  • SIDEJOB_YN — varchar2(1 char) — NOT NULL — SIDEJOB_YN
  • NARCOTIC_MATERIAL_CODE — varchar2(500 char) — NARCOTIC_MATERIAL_CODE
  • BEF_BOSS_ADDR1 — varchar2(500 char) — BEF_BOSS_ADDR1
  • BEF_BOSS_ADDR2 — varchar2(500 char) — BEF_BOSS_ADDR2
  • ADDR_CNVR_GB — varchar2(2 char) — ADDR_CNVR_GB
  • TRTMNT_NARCOTIC_CONT — varchar2(3000 char) — TRTMNT_NARCOTIC_CONT
  • PERMIT_KIND_GB — varchar2(1 char) — PERMIT_KIND_GB
  • SSS_START_DATE — date — SSS_START_DATE
  • SSS_END_DATE — date — SSS_END_DATE
  • INDUTY_CODE_DETAIL — varchar2(1 char) — INDUTY_CODE_DETAIL
  • STD_ENTP_CODE — varchar2(12 char) — STD_ENTP_CODE
  • INSTT_KIND_CODE — varchar2(5 char) — INSTT_KIND_CODE
  • INSTT_KIND_NAME — varchar2(300 char) — INSTT_KIND_NAME
  • MED_INSTT_DETAIL_KIND_CODE — varchar2(3 char) — MED_INSTT_DETAIL_KIND_CODE
  • … +38

DRG_LAB_CLASS

  • INSPCT_INSTT_SEQ — DEFAULT — Primary key — NOT NULL
  • INSPCT_INSTT_GB — varchar2(1 char) — INSPCT_INSTT_GB
  • INSPCT_INSTT_NO — varchar2(10 char) — INSPCT_INSTT_NO
  • INSPCT_INSTT_NAME — varchar2(300 char) — INSPCT_INSTT_NAME
  • ZIP_NO — varchar2(6 char) — ZIP_NO
  • ADDR1 — varchar2(500 char) — ADDR1
  • ADDR2 — varchar2(500 char) — ADDR2
  • TEL_NO — varchar2(100 char) — TEL_NO
  • FAX_NO — varchar2(100 char) — FAX_NO
  • BOSS_NAME — varchar2(60 char) — BOSS_NAME
  • BOSS_BIRTHDAY — varchar2(8 char) — BOSS_BIRTHDAY
  • OPER_CHARGE — varchar2(60 char) — OPER_CHARGE
  • OPER_CHARGE_BIRTHDAY — varchar2(8 char) — OPER_CHARGE_BIRTHDAY
  • BOSS_TEL_NO — varchar2(100 char) — BOSS_TEL_NO
  • BOSS_FAX_NO — varchar2(100 char) — BOSS_FAX_NO
  • INSPCT_CNT — DEFAULT — NOT NULL — INSPCT_CNT
  • LAB_AR — varchar2(100 char) — LAB_AR
  • CNSGN_INSPCT_IEM — varchar2(4000 char) — CNSGN_INSPCT_IEM
  • MED_INSTT_KIND_CODE — varchar2(1 char) — MED_INSTT_KIND_CODE
  • MED_INSTT_GB — varchar2(1 char) — MED_INSTT_GB
  • DIAG_ITEM — varchar2(1000 char) — DIAG_ITEM
  • RCPER_INSTT_APPOINT_CODE — varchar2(1 char) — RCPER_INSTT_APPOINT_CODE
  • REWARD_CNT — DEFAULT — NOT NULL — REWARD_CNT
  • DOCTR_CNT — DEFAULT — NOT NULL — DOCTR_CNT
  • INTERN_CNT — DEFAULT — NOT NULL — INTERN_CNT
  • RSIDNT_CNT — DEFAULT — NOT NULL — RSIDNT_CNT
  • TRAINING_CODE — varchar2(1 char) — TRAINING_CODE
  • TARGET_DRUG_APPLY_CODE — varchar2(1 char) — TARGET_DRUG_APPLY_CODE
  • APPOINT_DATE — date — APPOINT_DATE
  • RECEIPT_NO — varchar2(30 char) — RECEIPT_NO
  • INSPCT_INSTT_NAME_ENG — varchar2(300 char) — INSPCT_INSTT_NAME_ENG
  • ADDR_ENG — varchar2(2000 char) — ADDR_ENG
  • BOSS_NAME_ENG — varchar2(60 char) — BOSS_NAME_ENG
  • OPER_CHARGE_ENG — varchar2(2000 char) — OPER_CHARGE_ENG
  • CANCEL_DATE — date — CANCEL_DATE
  • CANCEL_REASON — varchar2(3000 char) — CANCEL_REASON
  • KFDA_PERMIT_CODE — varchar2(5 char) — KFDA_PERMIT_CODE
  • FOND_STDR — varchar2(3000 char) — FOND_STDR
  • FOND_PURPOSE — varchar2(3000 char) — FOND_PURPOSE
  • FOND_DATE — date — FOND_DATE
  • MED_CLINIC_YN — varchar2(1 char) — MED_CLINIC_YN
  • APPOINT_APPLY_FIELD_CODE — varchar2(1 char) — APPOINT_APPLY_FIELD_CODE
  • DATA_PRTC_YN — varchar2(1 char) — DATA_PRTC_YN
  • CANCEL_YN — varchar2(1 char) — NOT NULL — CANCEL_YN
  • DELETE_YN — varchar2(1 char) — NOT NULL — DELETE_YN
  • BIZRNO — varchar2(30 char) — BIZRNO
  • BOSS_GB — varchar2(1 char) — BOSS_GB
  • CLINIC_EXAM_JDGCMIT_GB — varchar2(2 char) — CLINIC_EXAM_JDGCMIT_GB
  • SUMR_INSTT_NAME — varchar2(300 char) — SUMR_INSTT_NAME
  • DISPS_YN — varchar2(1 char) — NOT NULL — DISPS_YN
  • BOSS_EMAIL — varchar2(150 char) — BOSS_EMAIL
  • INSPCT_INSTT — varchar2(300 char) — INSPCT_INSTT
  • DRUG_YN — varchar2(1 char) — DRUG_YN
  • SNITAT_YN — varchar2(1 char) — SNITAT_YN
  • HERB_YN — varchar2(1 char) — HERB_YN
  • COSMETIC_YN — varchar2(1 char) — COSMETIC_YN
  • END_DATE — date — END_DATE
  • ALWGN_YN — varchar2(1 char) — ALWGN_YN
  • QUALITY_INSPCT_NCL_YN — varchar2(1 char) — QUALITY_INSPCT_NCL_YN
  • IMPORT_INSPCT_NCL_YN — varchar2(1 char) — IMPORT_INSPCT_NCL_YN
  • … +18