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