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