1

Tables (5)

TC_CONTRACT

  • CONTRACT_ID — NUMBER — Primary key — NOT NULL
  • CONTRACT_DATE — DATE — NOT NULL
  • CONTRACT_TYPE_CD — VARCHAR2(2) — NOT NULL
  • MEMBER_ID — VARCHAR2(20)
  • MEMBER_SITE_CD — VARCHAR2(3) — NOT NULL
  • PRODUCT_CD — VARCHAR2(7)
  • INSUPERIOD_FROM — VARCHAR2(10)
  • INSUPERIOD_TO — VARCHAR2(10)
  • PERIOD_TYPE — VARCHAR2(1) — 단기/장기
  • TOUR_PLACE — VARCHAR2(2)
  • TOUR_GOAL — VARCHAR2(3)
  • INSURED_CNT — NUMBER
  • CONTRACTOR_TYPE — VARCHAR2(1) — NOT NULL
  • CONTRACT_NAME — VARCHAR2(50)
  • CONTRACT_SSN — VARCHAR2(39)
  • CHARGE_NAME — VARCHAR2(50)
  • CTEL_NO1 — VARCHAR2(4)
  • CTEL_NO2 — VARCHAR2(4)
  • CTEL_NO3 — VARCHAR2(4)
  • TEL_NO1 — VARCHAR2(4)
  • TEL_NO2 — VARCHAR2(4)
  • TEL_NO3 — VARCHAR2(4)
  • INSURED_CTEL1 — VARCHAR2(4)
  • INSURED_CTEL2 — VARCHAR2(4)
  • INSURED_CTEL3 — VARCHAR2(4)
  • INSURED_EMAIL — VARCHAR2(40)
  • TOT_PREMIUM — NUMBER
  • PAYMENT_METHOD — VARCHAR2(2)
  • PAYMENT_YN — VARCHAR2(1)
  • CARD_TYPE — VARCHAR2(1)
  • CARD_CORP_CD — VARCHAR2(5)
  • CARD_NO — VARCHAR2(58)
  • CARD_VALID_DATE — VARCHAR2(8)
  • CARD_OWNER_SSN — VARCHAR2(39)
  • CARD_OWNER_NAME — VARCHAR2(50)
  • BANK_CD — VARCHAR2(2)
  • BANK_ACCOUNT — VARCHAR2(58)
  • DEPOSITOR — VARCHAR2(50)
  • PAY_EXPECTED_DATE — VARCHAR2(8)
  • PAYMENT_DATE — VARCHAR2(8)
  • INPUT_DATE — VARCHAR2(8)
  • CONTRACT_STATUS — VARCHAR2(3)
  • INPUT_PREMIUM — NUMBER
  • RECEIPT_PREMIUM — NUMBER
  • POLICY_FILE — VARCHAR2(20)
  • PREV_CONTRACT_ID — NUMBER
  • ACTION_SITE_CD — VARCHAR2(3)
  • ACCESS_POINT_CD — VARCHAR2(50)
  • CANCEL_DATE — VARCHAR2(8)
  • UPDATE_DATE — DATE
  • UPDATE_EMP_ID — VARCHAR2(15)
  • EMPLOYEE_ID — VARCHAR2(15)

TC_INSURED

  • INSURED_SEQ — NUMBER — Primary key — NOT NULL
  • CONTRACT_ID — NUMBER — NOT NULL
  • INSURED_SSN — VARCHAR2(39) — NOT NULL
  • INSURED_NAME — VARCHAR2(50) — NOT NULL
  • NATIONALITY — VARCHAR2(2)
  • INSURED_NAME_ENG — VARCHAR2(50)
  • PLAN_CD — VARCHAR2(3)
  • PREMIUM — NUMBER — NOT NULL

