세이프아이디
테이블 (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