bak

Tables (41)

COMMON_CODE

  • CODE_ID — VARCHAR2(10) — Primary key — NOT NULL — 하위코드
  • CODE_NAME — VARCHAR2(200) — NOT NULL — 하위코드명
  • CODE_NUMBER — VARCHAR2(3) — 순서
  • USE_YN — CHAR(1) — NOT NULL — 사용여부
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID

COMMON_FILE

  • UUID — VARCHAR2(36) — Primary key — NOT NULL — 공통아이디
  • FILE_DESCRIPSION — VARCHAR2(100) — 파일
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자

COMMON_FILE_DETAIL

  • FILE_ID — VARCHAR2(36) — Primary key — NOT NULL — 파일아이디
  • UUID — VARCHAR2(36) — Foreign key → COMMON_FILE.UUID — NOT NULL — 공통아이디
  • FILE_NAME — VARCHAR2(2000) — NOT NULL — 파일이름
  • FILE_SIZE — VARCHAR2(10) — NOT NULL — 파일크기
  • FILE_EXTENSION — VARCHAR2(50) — NOT NULL — 파일확장자
  • FILE_PATH — VARCHAR2(1000) — NOT NULL — 파일경로
  • FILE_DESCRIPTION — VARCHAR2(1000) — 파일메모
  • SYSTEM_CREATED_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATED_USERID — VARCHAR2(32) — NOT NULL — 작성자
  • SYSTEM_UPDATED_DATE — DATE — 수정일자
  • SYSTEM_UPDATED_USERID — VARCHAR2(32) — 수정자
  • MENU_CODE — VARCHAR2(10) — 메뉴코드

COMMON_MENU

  • MENU_CODE — VARCHAR2(100) — Primary key — NOT NULL — 메뉴코드
  • MENU_NAME — VARCHAR2(100) — NOT NULL — 메뉴명
  • MENU_NUMBER — VARCHAR2(3) — NOT NULL — 메뉴순서
  • MENU_LEVEL — VARCHAR2(1) — NOT NULL — 메뉴레벨
  • TOP_MENU_CODE — VARCHAR2(36) — Foreign key → COMMON_MENU.MENU_CODE — 상위
  • URL — VARCHAR2(1000) — NOT NULL — URL
  • USE_YN — CHAR(1) — NOT NULL — 사용여부
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • MENU_SEQUENCE — NUMBER — 메뉴노출순서

COMMON_POPUP

  • POPUP_ID — VARCHAR2(50) — Primary key — NOT NULL — 팝업ID
  • POPUP_INPUT_INDEX — VARCHAR2(3) — Primary key — NOT NULL — 팝업
  • POPUP_NAME — VARCHAR2(100) — NOT NULL — 팝업이름
  • POPUP_INPUT_ID — VARCHAR2(100) — NOT NULL — 팝업
  • POPUP_LABEL_NAME — VARCHAR2(100) — NOT NULL — 팝업
  • POPUP_SEARCH_BUTTON_ID — VARCHAR2(100) — NOT NULL — 팝업
  • POPUP_TYPE — VARCHAR2(2) — NOT NULL — 팝업
  • POPUP_TYPE_NAME — VARCHAR2(10) — 팝업
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 생성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID

FEE_MASTER

  • FEE_NUMBER — VARCHAR2(36) — Primary key — NOT NULL — 수수료그룹번호
  • FEE_PAYMENT_YN — CHAR(1) — NOT NULL — 납부여부
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자아이디
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자아이디
  • SYSTEM_UPDATE_DATE — DATE — 수정일자

FEE_MASTER_DETAIL

  • FEE_ID — VARCHAR2(36) — Primary key — NOT NULL — 수수료번호
  • FEE_NUMBER — VARCHAR2(36) — Foreign key → FEE_MASTER.FEE_NUMBER — NOT NULL — 수수료그룹번호
  • FEE_TYPE_CODE — VARCHAR2(3) — Foreign key → FEE_TYPE.FEE_TYPE_CODE — NOT NULL — 금액코드
  • FEE_AMOUNT — NUMBER(10) — NOT NULL — 수수료금액
  • FEE_DUE_YMD — CHAR(8) — NOT NULL — 납부기한
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자아이디
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자아이디
  • SYSTEM_UPDATE_DATE — DATE — 수정일자

FEE_TYPE

  • FEE_TYPE_CODE — VARCHAR2(3) — Primary key — NOT NULL — 금액코드
  • FEE_NAME — VARCHAR2(50) — NOT NULL — 금액명
  • FEE_AMOUNT — VARCHAR2(10) — NOT NULL — 금액
  • FEE_DESCRIPTION — VARCHAR2(50) — 내용

FILE_SAFETY_INSPECTION

  • FILE_ID — VARCHAR2(36) — Primary key — NOT NULL — 파일아이디
  • UUID — VARCHAR2(36) — Foreign key → COMMON_FILE.UUID — NOT NULL — 공통아이디
  • FILE_NAME — VARCHAR2(2000) — NOT NULL — 파일이름
  • FILE_SIZE — VARCHAR2(10) — NOT NULL — 파일크기
  • FILE_EXTENSION — VARCHAR2(50) — NOT NULL — 파일확장자
  • FILE_PATH — VARCHAR2(1000) — NOT NULL — 파일경로
  • FILE_DESCRIPTION — VARCHAR2(1000) — 파일메모
  • SYSTEM_CREATED_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATED_USERID — VARCHAR2(32) — NOT NULL — 작성자
  • SYSTEM_UPDATED_DATE — DATE — 수정일자
  • SYSTEM_UPDATED_USERID — VARCHAR2(32) — 수정자

