RMK
Tables (3)
TB_PRODUCT (요금제)
- PRODUCT_ID (일련번호) — INT — Primary key — NOT NULL
- NAME (요금제명) — VARCHAR(256)
- PRICE (요금제금액) — INT
- MONTHS (요금제개월수) — INT(11)
- ORDERING (순번) — INT(11)
- VALID (유효여부) — VARCHAR(1)
- CREATE_ID (생성자) — VARCHAR(225)
- CREATE_TIME (생성일자) — TIMESTAMP
- MODIFY_ID (수정자) — VARCHAR(225)
- MODIFY_TIME (수정일자) — TIMESTAMP
TB_SUBSCRIBE (구독서비스)
- SEQ (구분시퀀스) — INT — Primary key — NOT NULL
- VIN (차대번호) — VARCHAR(50) — Foreign key → TB_VIN_EASYCONNECT.VIN — NOT NULL
- PRODUCT_ID (요금제ID) — BIGINT UNSIGNED — Foreign key → TB_PRODUCT.PRODUCT_ID — NOT NULL
- BUYING_DT (유료서비스구매일) — DATE
- EXPIRED_YN (유료약정종료여부YN) — VARCHAR(1)
- COMMIT_ST_DT (유료약정시작일) — DATE
- COMMIT_ED_DT (유료약정종료일) — DATE
- PRICE (요금제금액) — INT
- MONTHS (요금제개월수) — INT(11)
- CREATE_ID (생성자) — VARCHAR(225)
- CREATE_TIME (생성일자) — TIMESTAMP
- MODIFY_ID (수정자) — VARCHAR(225)
- MODIFY_TIME (수정일자) — TIMESTAMP
TB_VIN_EASYCONNECT (이지커넥트 차량)
- VIN (차대번호) — VARCHAR(50) — Primary key — NOT NULL
- FREE_COMMIT_ST_DT (무료약정시작일) — DATE
- FREE_COMMIT_ED_DT (무료약정종료일) — DATE
- FREE_COMMIT_YEAR (무료약정년수) — INT(11)
- FREE_COMMIT_ED_YN (무료약정종료여부) — VARCHAR(1)
- CORP_DIV_CD (법인구분코드) — VARCHAR(2)
- CREATE_ID (생성자) — VARCHAR(225)
- CREATE_TIME (생성일자) — TIMESTAMP
- MODIFY_ID (수정자) — VARCHAR(225)
- MODIFY_TIME (수정일자) — TIMESTAMP