세이프아이디

테이블 (23)

board

  • id — bigint — 기본 키 — NOT NULL
  • board_type — varchar(31)
  • title — varchar(255)
  • content — text
  • start_at — datetime
  • end_at — datetime
  • available — bit(1)
  • location — varchar(255)
  • order — int
  • link — varchar(255)
  • img_key — varchar(255)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

call_history

  • id — bigint — 기본 키 — NOT NULL
  • phone_number — varchar(255) — NOT NULL
  • media — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

contract

  • id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint — NOT NULL
  • media — varchar(255) — NOT NULL
  • start_at — datetime(6) — NOT NULL
  • end_at — datetime(6)
  • register_route — varchar(10) — NOT NULL
  • termination_route — varchar(10)
  • status — varchar(10) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)
  • created_by — bigint
  • last_modified_by — bigint

customer

  • id — bigint — 기본 키 — NOT NULL
  • media — varchar(255) — NOT NULL
  • phone_number — varchar(1024) — NOT NULL
  • name — varchar(2048)
  • birth — varchar(2048)
  • gender — varchar(2048)
  • password — varchar(255)
  • ci — varchar(3000)
  • status — varchar(255) — NOT NULL
  • user_role — enum('USER','USER_LGU','ADMIN','MANAGER')
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

customer_deleted

  • id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint
  • media — varchar(255) — NOT NULL
  • phone_number — varchar(1024) — NOT NULL
  • name — varchar(2048)
  • birth — varchar(2048)
  • gender — varchar(2048)
  • ci — varchar(3000)
  • insurance — longtext
  • user_role — enum('USER','USER_LGU','ADMIN','MANAGER')
  • customer_created_at — datetime(6)
  • customer_deleted_at — datetime(6)
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

customer_login_history

  • id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint
  • success — bit(1)
  • login_at — datetime
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

customer_monitoring

  • id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint
  • terms_id — bigint
  • status — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

customer_notification

  • id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint
  • category — varchar(255) — NOT NULL
  • status — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

customer_s2w

  • id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint
  • s2w_type — varchar(31) — NOT NULL
  • email — varchar(255)
  • kftc_code — varchar(255)
  • kftc_name — varchar(255)
  • number — varchar(3000)
  • status — varchar(255)
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

customer_s2w_history

  • id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint
  • leaked — bit(1)
  • score — int
  • lastest_leaked_time — datetime(6)
  • search_at — datetime(6)
  • s2w_type — varchar(31) — NOT NULL
  • risk — varchar(255)
  • imageUrl — varchar(255)
  • url — varchar(255)
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

customer_s2w_leak_history

  • id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint
  • leaked_at — datetime(6)
  • s2w_type — varchar(31) — NOT NULL
  • email — varchar(255)
  • kftc_code — varchar(255)
  • kftc_name — varchar(255)
  • hash_number — varchar(255)
  • password — varchar(255)
  • status — varchar(16) — NOT NULL — 상태. detect, notice, fail
  • mms_id — bigint — mms 전송 로그. mms_sent_log 테이블 참조
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

customer_s2w_monitoring_result

  • id — bigint — 기본 키 — NOT NULL
  • monitoring_type — varchar(31)
  • customer_id — bigint
  • count — bigint
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

customer_token

  • id — bigint — 기본 키 — NOT NULL
  • expired — bit(1) — NOT NULL
  • revoked — bit(1) — NOT NULL
  • customer_id — bigint
  • token — varchar(255)
  • tokenType — enum('BEARER')
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

find_site

  • id — bigint — 기본 키 — NOT NULL
  • find_site_type — varchar(20)
  • order — int
  • name — varchar(255)
  • code — varchar(255)
  • url — varchar(255)
  • image_url — varchar(200)
  • searchable — bit(1)
  • auth — varchar(255) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

holiday

  • id — bigint — 기본 키 — NOT NULL
  • holiday_date — date — NOT NULL
  • holiday_name — varchar(255)
  • holiday_description — varchar(100)
  • is_active — tinyint(1) — NOT NULL
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

insurance

  • id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint
  • start_at — datetime(6)
  • end_at — datetime(6)
  • status — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

insurance_terms

  • id — bigint — 기본 키 — NOT NULL
  • insurance_id — bigint
  • terms_id — bigint
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

memo

  • id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint
  • content — text
  • admin_id — varchar(255)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

mms_sent_log

  • id — bigint — 기본 키 — NOT NULL
  • media — varchar(8) — NOT NULL — 이통사. skt, kt, lgu, mvno_skt, mvno_kt, mvno_lgu
  • customer_id — bigint — NOT NULL — 고객ID, customer 테이블 참조
  • message_id — varchar(128) — mms 전송 성공시 통신사에서 제공한 id
  • mms_type — varchar(16) — NOT NULL — 메세지 유형. 유출 탐지(passport, account, email, phone, card), 기타(etc)
  • subject — varchar(256) — NOT NULL — 제목
  • content — varchar(2048) — NOT NULL — 본문
  • status — varchar(16) — NOT NULL — 상태, SendFail, SendSuccess, ReceiveFail, ReceiveSuccess
  • error_code — varchar(32) — 전송 오류 코드
  • error_message — varchar(256) — 오류 메세지
  • sent_at — datetime — 전송 시간
  • reported_at — datetime — 착신 리포팅 시간
  • created_at — datetime — NOT NULL — 생성시간

niceid_customer_authentication

  • id — bigint — 기본 키 — NOT NULL
  • phone_number — varchar(3000) — NOT NULL
  • gender — varchar(3000) — NOT NULL
  • name — varchar(3000) — NOT NULL
  • birth — varchar(3000) — NOT NULL
  • media — varchar(20) — NOT NULL
  • req_dtim — varchar(14)
  • res_uniq_id — varchar(24)
  • token_version_id — varchar(50)
  • token_val — varchar(100)
  • enc_ci — varchar(128)
  • enc_ci2 — varchar(128)
  • enc_di — varchar(108)
  • integrity_value — varchar(44)
  • result_cd — varchar(5)
  • status — varchar(10) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint

terms

  • id — bigint — 기본 키 — NOT NULL
  • released_at — date — NOT NULL
  • media — varchar(255) — NOT NULL
  • type — varchar(255) — NOT NULL
  • title — varchar(255)
  • content — text
  • status — varchar(255) — NOT NULL
  • deleted — bit(1) — NOT NULL
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

terms_agreement

  • id — bigint — 기본 키 — NOT NULL
  • terms_id — bigint
  • customer_id — bigint
  • status — varchar(255) — NOT NULL
  • created_at — datetime(6)
  • created_by — bigint
  • deleted_at — datetime(6)
  • last_modified_by — bigint
  • updated_at — datetime(6)

trade

  • id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint
  • start_at — datetime
  • end_at — datetime
  • phone_number — varchar(1024) — NOT NULL
  • birth — varchar(2048)
  • name — varchar(2048)
  • gender — varchar(2048) — NOT NULL
  • status — varchar(255) — NOT NULL
  • media — varchar(255) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • created_by — bigint
  • last_modified_by — bigint