MANUFACTURE_CERTIFICATE

  • VEHICLE_IDENTIFICATION_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 차대번호
  • VEHICLE_TYPE_CODE — VARCHAR2(10) — NOT NULL — 차종(공통코드)
  • VEHICLE_NAME — VARCHAR2(100) — NOT NULL — 차명
  • MODEL_YEAR — CHAR(4) — NOT NULL — 연식(모델연도)
  • GROSS_VEHICLE_WEIGHT — NUMBER(6) — NOT NULL — 총중량
  • GROSS_VEHICLE_WEIGHT2 — NUMBER(6) — 총중량
  • RIDING_CAPACITY — NUMBER(2) — NOT NULL — 승차정원(제원표의
  • RIDING_CAPACITY2 — NUMBER(2) — +좌석)
  • MAXIMUM_LOADING_CAPACITY — NUMBER(6) — NOT NULL — 최대적재량
  • MAXIMUM_LOADING_CAPACITY2 — NUMBER(6) — 최대적재량
  • POWER_UNIT_MODEL — VARCHAR2(50) — NOT NULL — 원동기형식
  • POWER_UNIT_TYPE_CODE — VARCHAR2(10) — 원동기
  • ENGINE_TOTAL_DISPLACEMENT — NUMBER(6) — 원동기내연기관총배기량
  • ENGINE_NUMBER_OF_CYLINDERS — NUMBER(2) — 원동기내연기관기통수
  • ENGINE_MAXIMUM_POWER — VARCHAR2(20) — 원동기
  • MOTOR_MAXIMUM_POWER — VARCHAR2(20) — 원동기
  • MOTOR_NUMBER — NUMBER(2) — 원동기
  • BATTERY_RATED_VOLTAGE_CAPACITY — VARCHAR2(20) — 원동기
  • BATTERY_NUMBER — NUMBER(2) — 원동기
  • FUEL_CELL_NUMBER — NUMBER(2) — 원동기
  • FUEL_CELL_MAXIMUM_POWER — VARCHAR2(20) — 원동기
  • TRANSFER_YMD — CHAR(8) — 양도연월일
  • VEHICLE_COLOR_CODE — VARCHAR2(10) — NOT NULL — 색상(공통코드)
  • BODY_LENGTH — NUMBER(6) — NOT NULL — 길이
  • BODY_WIDTH — NUMBER(6) — NOT NULL — 너비
  • BODY_HEIGHT — NUMBER(6) — NOT NULL — 높이
  • ASBESTOS_USE_YN — CHAR(1) — NOT NULL — 제동장치석면사용여부(공통코드)
  • PRODUCTION_YMD — CHAR(8) — NOT NULL — 제작연원일
  • LICENSE_PLATE_SIZE_CODE — VARCHAR2(10) — NOT NULL — 등록번호판규격(공통코드)
  • SUPPLY_PRICE — NUMBER(15) — NOT NULL — 공급가액(부가세제외)
  • TRANSFEREE_NAME — VARCHAR2(50) — NOT NULL — 양수인성명
  • TRANSFEREE_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — 양수인주민등록번호
  • TRANSFEREE_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — 양수인법인등록번호
  • TRANSFEREE_USE_ADDRESS — VARCHAR2(100) — NOT NULL — 양수인주소
  • TRANSFEREE_USE_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 양수인상세주소
  • TRANSFEREE_USE_POSTAL_CODE — CHAR(5) — NOT NULL — 양수인우편번호
  • VEHICLE_JOINT_OWNER_YN — CHAR(1) — NOT NULL — 양수인
  • TRANSFEREE_DIRECT_VEHICLE_REGISTRATION_YN — CHAR(1) — NOT NULL — 양수인직접신규등록신청여부(직접신청/제작자
  • ISSUANCE_YMD — CHAR(8) — NOT NULL — 제작증발행일(현재
  • LOW_EMISSION_VEHICLE_TYPE_CODE — VARCHAR2(10) — 저공해자동차종류(공통코드)
  • LOW_EMISSION_VEHICLE_FUEL_TYPE — VARCHAR2(10) — 저공해자동차사용연료(종류)(공통코드)
  • MAKER_NAME — VARCHAR2(50) — NOT NULL — 제작자업체명
  • MAKER_OWNER_NAME — VARCHAR2(50) — NOT NULL — 제작자대표자
  • MAKER_COMPANY_REGISTRATION_NUMBER — VARCHAR2(13) — 제작자사업자등록번호
  • BUSINESS_ADDRESS — VARCHAR2(100) — NOT NULL — 제작자소재지주소
  • BUSINESS_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 제작자소재지상세주소
  • BUSINESS_POSTAL_CODE — CHAR(5) — NOT NULL — 제작자소재지우편번호
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • MAKER_NUMBER — VARCHAR2(14) — Foreign key → VEHICLE_MAKER_MASTER.MAKER_NUMBER — NOT NULL — 제작자번호
  • SPECIFICATION_NUMBER — VARCHAR2(17) — Foreign key → SPECIFICATION_MASTER.SPECIFICATION_NUMBER — NOT NULL — 제원관리번호
  • POWE_UNIT_TYPE_CODE — VARCHAR2(10) — NOT NULL — 원동기
  • TRANSFEREE_PHONE_NUMBER — VARCHAR2(15) — 양수인전화번호

REGISTRATION_RECORD_DETAIL

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • OFFICE_CODE — VARCHAR2(7) — Primary key — NOT NULL — 등록관청
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 히스토리고유번호
  • MAIN_REGISTRATION_NUMBER — VARCHAR2(12) — 주등록
  • SUB_REGISTRATION_NUMBER — VARCHAR2(12) — 부가등록
  • CONTENT — VARCHAR2(2000) — 사항란
  • RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — 주민등록번호
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID

REGISTRATION_RECORD_ISSUANCE_APPLICATION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • OFFICE_CODE — VARCHAR2(7) — Primary key — NOT NULL — 등록관청
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 신청상태(공통)
  • RECEIPT_DATE — DATE — NOT NULL — 접수일시
  • RECEIPT_TYPE_CODE — VARCHAR2(10) — NOT NULL — 접수구분(공통)
  • APPLICANT_NAME — VARCHAR2(50) — NOT NULL — 신청인
  • APPLICANT_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 신청인
  • APPLICANT_ADDRESS — VARCHAR2(100) — NOT NULL — 신청인주소
  • APPLICANT_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 신청인주소상세
  • APPLICANT_POSTAL_CODE — CHAR(5) — NOT NULL — 신청인우편번호
  • OWNER_NAME — VARCHAR2(50) — NOT NULL — 소유자명
  • OWNER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 소유자
  • VEHICLE_USE_ADDR — VARCHAR2(100) — NOT NULL — 자동차사용본거지주소
  • VEHICLE_USE_ADDR_DETAIL — VARCHAR2(100) — NOT NULL — 자동차사용본거지주소상세
  • VEHICLE_USE_POSTAL_CODE — CHAR(5) — NOT NULL — 자동차사용본거지우편번호
  • RECORD_APPLICATION_TYPE_CODE — VARCHAR2(10) — NOT NULL — 신청종류(공통)
  • ALPHA_ISSUANCE_COUNT — NUMBER(2) — NOT NULL — 갑부발급수량
  • BETA_ISSUANCE_COUNT — NUMBER(2) — NOT NULL — 을부발급수량
  • RECEIVING_TYPE_CODE — VARCHAR2(10) — NOT NULL — 수령방법(공통)
  • RECEIVING_OFFICE_CODE — VARCHAR2(10) — NOT NULL — 수량기관
  • VEHICLE_INFO_DISPLAY_CODE — VARCHAR2(10) — NOT NULL — 자동차등록내역표시(공통)
  • OWNER_RESIDENT_REGISTRATION_NUMBER_DISPLAY_CODE — VARCHAR2(10) — NOT NULL — 소유자주민번호표시코드(공통)
  • MORTGAGEE_RESIDENT_REGISTRATION_NUMBER_DISPLAY_CODE — VARCHAR2(10) — NOT NULL — 저당권자주민번호표시코드(공통)
  • RECORD_VIEW_CODE — VARCHAR2(10) — NOT NULL — 열람부분(공통)
  • ISSUANCE_DATE — DATE — 발급일시
  • VEHICLE_IDENTIFICATION_NUMBER — VARCHAR2(17) — NOT NULL — 차대번호
  • SYSTEM_CREATED_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATED_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATED_DATE — DATE — 수정일자
  • SYSTEM_UPDATED_USERID — VARCHAR2(32) — 수정자ID
  • RECORD_USAGE_CODE — VARCHAR2(10) — NOT NULL — 용도(발급
  • STAKEHOLDER_YN — CHAR(1) — NOT NULL — 이해관계자여부
  • STAKEHOLDER_CODE — VARCHAR2(10) — 이해관계자구분(공통)
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 히스토리고유번호
  • VEHICLE_NUMBER — VARCHAR2(13) — 자동차등록번호

SAFETY_INSPECTION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • VEHICLE_IDENTIFICATION_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 차대번호
  • SPECIFICATION_TABLE_NUMBER — VARCHAR2(20) — Foreign key → SPECIFICATION_TABLE.SPECIFICATION_TABLE_NUMBER — 제원표번호
  • RECEIPT_DATE — DATE — NOT NULL — 접수일시
  • ISSUANCE_DATE — DATE — 발급일시
  • MAKER_NAME — VARCHAR2(50) — NOT NULL — 제작자명
  • MAKER_NUMBER — VARCHAR2(14) — NOT NULL — 제작자등록번호
  • MAKER_ADDRESS — VARCHAR2(100) — NOT NULL — 제작자주소
  • MAKER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 제작자주소상세
  • MAKER_POSTAL_CODE — CHAR(5) — NOT NULL — 제작자우편번호
  • MAKER_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 제작자전화번호
  • VEHICLE_NAME — VARCHAR2(100) — NOT NULL — 자동차차명
  • VEHICLE_MODEL_NUMBER — VARCHAR2(100) — NOT NULL — 형식
  • VEHICLE_TYPE_CODE — VARCHAR2(10) — NOT NULL — 자동차차종
  • POWER_UNIT_MODEL — VARCHAR2(50) — NOT NULL — 원동기형식
  • SPECIFICATION_NUMBER — VARCHAR2(17) — Foreign key → SPECIFICATION_MASTER.SPECIFICATION_NUMBER — 제원관리번호
  • TARGET_COUNT — NUMBER(5) — NOT NULL — 검사신청대수
  • INSPECTION_LOCATION_CODE — VARCHAR2(10) — NOT NULL — 검사받을장소
  • SAFETY_INSPECTION_TYPE_CODE — VARCHAR2(10) — NOT NULL — 안전검사유형(공통코드(최초
  • APPLICATION_YMD — CHAR(8) — NOT NULL — 안전검사신청일자
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 접수처리상태
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일키
  • CERTIFICATION_NUMBER — VARCHAR2(20) — 안전검사증문서번호
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • REJECTION_REMARK — VARCHAR2(1000) — 반려사유
  • NONCONFORMITY_REMARK — VARCHAR2(1000) — 부적합사유
  • REINSPECTION_YN — CHAR(1) — NOT NULL — 재검사여부
  • SCHEDULED_YMD — CHAR(8) — NOT NULL — 검사예정일
  • INSPECTION_VALID_START_YMD — CHAR(8) — 검사유효기간
  • INSPECTION_VALID_END_YMD — CHAR(8) — 검사유효기간
  • LATEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • SAFETY_INSPECTION_RESULT_CODE — VARCHAR2(10) — 판정
  • POWER_UNIT_TYPE_CODE — VARCHAR2(10) — 원동기

SPECIFICATION_MASTER

  • SPECIFICATION_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 제원관리번호
  • MAKER_NUMBER — VARCHAR2(14) — NOT NULL — 제작자번호
  • SPECIFICATION_NUMBER_OLD — VARCHAR2(17) — 변경전차종제원관리번호
  • ORIGINAL_MAKER_NUMBER — VARCHAR2(14) — 최초자동차제작자
  • VEHICLE_DESCRIPTION — VARCHAR2(1000) — 자동차의개략적인설명
  • APPLICATION_YMD — CHAR(8) — 제원통보신청일
  • ISSUANCE_NUMBER — VARCHAR2(20) — 제원관리번호통보서
  • ISSUANCE_DATE — DATE — 제원관리번호통보서
  • MAKER_NAME — VARCHAR2(50) — 제작자명
  • ORIGINAL_MAKER_NAME — VARCHAR2(50) — 원제작자명
  • MAKE_COUNTRY_CODE — VARCHAR2(10) — 제작국가코드
  • VEHICLE_NAME — VARCHAR2(100) — NOT NULL — 차명
  • VEHICLE_MODEL_NUMBER — VARCHAR2(100) — 형식(번호)((WINGS-280)자동차
  • FRAME_BODY_SHAPE_CODE — VARCHAR2(10) — 차대
  • RIDING_CAPACITY — NUMBER(2) — NOT NULL — 승차정원
  • RIDING_CAPACITY2 — NUMBER(2) — 승차정원
  • VEHICLE_TYPE_CODE — VARCHAR2(10) — 자동차종별(공통코드(
  • VEHICLE_CATEGORY_CODE — VARCHAR2(10) — 자동차유형(공통코드)
  • VEHICLE_CLASS_CODE — VARCHAR2(10) — 구분(공통코드)
  • SPECIFICATION_VEHICLE_PURPOSE_CODE — VARCHAR2(10) — 차량
  • VEHICLE_WEIGHT — NUMBER(6) — 차량중량
  • VEHICLE_WEIGHT2 — NUMBER(6) — 차량중량
  • MAXIMUM_LOADING_CAPACITY — NUMBER(6) — NOT NULL — 최대적재량
  • MAXIMUM_LOADING_CAPACITY2 — NUMBER(6) — 최대적재량
  • GROSS_VEHICLE_WEIGHT — NUMBER(6) — NOT NULL — 차량총중량
  • GROSS_VEHICLE_WEIGHT2 — NUMBER(6) — 차량총중량
  • BODY_LENGTH — NUMBER(6) — NOT NULL — 차체길이
  • BODY_LENGTH2 — NUMBER(6) — 차체길이
  • BODY_WIDTH — NUMBER(6) — NOT NULL — 차체너비
  • BODY_WIDTH2 — NUMBER(6) — 차체너비
  • BODY_HEIGHT — NUMBER(6) — NOT NULL — 차체높이
  • BODY_HEIGHT2 — NUMBER(6) — 차체높이
  • LOADING_SPACE_LENGTH — NUMBER(6) — 하대내측지수길이
  • LOADING_SPACE_LENGTH2 — NUMBER(6) — 하대내측지수길이2
  • LOADING_SPACE_WIDTH — NUMBER(6) — 하대내측지수너비
  • LOADING_SPACE_WIDTH2 — NUMBER(6) — 하대내측지수너비2
  • LOADING_SPACE_HEIGHT — NUMBER(6) — 하대내측지수높이
  • LOADING_SPACE_HEIGHT2 — NUMBER(6) — 하대내측지수높이2
  • LOADING_SPACE_OFFSET — NUMBER(6) — 하대옵셋트
  • UNLOADED_FF_AXLE_WEIGHT — NUMBER(6) — 공차시하중분포전전축
  • UNLOADED_FF_AXLE_WEIGHT2 — NUMBER(6) — 공차시하중분포전전축2
  • UNLOADED_FR_AXLE_WEIGHT — NUMBER(6) — 공차시하중분포전후축
  • UNLOADED_FR_AXLE_WEIGHT2 — NUMBER(6) — 공차시하중분포전후축2
  • UNLOADED_RF_AXLE_WEIGHT — NUMBER(6) — 공차시하중분포후전축
  • UNLOADED_RF_AXLE_WEIGHT2 — NUMBER(6) — 공차시하중분포후전축2
  • UNLOADED_RM_AXLE_WEIGHT — NUMBER(6) — 공차시하중분포후중축
  • UNLOADED_RM_AXLE_WEIGHT2 — NUMBER(6) — 공차시하중분포후중축2
  • UNLOADED_RR_AXLE_WEIGHT — NUMBER(6) — 공차시하중분포후후축
  • UNLOADED_RR_AXLE_WEIGHT2 — NUMBER(6) — 공차시하중분포후후축2
  • LOADED_FF_AXLE_WEIGHT — NUMBER(6) — 적차시하중분포전전축
  • LOADED_FF_AXLE_WEIGHT2 — NUMBER(6) — 적차시하중분포전전축2
  • LOADED_FR_AXLE_WEIGHT — NUMBER(6) — 적차시하중분포전후축
  • LOADED_FR_AXLE_WEIGHT2 — NUMBER(6) — 적차시하중분포전후축2
  • LOADED_RF_AXLE_WEIGHT — NUMBER(6) — 적차시하중분포후전축
  • LOADED_RF_AXLE_WEIGHT2 — NUMBER(6) — 적차시하중분포후전축2
  • LOADED_RM_AXLE_WEIGHT — NUMBER(6) — 적차시하중분포후중축
  • LOADED_RM_AXLE_WEIGHT2 — NUMBER(6) — 적차시하중분포후중축2
  • LOADED_RR_AXLE_WEIGHT — NUMBER(6) — 적차시하중분포후후축
  • LOADED_RR_AXLE_WEIGHT2 — NUMBER(6) — 적차시하중분포후후축2
  • FF_AXLE_MAXIMUM_DESIGN_WEIGHT — NUMBER(6) — 전전축설계허용하중
  • … +57

SPECIFICATION_NOTIFICATION_APPLICATION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • MAKER_NAME — VARCHAR2(50) — NOT NULL — 제작자명
  • MAKER_ADDRESS — VARCHAR2(100) — NOT NULL — 제작자주소
  • MAKER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 제작자주소상세
  • MAKER_POSTAL_CODE — CHAR(5) — NOT NULL — 제작자우편번호
  • MAKER_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 제작자전화번호
  • VEHICLE_NAME — VARCHAR2(100) — NOT NULL — 차명
  • VEHICLE_MODEL_NUMBER — VARCHAR2(32) — NOT NULL — 형식(번호)(WINGS-280)자동차
  • POWER_UNIT_MODEL — VARCHAR2(50) — NOT NULL — 원동기형식
  • SPECIFICATION_NUMBER_OLD — VARCHAR2(17) — 변경전차종
  • ORIGINAL_MAKER_NUMBER — VARCHAR2(14) — 최초자동차제작자
  • VEHICLE_IDENTIFICATION_NUMBER_SECTION — VARCHAR2(8) — 차대번호군(1~8자리)
  • VEHICLE_DESCRIPTION — VARCHAR2(1000) — 자동차의개략적인설명
  • APPLICATION_YMD — CHAR(8) — NOT NULL — 제원통보신청일
  • LATEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 처리상태(진행중/반려/발급/완료)
  • REJECTION_REMARK — VARCHAR2(1000) — 반려사유
  • DOMESTIC_YN — CHAR(1) — NOT NULL — 수입/국산구분
  • SELF_CERTIFICATION_EXEMPTION_YN — CHAR(1) — NOT NULL — 자기인증면제여부
  • OFFICE_CODE — VARCHAR2(7) — 등록관청(검사소)코드(자기인증
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일키
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • MAKER_NUMBER — VARCHAR2(14) — Foreign key → VEHICLE_MAKER_MASTER.MAKER_NUMBER — NOT NULL — 제작자번호
  • SPECIFICATION_TABLE_NUMBER — VARCHAR2(20) — Foreign key → SPECIFICATION_TABLE.SPECIFICATION_TABLE_NUMBER — NOT NULL — 제원표번호
  • POWER_UNIT_TYPE_CODE — VARCHAR2(10) — 원동기
  • RECEIPT_NAME — VARCHAR2(50) — 신청자명

SPECIFICATION_TABLE

  • SPECIFICATION_TABLE_NUMBER — VARCHAR2(20) — Primary key — NOT NULL — 제원표번호
  • MAKER_NUMBER — VARCHAR2(14) — NOT NULL — 제작자번호
  • MAKER_NAME — VARCHAR2(50) — 제작자명
  • ORIGINAL_MAKER_NAME — VARCHAR2(50) — 원제작자명
  • MAKE_NATIONAL_NO — VARCHAR2(10) — 제작국가코드
  • VEHICLE_NAME — VARCHAR2(100) — NOT NULL — 차명
  • VEHICLE_MODEL_NUMBER — VARCHAR2(100) — 형식
  • FRAME_BODY_SHAPE_CODE — VARCHAR2(10) — 차대
  • RIDING_CAPACITY — NUMBER(2) — NOT NULL — 승차정원
  • RIDING_CAPACITY2 — NUMBER(2) — 승차정원
  • VEHICLE_TYPE_CODE — VARCHAR2(10) — 종별
  • VEHICLE_CATEGORY_CODE — VARCHAR2(10) — 유형
  • VEHICLE_CLASS_CODE — VARCHAR2(10) — 구분
  • SPECIFICATION_VEHICLE_PURPOSE_CODE — VARCHAR2(10) — 차량
  • VEHICLE_WEIGHT — NUMBER(6) — 차량중량
  • VEHICLE_WEIGHT2 — NUMBER(6) — NOT NULL — 안전상허용범위중량
  • MAXIMUM_LOADING_CAPACITY — NUMBER(6) — NOT NULL — 최대적재량
  • MAXIMUM_LOADING_CAPACITY2 — NUMBER(6) — 용적
  • GROSS_VEHICLE_WEIGHT — NUMBER(6) — NOT NULL — 차량총중량
  • GROSS_VEHICLE_WEIGHT2 — NUMBER(6) — 안전상허용범위중량
  • BODY_LENGTH — NUMBER(6) — NOT NULL — 차체길이
  • BODY_LENGTH2 — NUMBER(6) — 모든
  • BODY_WIDTH — NUMBER(6) — NOT NULL — 차체너비
  • BODY_WIDTH2 — NUMBER(6) — 모든
  • BODY_HEIGHT — NUMBER(6) — NOT NULL — 차체높이
  • BODY_HEIGHT2 — NUMBER(6) — 모든
  • LOADING_SPACE_LENGTH — NUMBER(6) — 하대내측지수길이
  • LOADING_SPACE_LENGTH2 — NUMBER(6) — 하대내측지수길이
  • LOADING_SPACE_WIDTH — NUMBER(6) — 하대내측지수너비
  • LOADING_SPACE_WIDTH2 — NUMBER(6) — 하대내측지수너비
  • LOADING_SPACE_HEIGHT — NUMBER(6) — 하대내측지수높이
  • LOADING_SPACE_HEIGHT2 — NUMBER(6) — 하대내측지수높이
  • LOADING_SPACE_OFFSET — NUMBER(6) — 하대옵셋트
  • UNLOADED_FF_AXLE_WEIGHT — NUMBER(6) — 공차시하중분포전전축
  • UNLOADED_FF_AXLE_WEIGHT2 — NUMBER(6) — 공차시하중분포전전축
  • UNLOADED_FR_AXLE_WEIGHT — NUMBER(6) — 공차시하중분포전후축
  • UNLOADED_FR_AXLE_WEIGHT2 — NUMBER(6) — 공차시하중분포전후축
  • UNLOADED_RF_AXLE_WEIGHT — NUMBER(6) — 공차시하중분포후전축
  • UNLOADED_RF_AXLE_WEIGHT2 — NUMBER(6) — 공차시하중분포후전축
  • UNLOADED_RM_AXLE_WEIGHT — NUMBER(6) — 공차시하중분포후중축
  • UNLOADED_RM_AXLE_WEIGHT2 — NUMBER(6) — 공차시하중분포후중축
  • UNLOADED_RR_AXLE_WEIGHT — NUMBER(6) — 공차시하중분포후후축
  • UNLOADED_RR_AXLE_WEIGHT2 — NUMBER(6) — 공차시하중분포후후축
  • LOADED_FF_AXLE_WEIGHT — NUMBER(6) — 적차시하중분포전전축
  • LOADED_FF_AXLE_WEIGHT2 — NUMBER(6) — 적차시하중분포전전축
  • LOADED_FR_AXLE_WEIGHT — NUMBER(6) — 적차시하중분포전후축
  • LOADED_FR_AXLE_WEIGHT2 — NUMBER(6) — 적차시하중분포전후축
  • LOADED_RF_AXLE_WEIGHT — NUMBER(6) — 적차시하중분포후전축
  • LOADED_RF_AXLE_WEIGHT2 — NUMBER(6) — 적차시하중분포후전축
  • LOADED_RM_AXLE_WEIGHT — NUMBER(6) — 적차시하중분포후중축
  • LOADED_RM_AXLE_WEIGHT2 — NUMBER(6) — 적차시하중분포후중축
  • LOADED_RR_AXLE_WEIGHT — NUMBER(6) — 적차시하중분포후후축
  • LOADED_RR_AXLE_WEIGHT2 — NUMBER(6) — 적차시하중분포후후축
  • FF_AXLE_MAXIMUM_DESIGN_WEIGHT — NUMBER(6) — 축별설계허용하중
  • FR_AXLE_MAXIMUM_DESIGN_WEIGHT — NUMBER(6) — 축별설계허용하중
  • RF_AXLE_MAXIMUM_DESIGN_WEIGHT — NUMBER(6) — 축별설계허용하중
  • RM_AXLE_MAXIMUM_DESIGN_WEIGHT — NUMBER(6) — 축별설계허용하중
  • RR_AXLE_MAXIMUM_DESIGN_WEIGHT — NUMBER(6) — 축별설계허용하중
  • WHEEL_BASE — NUMBER(6) — 축간거리
  • MAXIMUM_GROSS_WEIGHT — NUMBER(6) — 제작허용총중량
  • … +49

TECHNOLOGY_REVIEW

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • SPECIFICATION_TABLE_NUMBER — VARCHAR2(20) — Foreign key → SPECIFICATION_TABLE.SPECIFICATION_TABLE_NUMBER — NOT NULL — 제원표번호
  • RECEIPT_DATE — DATE — NOT NULL — 접수일시
  • ISSUANCE_DATE — DATE — 발급일시
  • MAKER_NAME — VARCHAR2(50) — NOT NULL — 제작자명
  • MAKER_NUMBER — VARCHAR2(14) — NOT NULL — 제작자등록번호
  • MAKER_OWNER_NAME — VARCHAR2(50) — NOT NULL — 대표자명
  • MAKER_OWNER_BIRTH_YMD — CHAR(8) — NOT NULL — 대표자생년월일
  • APPLICANT_ADDRESS — VARCHAR2(100) — NOT NULL — 신청인주소
  • APPLICANT_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 신청인주소상세
  • APPLICANT_POSTAL_CODE — CHAR(5) — NOT NULL — 신청인우편번호
  • APPLICANT_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 신청인전화번호
  • APPLICATION_YMD — CHAR(8) — NOT NULL — 신청일자
  • VEHICLE_NAME — VARCHAR2(100) — NOT NULL — 차명
  • VEHICLE_MODEL_NUMBER — VARCHAR2(100) — NOT NULL — 형식
  • VEHICLE_TYPE_CODE — VARCHAR2(10) — NOT NULL — 자동차차종
  • POWER_UNIT_MODEL — VARCHAR2(50) — NOT NULL — 원동기형식
  • ORIGINAL_MAKER_NUMBER — VARCHAR2(14) — 최초제작자
  • MAKE_COUNTRY_CODE — VARCHAR2(10) — NOT NULL — 제작국가
  • ORIGINAL_SPECIFICATION_NUMBER — VARCHAR2(17) — 최초자동차의제원관리번호
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 접수처리상태
  • VEHICLE_SAFETY_INSPECTION_CHECK — VARCHAR2(4000) — 자동차안전검사시주요확인사항
  • CERTIFICATION_NUMBER — VARCHAR2(20) — 기술검토서발급번호
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일
  • REJECTION_REMARK — VARCHAR2(1000) — 반려사유
  • VEHICLE_CONTENT_IDENTIFICATION_CODE — VARCHAR2(10) — 차대번호표기(시행계획)내용의적정성
  • VEHICLE_IDENTIFICATION_NUMBER_SECTION — VARCHAR2(8) — 차대번호군
  • LATEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • APPLICANT_NAME — VARCHAR2(50) — NOT NULL — 신청인
  • ORIGINAL_MAKER_NAME — VARCHAR2(50) — 원제작자명
  • POWER_UNIT_TYPE_CODE — VARCHAR2(10) — 원동기

TEMPORARY_DRIVING_APPLICATION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • OFFICE_CODE — VARCHAR2(7) — NOT NULL — 등록관청
  • RECEIPT_DATE — DATE — NOT NULL — 접수일
  • ISSUANCE_DATE — DATE — 발급일
  • APPLICANT_NAME — VARCHAR2(50) — NOT NULL — 신청인
  • APPLICANT_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 신청인
  • APPLICANT_ADDRESS — VARCHAR2(100) — NOT NULL — 신청인
  • APPLICANT_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 신청인
  • OWNER_POSTAL_CODE — CHAR(5) — NOT NULL — 신청인
  • DRIVER_COMPANY_REGISTRATION_NUMBER — VARCHAR2(13) — 자동차
  • DRIVER_COMPANY_NAME — VARCHAR2(50) — 자동차
  • DRIVER_COMPANY_OWNER_NAME — VARCHAR2(50) — 자동차
  • DRIVER_NAME — VARCHAR2(50) — NOT NULL — 자동차
  • DRIVER_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 사용자
  • DRIVER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — 사용자
  • DRIVER_ADDRESS — VARCHAR2(100) — NOT NULL — 사용자
  • DRIVER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 사용자
  • DRIVER_POSTAL_CODE — CHAR(5) — NOT NULL — 사용자
  • VEHICLE_TYPE_CODE — VARCHAR2(10) — NOT NULL — 차종
  • VEHICLE_NAME — VARCHAR2(100) — NOT NULL — 차명
  • VEHICLE_IDENTIFICATION_NUMBER — VARCHAR2(17) — NOT NULL — 차대번호
  • LICENSE_PLATE_SIZE_CODE — VARCHAR2(10) — NOT NULL — 임시운행허가번호판
  • TEMPORARY_DRIVING_PURPOSE_CODE — VARCHAR2(10) — NOT NULL — 운행목적
  • DRIVING_PERIOD_START_YMD — CHAR(8) — NOT NULL — 운행기간
  • DRIVING_PERIOD_END_YMD — CHAR(8) — NOT NULL — 운행기간
  • APPLICATION_YMD — CHAR(8) — NOT NULL — 신청일
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 처리상태
  • REJECTION_REMARK — VARCHAR2(1000) — 반려사유
  • LATEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID

TEMPORARY_DRIVING_MASTER

  • RECEIPT_NUMBER — VARCHAR2(17) — Foreign key → TEMPORARY_DRIVING_APPLICATION.RECEIPT_NUMBER — NOT NULL — 접수번호
  • DRIVER_COMPANY_NAME — VARCHAR2(50) — 자동차
  • DRIVER_COMPANY_OWNER_NAME — VARCHAR2(50) — 자동차
  • DRIVER_NAME — VARCHAR2(50) — NOT NULL — 자동차
  • DRIVER_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 사용자
  • DRIVER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — 사용자
  • DRIVER_COMPANY_REGISTRATION_NUMBER — VARCHAR2(13) — 자동차
  • DRIVER_USE_ADDRESS — VARCHAR2(100) — NOT NULL — 자동차
  • DRIVER_USE_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 자동차
  • DRIVER_USE_POSTAL_CODE — CHAR(5) — NOT NULL — 자동차
  • VEHICLE_IDENTIFICATION_NUMBER — VARCHAR2(17) — NOT NULL — 차대번호
  • DRIVING_PERIOD_START_YMD — CHAR(8) — NOT NULL — 운행기간
  • DRIVING_PERIOD_END_YMD — CHAR(8) — NOT NULL — 운행기간
  • VEHICLE_NAME — VARCHAR2(100) — NOT NULL — 차명
  • TEMPORARY_DRIVING_PURPOSE_CODE — VARCHAR2(10) — NOT NULL — 운행목적
  • DRIVING_SECTION — VARCHAR2(100) — NOT NULL — 운행구간
  • PERMIT_DATE — DATE — NOT NULL — 허가일
  • ISSUANCE_DATE — DATE — 발급일
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일아이디
  • PERMIT_NUMBER — VARCHAR2(6) — NOT NULL — 허가번호
  • RETURN_DATE — DATE — 임시번호판
  • RETURN_OFFICE_CODE — VARCHAR2(7) — 임시번호판

VEHICLE_CHANGE_APPLICATION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 자동차고유번호
  • VEHICLE_NUMBER — VARCHAR2(13) — NOT NULL — 자동차등록번호
  • OFFICE_CODE — VARCHAR2(7) — NOT NULL — 등록관청코드
  • RECEIPT_DATE — DATE — NOT NULL — 접수일시
  • ISSUANCE_DATE — DATE — 발급일시
  • OWNER_NAME — VARCHAR2(50) — NOT NULL — 소유자명
  • OWNER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — 소유자주민등록번호
  • OWNER_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — 소유자법인등록번호
  • OWNER_ADDRESS — VARCHAR2(100) — NOT NULL — 소유자주소
  • OWNER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 소유자주소상세
  • OWNER_POSTAL_CODE — CHAR(5) — NOT NULL — 소유자우편번호
  • OWNER_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 소유자전화번호
  • OWNER_EMAIL — VARCHAR2(100) — 소유자
  • VEHICLE_COLOR_CODE — VARCHAR2(10) — NOT NULL — 자동차색상
  • VEHICLE_USE_ADDRESS — VARCHAR2(100) — NOT NULL — 자동차사용본거지
  • VEHICLE_USE_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 자동차사용본거지주소상세
  • VEHICLE_USE_POSTAL_CODE — CHAR(5) — NOT NULL — 자동차사용본거지우편번호
  • CHANGE_TYPE_CODE — VARCHAR2(10) — NOT NULL — 변경사항유형
  • CHANGE_YMD — CHAR(8) — NOT NULL — 변경일자
  • CHANGE_BEFORE — VARCHAR2(200) — NOT NULL — 변경전
  • CHANGE_AFTER — VARCHAR2(200) — NOT NULL — 변경후
  • APPLICANT_NAME — VARCHAR2(50) — NOT NULL — 신청인성명
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 신청상태
  • APPLICATION_YMD — CHAR(8) — NOT NULL — 신청일
  • APPLICANT_BIRTH_YMD — CHAR(8) — NOT NULL — 신청인생년월일
  • LATEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • REJECTION_REMARK — VARCHAR2(1000) — 반려사유
  • REMARK — VARCHAR2(2000) — NOT NULL — 등록접수부비고(등록시에
  • ADMINISTRATION_INFO_AGREE_YN — CHAR(1) — NOT NULL — 행정정보공동이용동의여부
  • SUBROGATION_YN — CHAR(1) — 채권자대위
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일키
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • JOINT_OWNER_NUMBER — CHARCHAR2(36) — 공동명의번호
  • SUBROGATION_NAME — VARCHAR2(50) — 채권자
  • SUBROGATION_ADDRESS — VARCHAR2(100) — 채권자
  • SUBROGATION_ADDRESS_DETAIL — VARCHAR2(100) — 채권자
  • SUBROGATION_POSTAL_CODE — CHAR(5) — 채권자
  • SUBROGATION_REASON — VARCHAR2(1000) — 대위원인
  • NEW_VEHICLE_NUMBER — VARCHAR2(13) — 신자동차등록번호
  • VEHICLE_NUMBER_SELECTION_TYPE_CODE — VARHCAR2(10) — 번호선택방법
  • VEHICLE_NUMBER_CHANGE_TYPE_CODE — VARCHAR2(10) — 번호변경

VEHICLE_CITY_CHANGE_APPLICATION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • RECEIPT_DATE — DATE — NOT NULL — 접수일시
  • ISSUANCE_DATE — DATE — 발급일시
  • OWNER_NAME — VARCHAR2(50) — NOT NULL — 소유자
  • OWNER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 소유자
  • OWNER_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 소유자
  • OWNER_ADDRESS — VARCHAR2(100) — NOT NULL — 소유자
  • OWNER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 소유자
  • OWNER_POSTAL_CODE — CHAR(5) — NOT NULL — 소유자
  • OWNER_EMAIL — VARCHAR2(100) — 소유자
  • OWNER_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 소유자
  • VEHICLE_NUMBER_NEW — VARCHAR2(13) — 새
  • VEHICLE_USE_ADDRESS — VARCHAR2(100) — NOT NULL — 자동차
  • VEHICLE_USE_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 자동차
  • VEHICLE_USE_POSTAL_CODE — CHAR(5) — NOT NULL — 자동차
  • APPLICATION_YMD — CHAR(8) — NOT NULL — 신청일자
  • APPLICANT_NAME — VARCHAR2(32) — NOT NULL — 신청인
  • ADMINISTRATION_INFO_AGREE_YN — CHAR(1) — NOT NULL — 행정정보
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 처리상태
  • LASTEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • REJECTION_REMARK — VARCHAR2(1000) — 반려사유
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • REMARK — VARCHAR2(2000) — NOT NULL — 등록접수부비고(등록시에
  • SUBROGATION_YN — CHAR(1) — 채권자대위
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 히스토리고유번호
  • OFFICE_CODE — VARCHAR2(7) — NOT NULL — 등록관청코드
  • VEHICLE_NUMBER — VARCHAR2(13) — NOT NULL — 자동차등록번호
  • SUBROGATION_NAME — VARCHAR2(50) — 채권자
  • SUBROGATION_ADDRESS — VARCHAR2(100) — 채권자
  • SUBROGATION_ADDRESS_DETAIL — VARCHAR2(100) — 채권자
  • SUBROGATION_POSTAL_CODE — CHAR(5) — SUBROGATION_POSTAL_CODE
  • SUBROGATION_REASON — VARCHAR2(1000) — 대위원인

VEHICLE_ERASE_APPLICATION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 히스토리고유번호
  • VEHICLE_NUMBER — VARCHAR2(13) — NOT NULL — 자동차등록번호
  • RECEIPT_DATE — DATE — NOT NULL — 접수일시
  • ISSUANCE_DATE — DATE — 발급일시
  • OWNER_NAME — VARCHAR2(50) — NOT NULL — 소유자
  • OWNER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — 소유자
  • OWNER_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — 소유자
  • OWNER_ADDRESS — VARCHAR2(100) — NOT NULL — 소유자
  • OWNER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 소유자
  • OWNER_POSTAL_CODE — CHAR(5) — NOT NULL — 소유자
  • OWNER_EMAIL — VARCHAR2(100) — 소유자
  • OWNER_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 소유자
  • VEHICLE_IDENTIFICATION_NUMBER — VARCHAR2(17) — NOT NULL — 차대번호
  • DISTANCE_DRIVEN — NUMBER(10) — NOT NULL — 주행거리km
  • REGISTRATION_REASON_CODE — VARCHAR2(10) — NOT NULL — 말소등록의
  • VEHICLE_ERASE_CERTIFICATION_ISSUANCE_YN — CHAR(1) — NOT NULL — 말소사실증명서발급여부
  • APPLICATE_DATE — DATE — NOT NULL — 신청일
  • APPLICANT_NAME — VARCHAR2(50) — NOT NULL — 신청인이름
  • APPLICANT_BIRTH_YMD — CHAR(8) — NOT NULL — 신청인생년월일
  • ADMINISTRATION_INFO_AGREE_YN — CHAR(1) — NOT NULL — 행정정보동의여부
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 처리상태
  • LATEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • REJECTION_REMARK — VARCHAR2(1000) — 반려사유
  • REMARK — VARCHAR2(2000) — NOT NULL — 등록접수부비고(등록시에
  • OFFICE_CODE — VARCHAR2(7) — NOT NULL — 등록관청코드
  • AUTHORITY_ERASE_YMD — CHAR(8) — 직권말소예정일
  • ERASE_TYPE_CODE — VARCHAR2(10) — 말소신청구분
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID

VEHICLE_ERASE_CERTIFICATE_ISSUANCE_APPLICATION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • OFFICE_CODE — VARCHAR2(7) — Primary key — NOT NULL — 등록관청코드
  • RECEIPT_DATE — DATE — NOT NULL — 접수일시
  • ISSUANCE_DATE — DATE — 발급일시
  • OWNER_NAME — VARCHAR2(50) — NOT NULL — 소유자이름
  • OWNER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — 소유자주민등록번호
  • OWNER_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — 소유자법인등록번호
  • APPLICANT_NAME — VARCHAR2(50) — NOT NULL — 신청자이름
  • APPLICANT_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — 신청자주민등록번호
  • APPLICANT_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — 신청자법인등록번호
  • APPLICANT_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 신청자전화번호
  • APPLICANT_EMAIL — VARCHAR2(100) — 신청자전자우편
  • ISSUANCE_COUNT — NUMBER(2) — NOT NULL — 신청부수
  • RECIPIENT_NAME — VARCHAR2(50) — NOT NULL — 수령인이름
  • RECEIVING_TYPE_CODE — VARCHAR2(10) — NOT NULL — 수령방법
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 처리상태
  • LATEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • REJECTION_REMARK — VARCHAR2(1000) — 반려사유
  • USAGE_CODE — VARCHAR2(10) — 용도
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 히스토리고유번호
  • VEHICLE_NUMBER — VARCHAR2(13) — NOT NULL — 자동차등록번호

VEHICLE_JOINT_OWNER

  • JOINT_OWNER_NUMBER — VARCHAR2(36) — Primary key — NOT NULL — 공동명의번호
  • JOINT_OWNER_INDEX — NUMBER(2) — Primary key — NOT NULL — 공동명의번호순위?
  • VEHICLE_IDENTIFICATION_NUMBER — VARCHAR2(17) — Foreign key → MANUFACTURE_CERTIFICATE.VEHICLE_IDENTIFICATION_NUMBER — NOT NULL — 차대번호
  • OWNER_NAME — VARCHAR2(50) — NOT NULL — 소유자성명
  • OWNER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 소유자
  • REPRESENTATIVE_OWNER_YN — CHAR(1) — NOT NULL — 대표자여부
  • OWNER_ADDRESS — VARCHAR2(100) — NOT NULL — 주소
  • OWNER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 주소상세
  • OWNER_POSTAL_CODE — CHAR(5) — 우편번호
  • SHARE_RATIO — VARCHAR2(2) — NOT NULL — 지분율
  • OWNER_PHONE_NUMBER — VARCHAR2(15) — 전화번호
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • OWNER_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — 소유자

VEHICLE_JOINT_OWNER_HISTORY

  • REPRESENTATIVE_OWNER_YN — CHAR(1) — NOT NULL — 대표자여부
  • OWNER_NAME — VARCHAR2(50) — NOT NULL — 소유자성명
  • OWNER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 주민등록번호
  • OWNER_ADDRESS — VARCHAR2(100) — NOT NULL — 주소
  • OWNER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 주소상세
  • OWNER_POSTAL_CODE — CHAR(5) — 우편번호
  • SHARE_RATIO — VARCHAR2(2) — NOT NULL — 지분율
  • OWNER_PHONE_NUMBER — VARCHAR2(15) — 전화번호
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • JOINT_OWNER_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_JOINT_OWNER.JOINT_OWNER_NUMBER — NOT NULL — 공동명의번호
  • JOINT_OWNER_INDEX — NUMBER(2) — Foreign key → VEHICLE_JOINT_OWNER.JOINT_OWNER_INDEX — NOT NULL — 공동명의번호인덱스
  • VEHICLE_IDENTIFICATION_NUMBER — VARCHAR2(17) — Foreign key → VEHICLE_JOINT_OWNER.VEHICLE_IDENTIFICATION_NUMBER — NOT NULL — 차대번호
  • OWNER_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — 소유자

VEHICLE_MAKER_MASTER

  • MAKER_NUMBER — VARCHAR2(14) — Primary key — NOT NULL — 제작자번호
  • RECEIPT_NUMBER — VARCHAR2(17) — Foreign key → VEHICLE_MAKER_REGISTRATION_APPLICATION.RECEIPT_NUMBER — NOT NULL — 접수번호
  • ISSUANCE_NUMBER — VARCHAR2(9) — NOT NULL — 2-1-4
  • ISSUANCE_DATE — DATE — NOT NULL — 제작증발급일자
  • MAKER_NAME — VARCHAR2(50) — NOT NULL — 제작사명
  • MAKER_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — 법인등록번호
  • MAKER_COMPANY_REGISTRATION_NUMBER — VARCHAR2(13) — 사업자등록번호
  • MAKER_OWNER_NAME — VARCHAR2(50) — NOT NULL — 대표자
  • MAKER_OWNER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 제작사주민등록번호
  • MAKER_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 제작사전화번호
  • MAKER_ADDRESS — VARCHAR2(100) — NOT NULL — 제작사주소
  • MAKER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 제작사상세주소
  • MAKER_POSTAL_NUMBER — CHAR(5) — NOT NULL — 제작사우편번호
  • ORIGINAL_MAKER_NAME — VARCHAR2(50) — 원제작자상호
  • ORIGINAL_MAKER_PHONE_NUMBER — VARCHAR2(15) — 원제작자전화번호
  • ORIGINAL_MAKER_ADDRESS — VARCHAR2(100) — 원제작자주소
  • ORIGINAL_MAKER_ADDRESS_DETAIL — VARCHAR2(100) — 원제작자상세주소
  • ORIGINAL_MAKER_POSTAL_CODE — CHAR(5) — 원제작자우편번호
  • BUSINESS_ADDRESS — VARCHAR2(100) — NOT NULL — 사업장소재지
  • BUSINESS_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 사업장소재지상세
  • BUSINESS_POSTAL_CODE — CHAR(5) — NOT NULL — 사업장소재지우편번호
  • MAKER_TYPE_CODE — VARCHAR2(10) — NOT NULL — 제작구분(공통)
  • REGISTRATION_PURPOSE_CODE — VARCHAR2(10) — NOT NULL — 등록목적(공통)
  • VEHICLE_COMPLETE_CODE — VARCHAR2(10) — NOT NULL — 제작등을하려는
  • SELF_CERTIFICATION_ABILITY_YN — CHAR(1) — NOT NULL — 자기인증능력여부(공통)
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일키
  • RETURN_DATE — DATE — 반납등록일
  • RETURN_CERTIFICATION_ISSUANCE_NUMBER — VARCHAR2(36) — 반납사실증명서
  • RETURN_TYPE_CODE — VARCHAR2(10) — 반납유형(공통코드)
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • MAKE_COUNTRY_CODE — VARCHAR2(10) — 제작국가코드

VEHICLE_MAKER_MASTER_HISTORY

  • ISSUANCE_NUMBER — VARCHAR2(9) — NOT NULL — 2-1-4
  • ISSUANCE_DATE — DATE — NOT NULL — 제작증발급일자
  • MAKER_NAME — VARCHAR2(50) — NOT NULL — 제작사명
  • MAKER_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — 법인등록번호
  • MAKER_COMPANY_REGISTRATION_NUMBER — VARCHAR2(13) — 사업자등록번호
  • MAKER_OWNER_NAME — VARCHAR2(50) — NOT NULL — 대표자
  • MAKER_OWNER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 제작사주민등록번호
  • MAKER_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 제작사전화번호
  • MAKER_ADDRESS — VARCHAR2(100) — NOT NULL — 제작사주소
  • MAKER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 제작사상세주소
  • MAKER_POSTAL_NUMBER — CHAR(5) — NOT NULL — 제작사우편번호
  • ORIGINAL_MAKER_NAME — VARCHAR2(50) — 원제작자상호
  • ORIGINAL_MAKER_PHONE_NUMBER — VARCHAR2(15) — 원제작자전화번호
  • ORIGINAL_MAKER_ADDRESS — VARCHAR2(100) — 원제작자주소
  • ORIGINAL_MAKER_ADDRESS_DETAIL — VARCHAR2(100) — 원제작자상세주소
  • ORIGINAL_MAKER_POSTAL_CODE — CHAR(5) — 원제작자우편번호
  • BUSINESS_ADDRESS — VARCHAR2(100) — NOT NULL — 사업장소재지
  • BUSINESS_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 사업장소재지상세
  • BUSINESS_POSTAL_CODE — CHAR(5) — NOT NULL — 사업장소재지우편번호
  • MAKER_TYPE_CODE — VARCHAR2(10) — NOT NULL — 제작구분(공통)
  • REGISTRATION_PURPOSE_CODE — VARCHAR2(10) — NOT NULL — 등록목적(공통)
  • VEHICLE_COMPLETE_YN — VARCHAR2(10) — NOT NULL — 제작등을하려는
  • SELF_CERTIFICATION_ABILITY_YN — CHAR(1) — NOT NULL — 자기인증능력여부(공통)
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일키
  • RETURN_DATE — DATE — 반납등록일
  • RETURN_CERTIFICATION_ISSUANCE_NUMBER — VARCHAR2(36) — 반납사실증명서
  • RETURN_TYPE_CODE — VARCHAR2(10) — 반납유형(공통코드)
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • MAKER_NUMBER — VARCHAR2(14) — Foreign key → VEHICLE_MAKER_MASTER.MAKER_NUMBER — NOT NULL — 제작자번호
  • RECEIPT_NUMBER — VARCHAR2(17) — Foreign key → VEHICLE_MAKER_MASTER.RECEIPT_NUMBER — NOT NULL — 접수번호

VEHICLE_MAKER_REGISTRATION_APPLICATION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • MAKER_NUMBER — VARCHAR2(14) — 제작자등록번호
  • MAKER_APPLICATION_TYPE_CODE — VARCHAR2(10) — 신청종류(공통)등록/변경등록/등록증재발급/반납신청
  • RECEIPT_DATE — DATE — NOT NULL — 접수일시
  • ISSUANCE_DATE — DATE — 발급일시
  • MAKER_NAME — VARCHAR2(50) — NOT NULL — 제작자명(법인명)
  • MAKER_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — 법인등록번호
  • MAKER_COMPANY_REGISTRATION_NUMBER — VARCHAR2(13) — 사업자등록번호
  • MAKER_OWNER_NAME — VARCHAR2(50) — NOT NULL — 대표자
  • MAKER_OWNER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 주민등록번호
  • MAKER_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 전화번호
  • MAKER_ADDRESS — VARCHAR2(100) — NOT NULL — 주소
  • MAKER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 상세주소
  • MAKER_POSTAL_NUMBER — CHAR(5) — NOT NULL — 우편번호
  • ORIGINAL_MAKER_NAME — VARCHAR2(50) — 원제작자상호
  • ORIGINAL_MAKER_PHONE_NUMBER — VARCHAR2(15) — 원제작자전화번호
  • ORIGINAL_MAKER_ADDRESS — VARCHAR2(100) — 원제작자주소
  • ORIGINAL_MAKER_ADDRESS_DETAIL — VARCHAR2(100) — 원제작자상세주소
  • ORIGINAL_MAKER_POSTAL_CODE — CHAR(5) — NOT NULL — 원제작자우편번호
  • BUSINESS_ADDRESS — VARCHAR2(100) — NOT NULL — 사업장소재지
  • BUSINESS_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 사업장소재지상세
  • BUSINESS_POSTAL_CODE — CHAR(5) — NOT NULL — 사업장소재지우편번호
  • MAKER_TYPE_CODE — VARCHAR2(10) — NOT NULL — 제작구분(공통):국내제작조립자
  • REGISTRATION_PURPOSE_CODE — VARCHAR2(10) — NOT NULL — 등록목적(공통)
  • VEHICLE_COMPLETE_CODE — VARCHAR2(10) — NOT NULL — 제작등을하려는자동차(공통):완성자동차
  • SELF_CERTIFICATION_ABILITY_YN — CHAR(1) — NOT NULL — 자기인증능력여부(공통)
  • APPLICATION_YMD — CHAR(8) — NOT NULL — 신청일자
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 신청상태
  • ADMINISTRATION_INFO_AGREE_YN — CHAR(1) — NOT NULL — 행정정보공동이용동의여부(공통코드)
  • REJECTION_REMARK — VARCHAR2(1000) — 반려사유
  • CERTIFICATE_GET_DATE — DATE — 제작자등록증수령일자
  • LATEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • RETURN_TYPE_CODE — VARCHAR2(10) — 반납유형(공통코드)

VEHICLE_MAKER_TYPE_SCALE

  • RECEIPT_INDEX — NUMBER(2) — Primary key — NOT NULL — 접수번호
  • RECEIPT_NUMBER — VARCHAR2(17) — Foreign key → VEHICLE_MAKER_REGISTRATION_APPLICATION.RECEIPT_NUMBER — NOT NULL — 접수번호
  • VEHICLE_TYPE_CODE — VARCHAR2(10) — NOT NULL — 승용/승합/화물/특수/이륜
  • VEHICLE_SCALE_CODE — VARCHAR2(10) — 차량종류
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID

VEHICLE_MASTER

  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Primary key — NOT NULL — 자동차고유번호
  • VEHICLE_NUMBER — VARCHAR2(13) — NOT NULL — 자동차등록번호
  • SPECIFICATION_NUMBER — VARCHAR2(17) — NOT NULL — 제원관리번호
  • ISSUANCE_NUMBER — VARCHAR2(14) — 자동차등록증
  • ISSUANCE_DATE — DATE — 자동차등록증
  • OWNER_NAME — VARCHAR2(50) — NOT NULL — 소유자명
  • OWNER_RESIDENT_REGISTRATION_NUMBER — VARCHAR2(13) — 소유자주민등록번호
  • OWNER_CORPORATION_REGISTRATION_NUMBER — VARCHAR2(13) — 소유자법인등록번호
  • OWNER_ADDRESS — VARCHAR2(100) — NOT NULL — 소유자주소
  • OWNER_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 소유자주소상세
  • OWNER_POSTAL_CODE — CHAR(5) — NOT NULL — 소유자우편번호
  • OWNER_PHONE_NUMBER — VARCHAR2(15) — NOT NULL — 소유자전화번호
  • VEHICLE_COLOR_CODE — VARCHAR2(10) — NOT NULL — 자동차색상(공통)
  • VEHICLE_NUMBER_OLD — VARCHAR2(16) — 자동차부활전구등록번호
  • VEHICLE_USE_ADDRESS — VARCHAR2(100) — NOT NULL — 자동차사용본거지주소
  • VEHICLE_USE_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 자동차사용본거지주소상세
  • VEHICLE_USE_POSTAL_CODE — VARCHAR2(5) — NOT NULL — 자동차사용본거지우편번호
  • VEHICLE_USAGE_CODE — VARCHAR2(10) — NOT NULL — 자동차용도(공통(5항목))
  • VEHICLE_JOINT_OWNER_YN — CHAR(1) — 자동차공동명의여부
  • INITIAL_REGISTRATION_YMD — CHAR(8) — NOT NULL — 최초등록일자
  • SUPPLY_PRICE — NUMBER(15) — NOT NULL — 공급가액
  • PRODUCTION_YMD — CHAR(8) — NOT NULL — 제작연월일
  • INITIAL_TRANSFER_YMD — CHAR(8) — NOT NULL — 최초양도연월일
  • VEHICLE_SOURCE_TYPE_CODE — VARCHAR2(10) — NOT NULL — 출처구분(공통)_신조/부활/수입
  • SYSTEM_CREATED_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATED_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATED_DATE — DATE — 수정일자
  • SYSTEM_UPDATED_USERID — VARCHAR2(32) — 수정자ID
  • RECEIPT_NUMBER — VARCHAR2(17) — Foreign key → VEHICLE_REGISTRATION_APPLICATION.RECEIPT_NUMBER — NOT NULL — 접수번호
  • ERASE_DATE — DATE — 말소등록일
  • ERASE_TYPE_CODE — VARCHAR2(10) — 말소등록구분
  • BUSINESS_USE_END_YMD — CHAR(8) — 말소시사업용사용종료일
  • BUSINESS_USE_START_YMD — CHAR(8) — 말소시사업용사용시작일
  • DISTANCE_DRIVEN — NUMBER — 말소시주행거리
  • ERASE_RECEIPT_NUMBER — VARCHAR2(17) — Foreign key → VEHICLE_ERASE_APPLICATION.RECEIPT_NUMBER — 말소접수번호
  • REGISTRATION_REASON_CODE — VARCHAR2(10) — 말소등록의원인
  • DRIVE_YN — CHAR(1) — NOT NULL — 현재운행여부
  • VEHICLE_IDENTIFICATION_NUMBER — VARCHAR2(17) — NOT NULL — 차대번호
  • JOINT_OWNER_NUMBER — VARCHAR2(36) — NOT NULL — 공동명의번호
  • OFFICE_CODE — VARCHAR2(7) — 관청코드
  • OWNER_EMAIL — VARCHAR2(100) — NOT NULL — 소유자
  • Field — VARCHAR(255) — 차령만료일
  • Field2 — VARCHAR(255) — 검사유효기간-정밀
  • Field3 — VARCHAR(255) — 검사유효기간-정기

VEHICLE_MORTGAGE_APPLICATION

  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Primary key — NOT NULL — 히스토리고유번호(공동저당자동차
  • RECEIPT_INDEX — NUMBER(5) — Primary key — NOT NULL — 저당권설정접수번호
  • RECEIPT_DATE — DATE — NOT NULL — 접수일자
  • ISSUANCE_DATE — DATE — 발급일자
  • MORTGAGEE_NAME — VARCHAR2(50) — NOT NULL — 저당권자성명
  • MORTGAGEE_ADDRESS — VARCHAR2(100) — NOT NULL — 저당권자주소
  • MORTGAGEE_ADDRESS_DETAIL — VARCHAR2(100) — 저당권자주소상세
  • MORTGAGEE_POSTAL_CODE — CHAR(5) — 저당권자우편번호
  • DEBTOR_NAME — VARCHAR2(50) — NOT NULL — 채무자성명
  • DEBTOR_ADDRESS — VARCHAR2(100) — NOT NULL — 채무자주소
  • DEBTOR_ADDRESS_DETAIL — VARCHAR2(100) — 채무자주소상세
  • DEBTOR_POSTAL_CODE — CHAR(5) — 채무자우편번호
  • MORTGAGOR_NAME — VARCHAR2(50) — NOT NULL — 저당권설정자성명
  • MORTGAGOR_ADDRESS — VARCHAR2(100) — NOT NULL — 저당권설정자주소
  • MORTGAGOR_ADDRESS_DETAIL — VARCHAR2(100) — 저당권설정자주소상세
  • MORTGAGOR_POSTAL_CODE — CHAR(5) — 저당권설정자우편번호
  • DEBTOR_PRICE_TYPE_CODE — VARCHAR2(10) — NOT NULL — 설정금액종류(공통)
  • DEBTOR_PRICE — NUMBER(15) — NOT NULL — 설정금액(채권가액
  • INTEREST — NUMBER(15) — NOT NULL — 이자
  • INTEREST_HAPPEN_YMD — CHAR(8) — NOT NULL — 이자발생일자
  • INTEREST_PAYMENT_YMD — CHAR(8) — NOT NULL — 이자지급일자
  • PAYBACK_YMD — CHAR(8) — NOT NULL — 변제일자
  • REGISTRATION_REASON_CODE — VARCHAR2(10) — NOT NULL — 등록원인구분(저당
  • CONDITION — VARCHAR2(1000) — 조건또는약정
  • PREVIOUS_MORTGAGE_YN — CHAR(1) — 종전저당권등록사실
  • APPLICATION_YMD — CHAR(8) — NOT NULL — 신청일자
  • APPLICATION_NAME — VARCHAR2(50) — NOT NULL — 신청인성명
  • LAST_UPDATED_DATE — DATE — NOT NULL — 신청서최종수정일자
  • ADMINISTRATION_INFO_AGREE_YN — CHAR(1) — NOT NULL — 행정정보공동이용동의여부(공통)
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 신청상태(공통코드)
  • REJECTION_REMARK — VARCHAR2(1000) — 반려사유
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • REMARK — VARCHAR2(2000) — NOT NULL — 등록접수부비고(등록시에
  • SUBROGATION_YN — CHAR(1) — 채권자대위
  • OFFICE_CODE — VARCHAR2(7) — NOT NULL — 등록관청
  • VEHICLE_NUMBER — VARCHAR2(13) — NOT NULL — 자동차등록번호
  • SUBROGATION_NAME — VARCHAR2(50) — 채권자
  • SUBROGATION_ADDRESS — VARCHAR2(100) — 채권자
  • SUBROGATION_ADDRESS_DETAIL — VARCHAR2(100) — 채권자
  • SUBROGATION_POSTAL_CODE — CHAR(5) — 채권자
  • SUBROGATION_REASON — VARCHAR2(1000) — 대위원인

VEHICLE_MORTGAGE_CHANGE_APPLICATION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • RECEIPT_DATE — DATE — NOT NULL — 접수일자
  • ISSUANCE_DATE — DATE — 발급일자
  • CHANGE_BEFORE — VARCHAR2(2000) — NOT NULL — 변경전
  • CHANGE_AFTER — VARCHAR2(2000) — NOT NULL — 변경후
  • APPLICATION_YMD — CHAR(8) — NOT NULL — 신청일자
  • APPLICANT_NAME — VARCHAR2(50) — NOT NULL — 신청인이름
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 처리상태
  • LATEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • REJECTION_REMARK — VARCHAR2(1000) — 반려사유
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — NOT NULL — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • REMARK — VARCHAR2(2000) — NOT NULL — 등록접수부비고(등록시에
  • SUBROGATION_YN — CHAR(1) — 채권자대위에
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MORTGAGE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 히스토리고유번호
  • MORTGAGE_NUMBER — VARCHAR2(14) — Foreign key → VEHICLE_MORTGAGE_MASTER.MORTGAGE_NUMBER — NOT NULL — 을부번호
  • OFFICE_CODE — VARCHAR2(7) — NOT NULL — 등록관청
  • VEHICLE_NUMBER — VARCHAR2(13) — NOT NULL — 자동차등록번호
  • SUBROGATION_NAME — VARCHAR2(50) — 채권자
  • SUBROGATION_ADDRESS — VARCHAR2(100) — 채권자
  • SUBROGATION_ADDRESS_DETAIL — VARCHAR2(100) — 채권자
  • SUBROGATION_POSTAL_CODE — CHAR(5) — 채권자
  • SUBROGATION_REASON — VARCHAR2(1000) — 대위원인

VEHICLE_MORTGAGE_CHANGE_DETAIL

  • RECEIPT_INDEX — VARCHAR2(17) — Primary key — NOT NULL — 변경접수번호
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MORTGAGE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 자동차고유번호
  • MORTGAGE_NUMBER — VARCHAR2(14) — Foreign key → VEHICLE_MORTGAGE_MASTER.MORTGAGE_NUMBER — NOT NULL — 을부번호
  • PRIORITY_INDEX — NUMBER(2) — NOT NULL — 순위번호
  • CATEGORY — VARCHAR2(10) — NOT NULL — 구분(공통)
  • CONTENT — VARCHAR2(2000) — NOT NULL — 사항란
  • REGISTRATION_YMD — CHAR(8) — NOT NULL — 등록일자
  • SYSTEM_CREATED_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATED_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATED_DATE — DATE — 수정일자
  • SYSTEM_UPDATED_USERID — VARCHAR2(32) — 수정자ID
  • OFFICE_CODE — VARCHAR2(7) — NOT NULL — 등록관청

VEHICLE_MORTGAGE_ERASE_APPLICATION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • RECEIPT_DATE — DATE — NOT NULL — 접수일자
  • ISSUANCE_DATE — DATE — 발급일자
  • MORTGAGEE_NAME — VARCHAR2(50) — NOT NULL — 저당권자
  • MORTGAGEE_ADDRESS — VARCHAR2(100) — NOT NULL — 저당권자
  • MORTGAGEE_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 저당권자
  • MORTGAGEE_POSTAL_CODE — CHAR(5) — NOT NULL — 저당권자
  • DEBTOR_NAME — VARCHAR2(50) — NOT NULL — 채무자
  • DEBTOR_ADDRESS — VARCHAR2(100) — NOT NULL — 채무자
  • DEBTOR_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 채무자
  • DEBTOR_POSTAL_CODE — CHAR(5) — NOT NULL — 채무자
  • MORTGAGOR_NAME — VARCHAR2(50) — NOT NULL — 저당권
  • MORTGAGOR_ADDRESS — VARCHAR2(100) — NOT NULL — 저당권설정자주소
  • MORTGAGOR_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 저당권설정자주소상세
  • MORTGAGOR_POSTAL_CODE — CHAR(5) — NOT NULL — 저당권설정자우편번호
  • DEBTOR_PRICE — NUMBER(15) — NOT NULL — 채권액
  • MAXIMUM_DEBTOR_PRICE — NUMBER(15) — NOT NULL — 채권최고액
  • COLLATERAL_PRICE — NUMBER(15) — NOT NULL — 담보가격
  • APPLICATION_YMD — CHAR(8) — NOT NULL — 신청일
  • APPLICANT_NAME — VARCHAR2(50) — NOT NULL — 신청인
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 처리상태
  • LATEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • REMARK — VARCHAR2(2000) — NOT NULL — 등록접수부비고(등록시에
  • SUBROGATION_YN — CHAR(1) — 채권자대위
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MORTGAGE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 히스토리고유번호
  • MORTGAGE_NUMBER — VARCHAR2(14) — Foreign key → VEHICLE_MORTGAGE_MASTER.MORTGAGE_NUMBER — NOT NULL — 을부번호
  • OFFICE_CODE — VARCHAR2(7) — NOT NULL — 등록관청
  • VEHICLE_NUMBER — VARCHAR2(13) — NOT NULL — 자동차등록번호
  • SUBROGATION_NAME — VARCHAR2(50) — 채권자
  • SUBROGATION_ADDRESS — VARCHAR2(100) — 채권자
  • SUBROGATION_ADDRESS_DETAIL — VARCHAR2(100) — 채권자
  • SUBROGATION_POSTAL_CODE — CHAR(5) — 채권자
  • SUBROGATION_REASON — VARCHAR2(1000) — 대위원인

VEHICLE_MORTGAGE_MASTER

  • MORTGAGE_NUMBER — VARCHAR2(14) — Primary key — NOT NULL — 을부번호(저당권설정이
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 자동차고유번호
  • MORTGAGEE_NAME — VARCHAR2(50) — NOT NULL — 저당권자명
  • MORTGAGEE_ADDRESS — VARCHAR2(100) — NOT NULL — 저당권자주소
  • MORTGAGEE_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 저당권자상세주소
  • MORTGAGEE_POSTAL_CODE — CHAR(5) — NOT NULL — 저당권자우편번호
  • MORTGAGOR_NAME — VARCHAR2(50) — NOT NULL — 저당권설정자명
  • MORTGAGOR_ADDRESS — VARCHAR2(100) — NOT NULL — 저당권설정자주소
  • MORTGAGOR_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 저당권설정자상세주소
  • MORTGAGOR_POSTAL_CODE — CHAR(5) — NOT NULL — 저당권설정자우편번호
  • DEBTOR_NAME — VARCHAR2(50) — NOT NULL — 채무자명
  • DEBTOR_ADDRESS — VARCHAR2(100) — NOT NULL — 채무자주소
  • DEBTOR_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 채무자상세주소
  • DEBTOR_POSTAL_CODE — CHAR(5) — NOT NULL — 채무자우편번호
  • DEBTOR_PRICE_TYPE_CODE — VARCHAR2(10) — NOT NULL — 설정금액종류(공통)
  • DEBTOR_PRICE — NUMBER(15) — NOT NULL — 채권가액
  • MORTGAGE_SET_YMD — CHAR(8) — NOT NULL — 저당권설정일자
  • MORTGAGE_ERASE_YMD — CHAR(8) — NOT NULL — 저당권말소일자
  • INTEREST — NUMBER(15) — NOT NULL — 이자
  • INTEREST_ACCRUAL_YMD — CHAR(8) — NOT NULL — 이자발생일자
  • INTEREST_PAYMENT_YMD — CHAR(8) — NOT NULL — 이자지급일자
  • PAYBACK_YMD — CHAR(8) — NOT NULL — 변제일자
  • REGISTRATION_REASON_CODE — VARCHAR2(10) — NOT NULL — 등록원인구분
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • RECEIPT_INDEX — NUMBER(5) — Foreign key → VEHICLE_MORTGAGE_APPLICATION.RECEIPT_INDEX — NOT NULL — 저당권설정접수번호

VEHICLE_MORTGAGE_MASTER_HISTORY

  • OFFICE_CODE — VARCHAR2(4) — 등록관청
  • MORTGAGEE_NAME — VARCHAR2(50) — NOT NULL — 저당권자명
  • MORTGAGEE_ADDRESS — VARCHAR2(100) — NOT NULL — 저당권자주소
  • MORTGAGEE_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 저당권자상세주소
  • MORTGAGEE_POSTAL_CODE — CHAR(5) — NOT NULL — 저당권자우편번호
  • MORTGAGOR_NAME — VARCHAR2(50) — NOT NULL — 저당권설정자명
  • MORTGAGOR_ADDRESS — VARCHAR2(100) — NOT NULL — 저당권설정자주소
  • MORTGAGOR_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 저당권설정자상세주소
  • MORTGAGOR_POSTAL_CODE — CHAR(5) — NOT NULL — 저당권설정자우편번호
  • DEBTOR_NAME — VARCHAR2(50) — NOT NULL — 채무자명
  • DEBTOR_ADDRESS — VARCHAR2(100) — NOT NULL — 채무자주소
  • DEBTOR_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 채무자상세주소
  • DEBTOR_POSTAL_CODE — CHAR(5) — NOT NULL — 채무자우편번호
  • DEBTOR_PRICE_TYPE_CODE — VARCHAR2(10) — NOT NULL — 설정금액종류(공통)
  • DEBTOR_PRICE — NUMBER(15) — NOT NULL — 채권가액
  • MORTGAGE_SET_YMD — CHAR(8) — NOT NULL — 저당권설정일자
  • MORTGAGE_ERASE_YMD — CHAR(8) — 저당권말소일자
  • INTEREST — NUMBER(15) — 이자
  • INTEREST_ACCRUAL_YMD — CHAR(8) — 이자발생일자
  • INTEREST_PAYMENT_YMD — CHAR(8) — 이자지급일자
  • PAYBACK_YMD — CHAR(8) — 변제일자
  • REGISTRATION_REASON_CODE — VARCHAR2(10) — 등록원인구분
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MORTGAGE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 히스토리고유번호
  • MORTGAGE_NUMBER — VARCHAR2(14) — Foreign key → VEHICLE_MORTGAGE_MASTER.MORTGAGE_NUMBER — NOT NULL — 을부번호

VEHICLE_MORTGAGE_TRANSFER_APPLICATION

  • RECEIPT_NUMBER — VARCHAR2(17) — Primary key — NOT NULL — 접수번호
  • RECEIPT_DATE — DATE — NOT NULL — 접수일자
  • ISSUANCE_DATE — DATE — 발급일자
  • GRANTOR_NAME — VARCHAR2(50) — NOT NULL — 이전
  • GRANTOR_BIRTH_YMD — CHAR(8) — NOT NULL — 이전
  • GRANTOR_COMPANY_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 이전
  • GRANTOR_ADDRESS — VARCHAR2(100) — NOT NULL — 이전
  • GRANTOR_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 이전
  • GRANTOR_POSTAL_CODE — CHAR(5) — NOT NULL — 이전
  • GRANTOR_CHANGE_REMARK — VARCHAR2(2000) — 이전
  • TRANSFEREE_NAME — VARCHAR2(50) — NOT NULL — 이전
  • TRANSFEREE_BIRTH_YMD — CHAR(8) — NOT NULL — 이전
  • TRANSFEREE_COMPANY_REGISTRATION_NUMBER — VARCHAR2(13) — NOT NULL — 이전
  • TRANSFEREE_ADDRESS — VARCHAR2(100) — NOT NULL — 이전
  • TRANSFEREE_ADDRESS_DETAIL — VARCHAR2(100) — NOT NULL — 이전
  • TRANSFEREE_POSTAL_CODE — CHAR(5) — NOT NULL — 이전
  • TRANSFEREE_CHANGE_REMARK — VARCHAR2(2000) — 이전
  • TRANSFER_TYPE_CODE — VARCHAR2(10) — NOT NULL — 이전등록구분
  • APPLICATION_YMD — CHAR(8) — NOT NULL — 신청일
  • APPLICANT_NAME — VARCHAR2(50) — NOT NULL — 신청인
  • UUID — VARCHAR2(36) — NOT NULL — 공통파일
  • APPLICATION_STATE_CODE — VARCHAR2(10) — NOT NULL — 처리상태
  • LATEST_UPDATE_DATE — DATE — NOT NULL — 신청서최종수정일자
  • SYSTEM_CREATE_DATE — DATE — NOT NULL — 작성일자
  • SYSTEM_CREATE_USERID — VARCHAR2(32) — NOT NULL — 작성자ID
  • SYSTEM_UPDATE_DATE — DATE — 수정일자
  • SYSTEM_UPDATE_USERID — VARCHAR2(32) — 수정자ID
  • REMARK — VARCHAR2(2000) — NOT NULL — 등록접수부비고(등록시에
  • SUBROGATION_YN — CHAR(1) — 채권자대위
  • VEHICLE_UNIQUE_NUMBER — VARCHAR2(36) — Foreign key → VEHICLE_MORTGAGE_MASTER.VEHICLE_UNIQUE_NUMBER — NOT NULL — 히스토리고유번호
  • MORTGAGE_NUMBER — VARCHAR2(14) — Foreign key → VEHICLE_MORTGAGE_MASTER.MORTGAGE_NUMBER — NOT NULL — 을부번호
  • OFFICE_CODE — VARCHAR2(7) — NOT NULL — 등록관청
  • VEHICLE_NUMBER — VARCHAR2(13) — NOT NULL — 자동차등록번호
  • SUBROGATION_NAME — VARCHAR2(50) — 채권자
  • SUBROGATION_ADDRESS — VARCHAR2(100) — 채권자
  • SUBROGATION_ADDRESS_DETAIL — VARCHAR2(100) — 채권자
  • SUBROGATION_POSTAL_CODE — CHAR(5) — 채권자
  • SUBROGATION_REASON — VARCHAR2(1000) — 대위원인