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) — 대위원인