Week15

Tables (3)

AgencyInfo (개설시험장정보)

  • ecode (시험일정코드) — char(6) — Foreign key → Fnforcelnfo.ecode — NOT NULL
  • pcode (시험장코드) — char(4) — Foreign key → Placeinfo.pcode — NOT NULL
  • docode (지역코드) — char(2)
  • citycode (시도코드) — char(2)
  • doname (지역명) — varchar(10)
  • cityname (시도명_상의명) — varchar(10)
  • stat (상태코드) — char(1)

Fnforcelnfo (정기시험일정)

  • ecode (시험일정코드) — char(6) — Primary key — NOT NULL
  • jongcode (종목코드) — char(1)
  • jongname (종목명) — varchar(20)
  • eyear (시행년도) — char(4)
  • examlist (회차) — char(1)
  • elevel (등급코드) — char(1)
  • elevelname (등급명) — varchar(4)
  • elevelgap (등급갭) — char(2)
  • typecode (필기실기구분코드) — char(1)
  • typename (필기실기구분명) — char(4)
  • accsdate (방문접수시작일자) — char(8)
  • accedate (방문접수종료일자) — char(8)
  • inetsdate (인터넷접수시작일자) — char(8)
  • inetedate (인터넷접수종료일자) — char(8)
  • printdate (수험표출력일자) — char(8)
  • examdate (시험일자) — char(8)
  • passdate (합격자발표일자) — char(8)
  • exampay (응시료) — number
  • stat (상태코드) — char(1)

Placeinfo (시험장정보)

  • pcode (시험장코드) — char(4) — Primary key — NOT NULL
  • eyear (년도) — char(4)
  • docode (지역코드) — char(2)
  • citycode (시도코드) — char(2)
  • pname (시험장명) — varchar(30)
  • postno (우편번호) — char(5)
  • addr (주소) — varchar(100)
  • mancnt (시험장최대인원) — number
  • yacode (약도코드) — char(4)
  • stat (상태코드) — char(1)