egovTemplete
Tables (17)
IDS
- TABLE_NAME — varchar2(20) — Primary key — NOT NULL
- NEXT_ID — number(30,0)DEFAULT — NOT NULL
LETTCCMMNCLCODE
- CL_CODE — char(3) — Primary key — NOT NULL
- CL_CODE_NM — varchar2(60)
- CL_CODE_DC — varchar2(200)
- USE_AT — char(1)
- FRST_REGIST_PNTTM — DATE
- FRST_REGISTER_ID — varchar2(20)
- LAST_UPDT_PNTTM — DATE
- LAST_UPDUSR_ID — varchar2(20)
LETTCCMMNCODE
- CODE_ID — varchar2(6) — Primary key — NOT NULL
- CODE_ID_NM — varchar2(60)
- CODE_ID_DC — varchar2(200)
- USE_AT — char(1)
- CL_CODE — char(3) — Foreign key → LETTCCMMNCLCODE.CL_CODE
- FRST_REGIST_PNTTM — DATE
- FRST_REGISTER_ID — varchar2(20)
- LAST_UPDT_PNTTM — DATE
- LAST_UPDUSR_ID — varchar2(20)
LETTCCMMNDETAILCODE
- CODE — varchar2(15) — Primary key — NOT NULL
- CODE_ID — varchar2(6) — Foreign key → LETTCCMMNCODE.CODE_ID — NOT NULL
- CODE_NM — varchar2(60)
- CODE_DC — varchar2(200)
- USE_AT — char(1)
- FRST_REGIST_PNTTM — DATE
- FRST_REGISTER_ID — varchar2(20)
- LAST_UPDT_PNTTM — DATE
- LAST_UPDUSR_ID — varchar2(20)
LETTNAUTHORGROUPINFO
- GROUP_ID — char(20) — Primary key — NOT NULL
- GROUP_NM — varchar2(60) — NOT NULL
- GROUP_CREAT_DE — char(20) — NOT NULL
- GROUP_DC — varchar2(100)
LETTNBBS
- NTT_ID — number(20,0) — Primary key — NOT NULL
- BBS_ID — char(20) — Foreign key → LETTNBBSMASTER.BBS_ID — NOT NULL
- NTT_NO — number(20,0)
- NTT_SJ — varchar2(2000)
- NTT_CN — CLOB
- ANSWER_AT — char(1)
- PARNTSCTT_NO — number(10,0)
- ANSWER_LC — number(11)
- SORT_ORDR — number(8,0)
- RDCNT — number(10,0)
- USE_AT — char(1) — NOT NULL
- NTCE_BGNDE — char(20)
- NTCE_ENDDE — char(20)
- NTCR_ID — varchar2(20)
- NTCR_NM — varchar2(20)
- PASSWORD — varchar2(200)
- ATCH_FILE_ID — char(20)
- FRST_REGIST_PNTTM — DATE — NOT NULL
- FRST_REGISTER_ID — varchar2(20) — NOT NULL
- LAST_UPDT_PNTTM — DATE
- LAST_UPDUSR_ID — varchar2(20)
LETTNBBSMASTER
- BBS_ID — char(20) — Primary key — NOT NULL
- BBS_NM — varchar2(255) — NOT NULL
- BBS_INTRCN — varchar2(2400)
- BBS_TY_CODE — char(6) — NOT NULL
- BBS_ATTRB_CODE — char(6) — NOT NULL
- REPLY_POSBL_AT — char(1)
- FILE_ATCH_POSBL_AT — char(1) — NOT NULL
- ATCH_POSBL_FILE_NUMBER — number(2,0) — NOT NULL
- ATCH_POSBL_FILE_SIZE — number(8,0)
- USE_AT — char(1) — NOT NULL
- TMPLAT_ID — char(20)
- FRST_REGISTER_ID — varchar2(20) — NOT NULL
- FRST_REGIST_PNTTM — DATE — NOT NULL
- LAST_UPDUSR_ID — varchar2(20)
- LAST_UPDT_PNTTM — DATE
LETTNBBSMASTEROPTN
- BBS_ID — char(20) — Primary key — NOT NULL
- ANSWER_AT — char(1) — NOT NULL
- STSFDG_AT — char(1) — NOT NULL
- FRST_REGIST_PNTTM — DATE — NOT NULL
- LAST_UPDT_PNTTM — DATE
- FRST_REGISTER_ID — varchar2(20) — NOT NULL
- LAST_UPDUSR_ID — varchar2(20)
LETTNBBSUSE
- TRGET_ID — char(20) — Primary key — NOT NULL
- BBS_ID — char(20) — Foreign key → LETTNBBSMASTER.BBS_ID — NOT NULL
- USE_AT — char(1) — NOT NULL
- REGIST_SE_CODE — char(6)
- FRST_REGIST_PNTTM — DATE
- FRST_REGISTER_ID — varchar2(20) — NOT NULL
- LAST_UPDT_PNTTM — DATE
- LAST_UPDUSR_ID — varchar2(20)
LETTNEMPLYRINFO
- EMPLYR_ID — varchar2(20) — Primary key — NOT NULL
- ORGNZT_ID — char(20) — Foreign key → LETTNORGNZTINFO.ORGNZT_ID
- USER_NM — varchar2(60) — NOT NULL
- PASSWORD — varchar2(200) — NOT NULL
- EMPL_NO — varchar2(20)
- IHIDNUM — varchar2(200)
- SEXDSTN_CODE — char(1)
- BRTHDY — char(20)
- FXNUM — varchar2(20)
- HOUSE_ADRES — varchar2(100)
- PASSWORD_HINT — varchar2(100) — NOT NULL
- PASSWORD_CNSR — varchar2(100) — NOT NULL
- HOUSE_END_TELNO — varchar2(4)
- AREA_NO — varchar2(4)
- DETAIL_ADRES — varchar2(100)
- ZIP — varchar2(6)
- OFFM_TELNO — varchar2(20)
- MBTLNUM — varchar2(20)
- EMAIL_ADRES — varchar2(50)
- OFCPS_NM — varchar2(60)
- HOUSE_MIDDLE_TELNO — varchar2(4)
- GROUP_ID — char(20) — Foreign key → LETTNAUTHORGROUPINFO.GROUP_ID
- PSTINST_CODE — char(8)
- EMPLYR_STTUS_CODE — varchar2(15) — NOT NULL
- ESNTL_ID — char(20) — NOT NULL
- CRTFC_DN_VALUE — varchar2(20)
- SBSCRB_DE — DATE
LETTNENTRPRSMBER
- ENTRPRS_MBER_ID — varchar2(20) — Primary key — NOT NULL
- ENTRPRS_SE_CODE — char(15)
- BIZRNO — varchar2(10)
- JURIRNO — varchar2(13)
- CMPNY_NM — varchar2(60) — NOT NULL
- CXFC — varchar2(50)
- ZIP — varchar2(6)
- ADRES — varchar2(100)
- ENTRPRS_MIDDLE_TELNO — varchar2(4)
- FXNUM — varchar2(20)
- INDUTY_CODE — char(15)
- APPLCNT_NM — varchar2(50) — NOT NULL
- APPLCNT_IHIDNUM — varchar2(200)
- SBSCRB_DE — DATE
- ENTRPRS_MBER_STTUS — varchar2(15)
- ENTRPRS_MBER_PASSWORD — varchar2(200) — NOT NULL
- ENTRPRS_MBER_PASSWORD_HINT — varchar2(100) — NOT NULL
- ENTRPRS_MBER_PASSWORD_CNSR — varchar2(100) — NOT NULL
- GROUP_ID — char(20) — Foreign key → LETTNAUTHORGROUPINFO.GROUP_ID
- DETAIL_ADRES — varchar2(100)
- ENTRPRS_END_TELNO — varchar2(4)
- AREA_NO — varchar2(4)
- APPLCNT_EMAIL_ADRES — varchar2(50)
- ESNTL_ID — char(20) — NOT NULL
LETTNFILE
- ATCH_FILE_ID — char(20) — Primary key — NOT NULL
- CREAT_DT — DATE — NOT NULL
- USE_AT — char(1)
LETTNFILEDETAIL
- FILE_SN — number(10,0) — Primary key — NOT NULL
- ATCH_FILE_ID — char(20) — Foreign key → LETTNFILE.ATCH_FILE_ID — NOT NULL
- FILE_STRE_COURS — varchar2(2000) — NOT NULL
- STRE_FILE_NM — varchar2(255) — NOT NULL
- ORIGNL_FILE_NM — varchar2(255)
- FILE_EXTSN — varchar2(20) — NOT NULL
- FILE_CN — CLOB
- FILE_SIZE — number(8,0)
LETTNGNRLMBER
- MBER_ID — varchar2(20) — Primary key — NOT NULL
- PASSWORD — varchar2(200) — NOT NULL
- PASSWORD_HINT — varchar2(100) — NOT NULL
- PASSWORD_CNSR — varchar2(100) — NOT NULL
- IHIDNUM — varchar2(200)
- MBER_NM — varchar2(50) — NOT NULL
- ZIP — varchar2(6)
- ADRES — varchar2(100)
- AREA_NO — varchar2(4)
- MBER_STTUS — varchar2(15)
- DETAIL_ADRES — varchar2(100)
- END_TELNO — varchar2(4)
- MBTLNUM — varchar2(20)
- GROUP_ID — char(20) — Foreign key → LETTNAUTHORGROUPINFO.GROUP_ID
- MBER_FXNUM — varchar2(20)
- MBER_EMAIL_ADRES — varchar2(50)
- MIDDLE_TELNO — varchar2(4)
- SBSCRB_DE — DATE
- SEXDSTN_CODE — char(1)
- ESNTL_ID — char(20) — NOT NULL
LETTNORGNZTINFO
- ORGNZT_ID — char(20) — Primary key — NOT NULL
- ORGNZT_NM — varchar2(20) — NOT NULL
- ORGNZT_DC — varchar2(100)
LETTNSCHDULINFO
- SCHDUL_ID — char(20) — Primary key — NOT NULL
- SCHDUL_SE — char(1)
- SCHDUL_DEPT_ID — varchar2(20)
- SCHDUL_KND_CODE — varchar2(20)
- SCHDUL_BEGINDE — char(20)
- SCHDUL_ENDDE — char(20)
- SCHDUL_NM — varchar2(255)
- SCHDUL_CN — varchar2(2500)
- SCHDUL_PLACE — varchar2(255)
- SCHDUL_IPCR_CODE — char(1)
- SCHDUL_CHARGER_ID — varchar2(20)
- ATCH_FILE_ID — char(20)
- FRST_REGIST_PNTTM — DATE
- FRST_REGISTER_ID — varchar2(20)
- LAST_UPDT_PNTTM — DATE
- LAST_UPDUSR_ID — varchar2(20)
- REPTIT_SE_CODE — char(3)
LETTNTMPLATINFO
- TMPLAT_ID — char(20) — Primary key — NOT NULL
- TMPLAT_NM — varchar2(255)
- TMPLAT_COURS — varchar2(2000)
- USE_AT — char(1)
- TMPLAT_SE_CODE — char(6)
- FRST_REGISTER_ID — varchar2(20)
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — varchar2(20)
- LAST_UPDT_PNTTM — DATE