ppt
테이블 (11)
공고 (Announcement)
- anm_no_seq — NUMBER(10) — 기본 키 — NOT NULL
- anm_upload_date — DATE — NOT NULL
- anm_title — VARCHAR2(100) — NOT NULL
- anm_content — VARCHAR2(1000) — NOT NULL
- anm_file_loca — VARCHAR2(300)
- anm_view_cnt — NUMBER
- anm_degree — VARCHAR2(50) — NOT NULL
- anm_start — DATE — NOT NULL
- anm_end — DATE — NOT NULL
- anm_period — VARCHAR2(30) — NOT NULL
- anm_year — VARCHAR2(30) — NOT NULL
- anm_division — VARCHAR2(50) — NOT NULL
- anm_file — VARCHAR2(300)
- anm_file_real — VARCHAR2(300)
공지사항 (Notice)
- NOTICE_NUMBER_SEQ — NUMBER(10) — 기본 키 — NOT NULL
- NOTICE_TITLE — VARCHAR2(50) — NOT NULL
- NOTICE_WRITER — VARCHAR2(20) — NOT NULL
- NOTICE_CONTENT — VARCHAR2(3000) — NOT NULL
- NOTICE_DATE — DATE — NOT NULL
- NOTICE_FILES — VARCHAR2(300) — NOT NULL
- NOTICE_HITS — NUMBER(10) — NOT NULL
- NOTICE_FILE_REAL — VARCHAR2(300)
- anm_no_seq — NUMBER(10) — 외래 키 → 공고.anm_no_seq — NOT NULL
기관 정보 (Ins)
- INS_NUM — NUMBER(30) — 기본 키 — NOT NULL
- INS_NAME — VARCHAR(30) — NOT NULL
- INS_PHONE — VARCHAR(30) — NOT NULL
- INS_FAXNUM — VARCHAR(30) — NOT NULL
- INS_ADDR — VARCHAR(50) — NOT NULL
- INS_ADDR_DETAIL — VARCHAR(50) — NOT NULL
- INS_RGSTR — DATE — NOT NULL
- INS_RLS — DATE
- JOINID — VARCHAR2(20) — 외래 키 → 회원 기본.JOINID — NOT NULL
기관 추천 조력자 (Instt)
- INSTT_NUM_SEQ — NUMBER(10) — 기본 키 — NOT NULL
- INSTT_NAME — VARCHAR2(50) — NOT NULL
- INSTT_SOC_NUM — VARCHAR2(20) — NOT NULL
- INSTT_HOME_NUM — VARCHAR2(20)
- INSTT_PHONE_NUM — VARCHAR2(20) — NOT NULL
- INSTT_JOB — VARCHAR2(50) — NOT NULL
- INSTT_EMAIL — VARCHAR2(50) — NOT NULL
- INSTT_SRTTN — VARCHAR2(50) — NOT NULL
- INSTT_DTL_SRTTN — VARCHAR2(50) — NOT NULL
- INSTT_YEAR — VARCHAR2(20)
- INSTT_BSNS_NUM — VARCHAR2(30) — NOT NULL
- INSTT_FAX — VARCHAR2(20) — NOT NULL
- INSTT_OFC_NAME — VARCHAR2(50) — NOT NULL
- INSTT_ACAD_BACK — VARCHAR2(500) — NOT NULL
- INSTT_CARRER — VARCHAR2(500) — NOT NULL
- INSTT_TOTAL_FILE — VARCHAR2(500) — NOT NULL
- INSTT_TOTAL_FILE_REAL — VARCHAR2(500) — NOT NULL
- INSTT_BANK — VARCHAR2(20) — NOT NULL
- INSTT_ACC_HOL — VARCHAR2(30) — NOT NULL
- INSTT_BANK_NUM — VARCHAR2(30) — NOT NULL
- INSTT_POST_NUM — VARCHAR2(10) — NOT NULL
- INSTT_ADDR — VARCHAR2(50) — NOT NULL
- INSTT_DTL_ADDR — VARCHAR2(50) — NOT NULL
- ANN_NUM — NUMBER(10)
- INSTT_MEMO — VARCHAR2(1000)
- INSTTSUPPAPPMEMO — VARCHAR2(1000)
- JOINID — VARCHAR2(20) — 외래 키 → 회원 기본.JOINID — NOT NULL
답변 (ANSWER)
- ANS_NUMBER_SEQ — NUMBER(10) — 기본 키 — NOT NULL
- FAQ_NUMBER_SEQ — NUMBER(10) — 외래 키 → 질문.FAQ_NUMBER_SEQ — NOT NULL
- ANS_TITLE — VARCHAR2(50) — NOT NULL
- ANS_WRITER — VARCHAR2(20) — NOT NULL
- ANS_CONTENT — VARCHAR2(1000) — NOT NULL
- ANS_DATE — DATE — NOT NULL
- ANS_FILE — VARCHAR2(300)
- ANS_FILE_REAL — VARCHAR2(300)
- ANS_HITS — NUMBER(10) — NOT NULL
일반 조력자 (GH)
- GH_NUM_SEQ — NUMBER(10) — 기본 키 — NOT NULL
- GH_NAME — VARCHAR2(50) — NOT NULL
- GH_SOC_NUM — VARCHAR2(50) — NOT NULL
- GH_HOME_NUM — VARCHAR2(50)
- GH_PHONE_NUM — VARCHAR2(50) — NOT NULL
- GH_JOB — VARCHAR2(50) — NOT NULL
- GH_EMAIL — VARCHAR2(50) — NOT NULL
- GH_YEAR — VARCHAR2(50)
- GH_SRTTN — VARCHAR2(50) — NOT NULL
- GH_BSNS_NUM — VARCHAR2(50) — NOT NULL
- GH_FAX — VARCHAR2(50)
- GH_OFC_NAME — VARCHAR2(50) — NOT NULL
- GH_OFC_NUM — VARCHAR2(50) — NOT NULL
- GH_ACAD_BACK — VARCHAR2(500) — NOT NULL
- GH_CARRER — VARCHAR2(500) — NOT NULL
- GH_TOTAL_FILE — VARCHAR2(500) — NOT NULL
- GH_TOTAL_FILE_REAL — VARCHAR2(500) — NOT NULL
- GH_BANK — VARCHAR2(50) — NOT NULL
- GH_ACC_HOL — VARCHAR2(50) — NOT NULL
- GH_BANK_NUM — VARCHAR2(50) — NOT NULL
- GH_POST_NUM — VARCHAR2(50) — NOT NULL
- GH_ADDR — VARCHAR2(100) — NOT NULL
- GH_DTL_ADDR — VARCHAR2(100) — NOT NULL
- ANN_NUM — NUMBER(10)
- GH_MEMO — VARCHAR2(1000)
- GHSUPPAPPMEMO — VARCHAR2(1000)
- GH_DTL_SRTTN — VARCHAR2(30)
- anm_title — VARCHAR2(100)
- anm_div — VARCHAR2(100)
- anm_degree — VARCHAR2(50) — NOT NULL
- gh_qualify — VARCHAR2(2) — NOT NULL
- JOINID — VARCHAR2(20) — 외래 키 → 회원 기본.JOINID — NOT NULL
질문 (FAQ)
- FAQ_NUMBER_SEQ — NUMBER(10) — 기본 키 — NOT NULL
- FAQ_TITLE — VARCHAR2(50) — NOT NULL
- FAQ_CONTENT — VARCHAR2(1000) — NOT NULL
- FAQ_DATE — DATE — NOT NULL
- FAQ_HIT — NUMBER(5) — NOT NULL
- FAQ_FILE — VARCHAR2(300)
- FAQ_FILE_REAL — VARCHAR(300)
- FAQ_HITS — NUMBER(10) — NOT NULL
- JOINID — VARCHAR2(20) — 외래 키 → 회원 기본.JOINID — NOT NULL
통번역인 (TS)
- TS_NUM_SEQ — NUMBER(10) — 기본 키 — NOT NULL
- TS_NAME — VARCHAR2(30) — NOT NULL
- TS_SOC_NUM — VARCHAR2(20) — NOT NULL
- TS_HOME_NUM — VARCHAR2(20)
- TS_PHONE_NUM — VARCHAR2(20) — NOT NULL
- TS_JOB — VARCHAR2(50) — NOT NULL
- TS_EMAIL — VARCHAR2(50) — NOT NULL
- TS_EXPRT — VARCHAR2(50) — NOT NULL
- TS_LNGG — VARCHAR2(50) — NOT NULL
- TS_DSG_CRT — VARCHAR2(100) — NOT NULL
- TS_ACTIVE_AREA — VARCHAR2(100) — NOT NULL
- TS_ACAD_BACK — VARCHAR2(500) — NOT NULL
- TS_CARRER — VARCHAR2(500) — NOT NULL
- TS_TOTAL_FILE — VARCHAR2(500) — NOT NULL
- TS_TOTAL_FILE_REAL — VARCHAR2(500) — NOT NULL
- TS_BANK — VARCHAR2(20) — NOT NULL
- TS_ACC_HOL — VARCHAR2(30) — NOT NULL
- TS_BANK_NUM — VARCHAR2(30) — NOT NULL
- TS_POST_NUM — VARCHAR2(10) — NOT NULL
- TS_ADDR — VARCHAR2(100) — NOT NULL
- TS_DTL_ADDR — VARCHAR2(100) — NOT NULL
- ANN_NUM — NUMBER(10)
- TS_MEMO — VARCHAR2(1000)
- TSSUPPAPPMEMO — VARCHAR2(1000)
- anm_title — VARCHAR2(100)
- anm_div — VARCHAR2(100)
- anm_degree — VARCHAR2(50) — NOT NULL
- ts_unqualify — VARCHAR2(2) — NOT NULL
- ts_qualify — VARCHAR2(2) — NOT NULL
- JOINID — VARCHAR2(20) — 외래 키 → 회원 기본.JOINID — NOT NULL
평정기준표 (RatingCriteria)
- RC_NUM_SEQ — NUMBER(10) — 기본 키 — NOT NULL
- RC_APC_NAME — VARCHAR2(50) — NOT NULL
- RC_TOTAL_CAREER — VARCHAR2(20)
- RC_LOCAL_CAREER — VARCHAR2(20)
- RC_OFFICE_LOCA — VARCHAR2(50) — NOT NULL
- RC_OFFICE_ADDR — VARCHAR2(300)
- RC_PERSONALY_EVALUATION — VARCHAR2(10) — NOT NULL
- RC_INTERVIEW_EVALUATION — VARCHAR2(10) — NOT NULL
- RC_CERITIFICATION_NAME1 — VARCHAR2(30)
- RC_CERITIFICATION_NAME2 — VARCHAR2(30)
- RC_CERITIFICATION_NAME3 — VARCHAR2(30)
- RC_CERITIFICATION_NAME4 — VARCHAR2(30)
- RC_TOTAL_SCORE — NUMBER — NOT NULL
- RC_APPRAISER_SCORE — NUMBER — NOT NULL
- RC_AJM_JDGE_SCORE — NUMBER
- RC_LAST_TOTAL_SCORE — NUMBER — NOT NULL
- JOINID — VARCHAR2(20) — 외래 키 → 회원 기본.JOINID — NOT NULL
- JOIN_SOCNUM — VARCHAR2(200)
회원 기본 (UserBasic)
- JOINID — VARCHAR2(20) — 기본 키 — NOT NULL
- JOINPERSON — VARCHAR2(2) — NOT NULL
- JOINSOCNUM — VARCHAR2(20) — 외래 키 → 회원 정보.JOINSOCNUM — NOT NULL
- anm_no_seq — NUMBER(10) — 외래 키 → 공고.anm_no_seq — NOT NULL
회원 정보 (UserDetail)
- JOINSOCNUM — VARCHAR2(20) — 기본 키 — NOT NULL
- JOINNAME — VARCHAR2(30) — NOT NULL
- JOINPW — VARCHAR2(30) — NOT NULL
- JOINGEN — VARCHAR2(10) — NOT NULL
- JOINEMAIL — VARCHAR2(50) — NOT NULL
- JOINPHONE — VARCHAR2(20) — NOT NULL
- JOINADDRNUM — VARCHAR2(50) — NOT NULL
- JOINADDRBASIC — VARCHAR2(100) — NOT NULL
- JOINADDRDETAIL — VARCHAR2(100) — NOT NULL
- JOINDATE — DATE — NOT NULL
- JOINRIGHT — VARCHAR2(1) — NOT NULL
- INSNAME — VARCHAR2(20)
- INSSOCNUM — VARCHAR2(20)
- INSADDRNUM — VARCHAR2(100)
- INSADDRBASIC — VARCHAR2(100)
- INSADDRDETAIL — VARCHAR2(100)