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