TM_LOGIN_LOG

  • MEMBER_ID — VARCHAR2(20) — Foreign key → TM_MEMBER.MEMBER_ID — NOT NULL
  • MEMBER_SITE_CD — VARCHAR2(3) — Foreign key → TM_MEMBER.MEMBER_SITE_CD — NOT NULL
  • LOGIN_DATE — DATE — NOT NULL
  • ACCESS_IP — VARCHAR2(15)
  • ACTION_SITE_CD — VARCHAR2(3)
  • ACCESS_POINT_CD — VARCHAR2(50)

TM_MEMBER

  • MEMBER_ID — VARCHAR2(20) — Primary key — NOT NULL
  • MEMBER_SITE_CD — VARCHAR2(3) — Primary key — NOT NULL
  • MEMBER_TYPE_CD — VARCHAR2(2) — NOT NULL
  • REGISTRATION_NO — VARCHAR2(10) — NOT NULL — 생년월일성별(개인)/사업자등록번호(법인)
  • NAME — VARCHAR2(30) — NOT NULL
  • PASSWORD — VARCHAR2(64)
  • EMAIL — VARCHAR2(40)
  • CTEL_NO1 — VARCHAR2(4)
  • CTEL_NO2 — VARCHAR2(4)
  • CTEL_NO3 — VARCHAR2(4)
  • TEL_NO1 — VARCHAR2(4)
  • TEL_NO2 — VARCHAR2(4)
  • TEL_NO3 — VARCHAR2(4)
  • ZIPCODE — VARCHAR2(6)
  • ADDRESS — VARCHAR2(240)
  • DB_MNG_NO — VARCHAR2((25)
  • REJECT_EMAIL — DATE
  • REJECT_SMS — DATE
  • CHIEF_NAME — VARCHAR2(30)
  • CHARGE_NAME — VARCHAR2(30)
  • DEPARTMENT — VARCHAR2(40)
  • POSITION — VARCHAR2(30)
  • CONTRACT_TYPE — VARCHAR2(1)
  • DEAL_TOUR_ITEM — VARCHAR2(1)
  • PAYMENT_DATE — VARCHAR2(2)
  • CARD_TYPE — VARCHAR2(1)
  • CARD_CORP_CD — VARCHAR2(5)
  • CARD_NO — VARCHAR2(40)
  • CARD_VALID_DATE — VARCHAR2(4)
  • CARD_OWNER_SSN — VARCHAR2(39)
  • CARD_OWNER_NAME — VARCHAR2(30)
  • BANK_CD — VARCHAR2(2)
  • BANK_ACCOUNT — VARCHAR2(58)
  • DISPLAY_PREM_YN — VARCHAR2(1)
  • LIMIT_AMOUNT — NUMBER
  • JOIN_DATE — DATE
  • START_DATE — VARCHAR2(8)
  • STOP_DATE — VARCHAR2(8)
  • STOP_REASON_CD — VARCHAR2(2)
  • STOP_REASON — VARCHAR2(100)
  • UPDATE_DATE — DATE
  • ACTION_SITE_CD — VARCHAR2(3)
  • ACCESS_POINT_CD — VARCHAR2(50)

TM_MILEAGE_HISTORY

  • SEQ — NUMBER — Primary key — NOT NULL
  • MEMBER_ID — VARCHAR2(20) — Foreign key → TM_MEMBER.MEMBER_ID — NOT NULL
  • MEMBER_SITE_CD — VARCHAR2(3) — Foreign key → TM_MEMBER.MEMBER_SITE_CD — NOT NULL
  • INSERT_DATE — DATE — NOT NULL
  • MILEAGE_HIS_CD — VARCHAR2(3) — NOT NULL
  • MILEAGE_HIS_DETAIL — VARCHAR2(50) — NOT NULL
  • MILEAGE — NUMBER — NOT NULL
  • REST_MILEAGE — NUMBER
  • TOT_MILEAGE — NUMBER — NOT NULL
  • VALID_DATE — VARCHAR2(8)
  • REFERENCE_KEY — NUMBER