Scheme
Tables (19)
TB_MA_META_BASIC
- BASIC_SEQ — INT
- BUSINESS_TYPE_CD — NCHAR(6)
- BM_TYPE_CD — NCHAR(6)
- ARTICLE_TYPE_CD — NCHAR(6)
- ARTICLE_NM — VARCHAR(100) — NOT NULL
- REF_TABLE_ID — VARCHAR(100) — NOT NULL
- AFFECTED_YN — NCHAR(1) — NOT NULL
- AFFECTED_BY_SEQ — INT — NOT NULL
- GRP_CD — VARCHAR(20) — NOT NULL
- BELONG — VARCHAR(20) — NOT NULL
- VALUE_TYPE_CD — NCHAR(6) — NOT NULL
- DISPLAY_TYPE_CD — NCHAR(6) — NOT NULL
- LABEL_NM — VARCHAR(100) — NOT NULL
- ESSENTIAL_YN — NCHAR(1) — NOT NULL
- DISPLAY_YN — NCHAR(1) — NOT NULL
- USE_YN — NCHAR(1) — NOT NULL
- REG_ID — VARCHAR(200) — NOT NULL
- REG_DT — VARCHAR(14) — NOT NULL
- MOD_ID — VARCHAR(200) — NOT NULL
- MOD_DT — VARCHAR(14) — NOT NULL
TB_MA_META_CALC
- CALC_SEQ — INT
- BUSINESS_TYPE_CD — NCHAR(6) — NOT NULL
- ARTICLE_TYPE_CD — NCHAR(6) — NOT NULL
- ARTICLE_NM — VARCHAR(100) — NOT NULL
- ARTICLE_DESC — VARCHAR(100) — NOT NULL
- REF_TABLE_ID — VARCHAR(100) — NOT NULL
- VALUE_TYPE_CD — NCHAR(6) — NOT NULL
- DISPALY_TYPE_CD — NCHAR(6) — NOT NULL
- INEQUATION_CD — NCHAR(6) — NOT NULL
- UNIT_CD — NCHAR(6) — NOT NULL
- UNIT_NM — VARCHAR(100) — NOT NULL
- LABEL_NM — VARCHAR(100) — NOT NULL
- PREFIX_TXT — VARCHAR(100) — NOT NULL
- MULTIPLE_SEL_YN — NCHAR(1) — NOT NULL
- CODE_VALUE_YN — NCHAR(1) — NOT NULL
- CODE_GRP_CD — VARCHAR(20) — NOT NULL
- ORDER_NO — INT — NOT NULL
- REG_ID — VARCHAR(200) — NOT NULL
- REG_DT — VARCHAR(14) — NOT NULL
- MOD_ID — VARCHAR(200) — NOT NULL
- MOD_DT — VARCHAR(14) — NOT NULL
- STEP_CD — VARCHAR(10) — NOT NULL
- CD — VARCHAR(10) — NOT NULL
- UP_STEP_CD — VARCHAR(10) — NOT NULL
- STEP_ONE_CD — VARCHAR(10) — NOT NULL
TB_MA_META_STANDARD_FORM
- BUSINESS_TYPE_CD — NCHAR(6)
- BM_TYPE_CD — NCHAR(6)
- BASIC_SEQ — INT
- APPLY_ALLOWANCE_TYPE_CD — NCHAR(6) — NOT NULL
- REF_TABLE_ID — VARCHAR(100) — NOT NULL
- REF_TARGET_COLUMN — VARCHAR(100) — NOT NULL
- REG_ID — VARCHAR(200) — NOT NULL
- REG_DT — VARCHAR(14) — NOT NULL
- MOD_ID — VARCHAR(200) — NOT NULL
- MOD_DT — VARCHAR(14) — NOT NULL
TB_MA_META_STANDARD_FORM_ARTICLE
- BUSINESS_TYPE_CD — NCHAR(6)
- BM_TYPE_CD — NCHAR(6)
- BASIC_SEQ — INT
- FORM_FIELD_CD — NCHAR(6)
- FORM_FIELD_NM — VARCHAR(100) — NOT NULL
- FORM_FIELD_ORD — INT — NOT NULL
- REF_TABLE_ID — VARCHAR(100) — NOT NULL
- APPLY_WHR_SQL — NVARCHAR(255) — NOT NULL
TB_MA_SCHEME_ADD_CHASSIS
- SCHEME_ID — VARCHAR(14)
- CHASSIS_NO — VARCHAR(17)
- ALLOWANCE — INT — NOT NULL
- REG_ID — VARCHAR(200) — NOT NULL
- REG_DT — VARCHAR(14) — NOT NULL
TB_MA_SCHEME_APPLY
- SEQ — INT — Primary key — NOT NULL
- SCHEME_ID — VARCHAR(14) — NOT NULL
- CALC_SEQ — INT — NOT NULL
- BASIC_SEQ — INT — NOT NULL
- APPLY_TYPE_CD — VARCHAR(14) — NOT NULL
- APPLY_TYPE_NM — VARCHAR(14) — NOT NULL
- REG_ID — VARCHAR(200) — NOT NULL
- REG_DT — VARCHAR(14) — NOT NULL
TB_MA_SCHEME_MASTER
- SCHEME_ID — VARCHAR(14) — Primary key — NOT NULL — SCHEME ID, FN_GET_SCHEME_ID 함수 참고
- CATEGORY_SEQ — INT — CATEGORY SEQ, TB_MA_META_CATEGORY - CATEGORY_SEQ
- CATEGORY_L1_CD — VARCHAR(10) — CATEGORY 대 분류 코드 (TB_CMM_CODE : SC05)
- CATEGORY_L2_CD — VARCHAR(10) — CATEGORY 중 분류 코드 (TB_CMM_CODE : SC05)
- BUSINESS_TYPE_CD — NCHAR(6) — NOT NULL — 업무 구분 코드 (TB_CMM_CODE : CM02)
- SCHEME_NM — VARCHAR(100) — SCHEME NAME
- PERIOD_TYPE_CD — NCHAR(6) — 기간 유형 코드 (TB_CMM_CODE : SC06)
- PERIOD_START — VARCHAR(8) — 스킴 표시 기간 : 시작일자
- PERIOD_END — VARCHAR(8) — 스킴 표시 기간 : 종료일자
- REGIST_START — VARCHAR(8) — -
- REGIST_END — VARCHAR(8) — -
- STANDARD_SEQ — INT — STANDARE SEQ, TB_MA_SCHEME_STANDARD_MASTER - STANDARD_SEQ
- TARGET_SEQ — INT — TARGET SEQ, TB_MA_SCHEME_TARGET_MASTER - TARGET_SEQ
- FILE_ID — VARCHAR(100) — -
- ADD_CHASSIS_USE_YN — NCHAR(1) — 추가 정산 차량 여부 (Demo에서만 사용 Y/N, 다른 카테고리는 NULL 값)
- GENERATE_ID — VARCHAR(30) — -
- GENERATE_DT — VARCHAR(14) — -
- USE_YN — NCHAR(1) — 사용여부 (Y/N), "N"은 삭제 Scheme 으로 봄
- REG_ID — VARCHAR(200) — 작성자 ID
- REG_DT — VARCHAR(14) — 작성일자
- MOD_ID — VARCHAR(200) — 수정자 ID
- MOD_DT — VARCHAR(14) — 수정일자
- STEP1 — VARCHAR(10) — Scheme 작성 Step 1 항목 (TB_CMM_CODE : SC19)
- STEP2 — VARCHAR(10) — Scheme 작성 Step 2 항목 (TB_CMM_CODE : SC19)
- STEP3 — VARCHAR(10) — Scheme 작성 Step 3 항목 (TB_CMM_CODE : SC19)
- SCHEME_CONFIRM — VARCHAR(1) — schemeConfirm 승인 여부 (Y/N)
- FILE_CONFIRM — VARCHAR(1) — fileConfirm 승인여부 (Y/N)
- SAMPLING_CONFIRM — VARCHAR(1) — samplingConfirm(Sales) 승인여부 (Y/N)
- SPECIAL — VARCHAR(10) — -
- ORDER_NO — INT — Scheme 정렬 순서
- SAMPLING_CONT_CONFIRM — VARCHAR(1) — samplingConfirm(Acct.) 승인여부 (Y/N)
- SCHEME_FILE_ID — VARCHAR(100) — 공문 자료 FILE ID, TB_SCHEME_FILE_LIST - FILE_ID
- CAL_UNIT — VARCHAR(50) — -
TB_MA_SCHEME_OPTION
- OPTION_SEQ — INT — Primary key — NOT NULL — SCHEME OPTION SEQ
- SCHEME_ID — VARCHAR(14) — Foreign key → TB_MA_SCHEME_MASTER.SCHEME_ID — NOT NULL — SCHEME ID, FN_GET_SCHEME_ID 함수 참고
- OPTION_NM — VARCHAR(50) — -
- OPTION_NO — INT — -
- APPLY_ALLOWANCE_TYPE_CD — NCHAR(6) — 0
- REF_TARGET_COLUMN — VARCHAR(100) — -
- REF_TARGET_COLUMN2 — VARCHAR(100) — -
- ALLOWANCE — INT — -
- RATE — DECIMAL(5, 2) — -
- WHR_SQL — NVARCHAR(255) — 프로시저로 생성한 동적 쿼리문
- REG_ID — VARCHAR(200) — 작성자 ID
- REG_DT — VARCHAR(14) — 작성일자
- MOD_ID — VARCHAR(200) — -
- MOD_DT — VARCHAR(14) — -
- WHR_SQL_CAL — NVARCHAR(255) — 프로시저로 생성한 동적 쿼리문 _CAL (사용 X)
- WHR_SQL_COMPARE — NVARCHAR(255) — 프로시저로 생성한 동적 쿼리문 _COMPARE (사용 X)
- ADD_TARGET_YN — BIGINT — 타겟 조건 추가 여부 (Y:추가, N || NULL : 해당 없음)
TB_MA_SCHEME_OPTION_DETAIL
- OPTION_DETAIL_SEQ — INT — Primary key — NOT NULL — SCHEME OPTION DETAIL SEQ
- OPTION_SEQ (OPTION_SEQ2) — INT — Foreign key → TB_MA_SCHEME_OPTION.OPTION_SEQ — NOT NULL — SCHEME OPTION SEQ
- SCHEME_ID — VARCHAR(14) — SCHEME_ID, TB_MA_SCHEME_MASTER - SCHEME_ID
- CALC_SEQ — INT — CALC_SEQ, TB_MA_META_CALC - CALC_SEQ
- ARTICLE_TYPE_CD — NCHAR(6) — ARTICLE TYPE CODE (TB_CMM_CODE : SC01)
- VALUE_TYPE_CD — NCHAR(6) — VALUE TYPE CODE (TB_CMM_CODE : SC02)
- VALUE1 — VARCHAR(300) — -
- VALUE2 — DECIMAL(18, 3) — -
- VALUE3 — NCHAR(1) — -
- VALUE_FROM — DECIMAL(18, 3) — -
- VALUE_TO — DECIMAL(18, 3) — -
- REG_ID — VARCHAR(200) — -
- REG_DT — VARCHAR(14) — 작성일자
- MOD_ID — VARCHAR(200) — -
- MOD_DT — VARCHAR(14) — -
- OPTION_NM — VARCHAR(100) — OPTION NAME, TB_MA_META_CALC - ARTICLE_NM
TB_MA_SCHEME_RANGE_DETAIL
- SEQ — INT — Primary key — NOT NULL
- SCHEME_ID — VARCHAR(14)
- START_CNT — INT
- END_CNT — INT
- ALLOWANCE1 — INT — NOT NULL
- ALLOWANCE2 — INT — NOT NULL
- ALLOWANCE3 — INT — NOT NULL
- ALLOWANCE4 — INT — NOT NULL
- REG_ID — VARCHAR(200) — NOT NULL
- REG_DT — VARCHAR(14) — NOT NULL
- MOD_ID — VARCHAR(200) — NOT NULL
- MOD_DT — VARCHAR(14) — NOT NULL
- STANDARD_SEQ — INT — NOT NULL
TB_MA_SCHEME_STANDARD_DETAIL
- SEQ — INT — Primary key — NOT NULL
- STANDARD_SEQ (STANDARD_SEQ2) — INT — Foreign key → TB_MA_SCHEME_STANDARD_MASTER.STANDARD_SEQ — NOT NULL — STANDARD SEQ
- MY — NCHAR(4) — NOT NULL
- PACKAGE — VARCHAR(50) — NOT NULL
- SERIES — VARCHAR(50) — NOT NULL
- MODEL_CODE — NCHAR(4) — NOT NULL
- CAPACITY — VARCHAR(20) — NOT NULL
- MODEL_DETAIL_NM — VARCHAR(50) — NOT NULL
- ALLOWANCE1 — DECIMAL(18, 3) — NOT NULL
- ALLOWANCE2 — DECIMAL(18, 3) — NOT NULL
- ALLOWANCE3 — DECIMAL(18, 3) — NOT NULL
- ALLOWANCE4 — DECIMAL(18, 3) — NOT NULL
- ALLOWANCE5 — DECIMAL(18, 3) — NOT NULL
- SEGMENT — VARCHAR(50) — NOT NULL
- BODY_CODE — VARCHAR(50) — NOT NULL
- MODEL_TYPE — VARCHAR(50) — NOT NULL
- FUEL_TYPE — VARCHAR(50) — NOT NULL
- MODEL_NM — VARCHAR(100) — NOT NULL
- SPEC_CODE — VARCHAR(50) — NOT NULL
- SPEC_NM — VARCHAR(100) — NOT NULL
- OUT_COLOR_CODE — VARCHAR(10) — NOT NULL
- IN_COLOR_CODE — VARCHAR(10) — NOT NULL
- TB_MA_SCHEME_STANDARD_DETAIL — INT — NOT NULL
- ALLOWANCE6 — DECIMAL(18, 3) — NOT NULL
- ALLOWANCE7 — DECIMAL(18, 3) — NOT NULL
- ALLOWANCE8 — DECIMAL(18, 3) — NOT NULL
- ALLOWANCE9 — DECIMAL(18, 3) — NOT NULL
- ALLOWANCE10 — DECIMAL(18, 3) — NOT NULL
- BRAND_TYPE_CD — VARCHAR(100) — NOT NULL
- SR_GROUP_CD — VARCHAR(10) — NOT NULL
- CATEGORY_CODE — VARCHAR(20) — NOT NULL
TB_MA_SCHEME_STANDARD_MASTER
- STANDARD_SEQ — INT — Primary key — NOT NULL — STANDARD SEQ
- SCHEME_ID — VARCHAR(14) — Foreign key → TB_MA_SCHEME_MASTER.SCHEME_ID — NOT NULL — SCHEME ID, FN_GET_SCHEME_ID 함수 참고
- USE_MSRP_PER — NCHAR(1) — MSRP 대비 사용여부 (Y/N)
- DEMO_YN — NCHAR(1) — DEMO 여부 (Y/N)
- MONTHLY_INSTALLMENT — DECIMAL(18, 2) — Monthly Installmenu (% 이자율, Demo에서만 사용)
- LEASE_PERIOD — INT — 리스기간 (운용 개월수, Demo에서만 사용)
- RESIDUAL_VALUE — INT — 리스기간 후 잔존가치 (% Demo에서만 사용)
- OPERATE_MONTH — INT — Demo Car 운용월수 (운용 개월수, Demo에서만 사용)
- DEMO_CAR_PRICE — INT — 데모차 가격(retail Price * %, Demo에서만 사용)
- LEASE_DAY — INT — 반납조건 1, 최초등록일 ~ 리스승계일(이상) (일, Demo에서만 사용)
- MILEAGE — INT — 반납조건 1, 마일리지(이상) (km, Demo에서만 사용)
- MILEAGE2 — INT — 반납조건 2, 마일리지(이상) (km, Demo에서만 사용)
- REG_ID — VARCHAR(200) — 작성자 ID
- REG_DT — VARCHAR(14) — 작성일자
- MOD_ID — VARCHAR(200) — -
- MOD_DT — VARCHAR(14) — -
- SF_YN — VARCHAR(1) — SF 여부 (Y/N) * 확인 필요
- NEW_YN — VARCHAR(10) — 신규 여부 (Y/N) * 확인 필요
TB_MA_SCHEME_STANDARD_SPECIAL
- SEQ — INT — Primary key — NOT NULL
- STANDARD_SEQ (STANDARD_SEQ2) — INT — Foreign key → TB_MA_SCHEME_STANDARD_MASTER.STANDARD_SEQ — NOT NULL — STANDARD SEQ
- CATEGORY — VARCHAR(100) — NOT NULL
- CODE — VARCHAR(50) — NOT NULL
- TITLE — VARCHAR(300) — NOT NULL
- ALLOWANCE_USE_YN — VARCHAR(20) — NOT NULL
- ALLOWANCE — DECIMAL(38, 0) — NOT NULL
TB_MA_SCHEME_TARGET_DETAIL
- SEQ — INT — Primary key — NOT NULL
- TARGET_SEQ — INT
- DL_ACRO_CD — VARCHAR(10) — NOT NULL
- SR_CD — VARCHAR(100) — NOT NULL
- SR_NM — VARCHAR(100) — NOT NULL
- TEAM — VARCHAR(50) — NOT NULL
- SC_CD — VARCHAR(50) — NOT NULL
- SC_NM — VARCHAR(50) — NOT NULL
- TARGET1 — INT — NOT NULL
- INCENTIVE1 — INT — NOT NULL
- TARGET2 — INT — NOT NULL
- INCENTIVE2 — INT — NOT NULL
- TARGET3 — INT — NOT NULL
- INCENTIVE3 — INT — NOT NULL
- RANKING — INT — NOT NULL
- DEALER_CODE — VARCHAR(10) — NOT NULL
- TEAM_CD — VARCHAR(50) — NOT NULL
- SCHEME_ID — VARCHAR(50) — NOT NULL
- CONFIRM_YN — VARCHAR(1) — NOT NULL
TB_MA_SCHEME_TARGET_DETAIL2
- SEQ — INT — Primary key — NOT NULL
- TARGET_SEQ — INT
- TARGET — VARCHAR(20) — NOT NULL
- START_CNT — INT — NOT NULL
- END_CNT — INT — NOT NULL
TB_MA_SCHEME_TARGET_MASTER
- TARGET_SEQ — INT — Primary key — NOT NULL
- SCHEME_ID — VARCHAR(50) — NOT NULL
- DETAIL_SETTING_USE_YN — NCHAR(1) — NOT NULL
- LAST_TARGET — INT — NOT NULL
- ALLOWANCE_TYPE_SET — VARCHAR(20) — NOT NULL
- REG_ID — VARCHAR(200) — NOT NULL
- REG_DT — NCHAR(14) — NOT NULL
- MOD_ID — VARCHAR(200) — NOT NULL
- MOD_DT — NCHAR(14) — NOT NULL
TB_MA_SCHEME_TARGET_OPTION_MAPP
- TARGET_MASTER_SEQ — INT
- TARGET_DETAIL_SEQ — INT
- OPTION_SEQ — INT
TB_SCHEME_FILE_LIST
- FILE_SEQ — INT — Primary key — NOT NULL
- FILE_ID — VARCHAR(100)
- SCHEME_ID — VARCHAR(14)
- FILE_NM — VARCHAR(500) — NOT NULL
- FILE_PHYSICAL_NM — VARCHAR(500) — NOT NULL
- FILE_PATH — VARCHAR(200) — NOT NULL
- FILE_EXTENSION — VARCHAR(20) — NOT NULL
- FILE_SIZE — DECIMAL(18, 3) — NOT NULL
- FILE_CATEGORY_CD — NCHAR(6) — NOT NULL
- BUSINESS_TYPE_CD — NCHAR(6) — NOT NULL
- USE_YN — NCHAR(1) — NOT NULL
- REG_USER — VARCHAR(200) — NOT NULL
- REG_DT — VARCHAR(14) — NOT NULL
- UPT_ID — VARCHAR(200) — NOT NULL
- UPT_DT — VARCHAR(14) — NOT NULL
Untitled
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Key3 — Primary key — NOT NULL
- Key4 — Primary key — NOT NULL
- Key5 — Primary key — NOT NULL