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)