test

Tables (41)

acl_group

  • id — uuid — Primary key — NOT NULL — key
  • general_agency_id — uuid — GA사
  • created_at — TIMESTAMPTZ — NOT NULL — 생성일
  • updated_at — TIMESTAMPTZ — 수정일
  • created_by — UUID — NOT NULL — 생성자
  • updated_by — UUID — 수정자
  • name — VARCHAR(100) — NOT NULL — 권한
  • description — VARCHAR(300) — 권한
  • used — int2 — NOT NULL — 사용여부(0:미사용

acl_group_resource

  • permission_action — varchar(20) — Primary key — NOT NULL
  • resource_key — varchar(100) — Primary key — NOT NULL
  • acl_group_id — uuid — Foreign key → acl_group.id — NOT NULL — 권한그룹
  • created_at — timestamptz — NOT NULL — (최근)
  • created_by — uuid — NOT NULL — (최근)

audit_log

  • id — uuid — Primary key — NOT NULL — Key
  • general_agency_id — uuid — GA사
  • insurance_enrollment_id — uuid — 보험상품
  • created_member_id — uuid — NOT NULL — 생성자
  • created_member_name — varchar(100) — NOT NULL — 당시
  • created_at — timestamptz — NOT NULL — 생성일시
  • event_type — varchar(50) — (ActionType)
  • menu_type — varchar(50) — (AccessResourceKey)
  • target_changes — jsonb — (TargetChange
  • ip_address — inet — NOT NULL — 요청자
  • user_agent — text — NOT NULL — User-Agent
  • request_url — varchar(300) — NOT NULL — endPoint
  • method — varchar(50) — NOT NULL — (MethodType)
  • is_detailed — int2 — NOT NULL — 상세모달
  • target_id — uuid — 변경대상의

backup_data

  • id — uuid — Primary key — NOT NULL — key
  • table_name — varchar(50) — NOT NULL — 원본
  • datum — jsonb — NOT NULL — 보존데이터
  • created_at — timestamptz — NOT NULL — 생성일
  • ended_at — timestamptz — NOT NULL — 파기

business

  • id — uuid — Primary key — NOT NULL

general_agency

  • id — uuid — Primary key — NOT NULL — key
  • ownership_type — varchar(20) — NOT NULL — (OwnershipType)
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — 수정일
  • deleted_at — timestamptz — 삭제일
  • created_by — uuid — NOT NULL — 생성자
  • updated_by — uuid — 수정자
  • deleted_by — uuid — 삭제자
  • type — varchar(30) — NOT NULL — (CompanyRegistrationType)
  • name — varchar(100) — NOT NULL — 상호명
  • representative_name — varchar(100) — NOT NULL — 대표자명
  • representative_telephone — varchar(20) — 대표번호
  • registration_number — varchar(20) — 사업자
  • address1 — varchar(6) — 사업자
  • address2 — varchar(100) — 사업자
  • address3 — varchar(50) — 사업자
  • category_name — varchar(100) — 사업자
  • item_name — varchar(100) — 사업자
  • paused_at — timestamptz — 사용중지일
  • fax_number — varchar(20) — 팩스번호

insurance_category

  • id — uuid — Primary key — NOT NULL — key
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자
  • name — varchar(100) — NOT NULL — 카테고리명
  • introdution — text — 카테고리
  • icon — bytea — NOT NULL — 카테고리
  • used — int2 — NOT NULL — 사용여부(0:미사용
  • sequence — int2 — NOT NULL — 전시순서(최초
  • memo — varchar(300) — 메모
  • icon_type — varchar(30) — 카테고리
  • insurance_category_filter_template_content_ids — uuid — 필터별

insurance_category_details

  • id — uuid — Primary key — NOT NULL — key
  • insurance_category_id — uuid — Foreign key → insurance_category.id — NOT NULL — 보험
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자
  • name — varchar(20) — NOT NULL — 분류명
  • content — text — 내용
  • memo — varchar(300) — 메모
  • sequence — int2 — NOT NULL — 전시순서(최초

insurance_category_filter_mapping

  • insurance_category_group_id — uuid — Foreign key → insurance_category_group.id — NOT NULL — 보험
  • insurance_category_filter_template_id — uuid — Foreign key → insurance_category_filter_template.id — NOT NULL — 보험

insurance_category_filter_template

  • id — uuid — Primary key — NOT NULL — key
  • name — varchar(50) — NOT NULL — 템플릿
  • input_type — varchar(50) — NOT NULL — (InputType)필터유형
  • required — boolean — NOT NULL — true:
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자

insurance_category_filter_template_content

  • id — uuid — Primary key — NOT NULL — key
  • insurance_category_filter_template_id — uuid — Foreign key → insurance_category_filter_template.id — NOT NULL — 보험
  • name — varchar(50) — NOT NULL — 이름

insurance_category_group

  • id — uuid — Primary key — NOT NULL — key
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자
  • name — varchar(50) — 그룹명
  • used — int2 — 사용여부(0:미사용
  • sequence — int2 — 전시순서(최초
  • icon — bytea — 그룹
  • memo — varchar(300) — 메모
  • icon_type — varchar(30) — 그룹

insurance_category_mapping

  • insurance_category_id — uuid — Foreign key → insurance_category.id — NOT NULL — 보험
  • insurance_category_group_id — uuid — Foreign key → insurance_category_group.id — NOT NULL — 보험
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자
  • mapping_sequence — int2 — NOT NULL — 보험

insurance_company

  • id — uuid — Primary key — NOT NULL — key
  • general_agency_id — uuid — Foreign key → general_agency.id — NOT NULL — GA사
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자
  • paused_at — timestamptz — 사용중지일
  • terminated_at — timestamptz — 계약해지일
  • type — varchar(100) — NOT NULL — (InsuranceCompanyType)
  • name — varchar(30) — 보험사명
  • representative_name — varchar(40) — 대표자명
  • representative_telephone — varchar(13) — 대표번호
  • registration_number — varchar(10) — 사업자등록번호
  • adress1 — varchar(6) — 주소1
  • adress2 — varchar(100) — 주소2
  • adress3 — varchar(50) — 주소3
  • fax_number — varchar(20) — 팩스번호
  • manager_name — varchar(20) — 담당자명
  • manager_cellphone_number — varchar(20) — 담당자전화번호
  • manager_email — varchar(100) — 담당자이메일
  • memo — varchar(100) — 메모

insurance_company_document

  • id — uuid — Primary key — NOT NULL — key
  • insurance_company_id — uuid — Foreign key → insurance_company.id — NOT NULL — 보험사
  • id2 — uuid — Foreign key → insurance_company.general_agency_id — NOT NULL — key
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuiid — 수정자
  • document_type — varchar(50) — NOT NULL — (InsuranceDocumentType)
  • path — varchar(500) — 파일경로

insurance_contract

  • id — uuid — Primary key — NOT NULL — key
  • insurance_enrollment_id — uuid — Foreign key → insurance_enrollment.id — NOT NULL — 보험상품
  • insurance_company_id — uuid — Foreign key → insurance_enrollment.insurance_product_id — NOT NULL — 보험사
  • . — VARCHAR(255) — Foreign key → insurance_enrollment.member_id
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자
  • deleted_at — timestamptz — 삭제일
  • deleted_by — uuid — 삭제자
  • insurance_premium_amount — int8 — 보험료(원)
  • receipt_at — timestamptz — 영수일
  • policyholder_name — varchar(20) — 계약자
  • insured_name — varchar(20) — 피보험자
  • application_number — varchar(40) — 청약번호
  • policy_number — varchar(40) — 증권번호
  • payment_period — varchar(20) — (PaymentPeriodType
  • maturity_at — varchar(20) — (MaturityPeriodType

insurance_enrollment

  • id — uuid — Primary key — NOT NULL — key
  • insurance_product_id — uuid — Foreign key → insurance_product.id — NOT NULL — 보험상품
  • member_id — uuid — Foreign key → member.id — NOT NULL — 회원
  • business_id — uuid — 사업자
  • status — varchar(50) — NOT NULL — (InsuranceEnrollmentStatus)
  • advisor_member_id — uuid — 담당자(
  • member_name — varchar(100) — NOT NULL — (해당
  • member_birth — date — (해당
  • member_cellphone_number — varchar(20) — (해당
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • assigned_at — timestamptz — 배정일
  • memo — varchar(1000) — 특이사항
  • gender — varchar(10) — (MemberGender)
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자

insurance_enrollment_memo_history

  • id — uuid — Primary key — NOT NULL — key
  • insurance_enrollment_id — uuid — Foreign key → insurance_enrollment.id — NOT NULL — 보험상품
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자
  • content — varchar(1000) — NOT NULL — 내용

insurance_product

  • id — uuid — Primary key — NOT NULL — key
  • insurance_company_id — uuid — Foreign key → insurance_company.id — NOT NULL — 보험사
  • insurance_category_list — uuid — Foreign key → insurance_category.id — NOT NULL — 보험
  • type — varchar(20) — NOT NULL — (InsuranceProductType)
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자
  • name — varchar(100) — NOT NULL — 보험상품명
  • description — varchar(25) — 상품특징
  • used — int2 — 전시여부(0:전시중지
  • compliance_review — varchar(200) — NOT NULL — 준법감시필
  • content — jsonb — NOT NULL — (InsuranceProductContent)
  • code — varchar(40) — NOT NULL — 보험상품

insurance_product_category_sequence

  • insurance_product_id — uuid — Foreign key → insurance_product.id — NOT NULL — 보험상품
  • insurance_category_id — uuid — Foreign key → insurance_category.id — NOT NULL — 보험카테고리(2depth)
  • sequence — int2 — NOT NULL — 전시순서
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자

insurance_product_customer_form

  • id — uuid — Primary key — NOT NULL — key
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자
  • name — varchar(50) — NOT NULL — 입력폼명
  • inputType — varchar(50) — NOT NULL — (InputType)필터유형
  • required — int2 — 필수입력여부(0:선택
  • regex — varchar(300) — 정규표현식(NUMBER
  • memo — varchar(300) — 메모

insurance_product_customer_form_mapping

  • insurance_product_customer_form_id — uuid — Foreign key → insurance_product_customer_form.id — NOT NULL — 고객정보입력폼
  • insurance_product_id — uuid — Foreign key → insurance_product.id — NOT NULL — 보험상품
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자

insurance_product_document

  • id — uuid — Primary key — NOT NULL — key
  • insurance_product_id — uuid — Foreign key → insurance_product.id — NOT NULL — 보험상품
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuif — NOT NULL — 생성자
  • updated_at — timestamptz — NOT NULL — 수정일
  • updated_by — uuid — NOT NULL — 수정자
  • document_type — varchar(50) — NOT NULL — (InsuranceProductDocumentType)
  • path — varchar(500) — NOT NULL — 파일
  • sequence — int2 — NOT NULL — 파일

insurance_product_terms_history

  • id — uuid — Primary key — NOT NULL — key
  • contents — jsonb — NOT NULL — (InsuranceProductTerms
  • started_at — timestamptz — NOT NULL — 시행일
  • created_at — timestamptz — NOT NULL — 생성일

mapping_member_acl_group

  • member_id — uuid — Foreign key → member.id — NOT NULL — 회원
  • acl_group_id — uuid — Foreign key → acl_group.id — NOT NULL — 권한그룹
  • created_at — timestamptz — NOT NULL — 생성일

mapping_member_bauth

  • bauthId — uuid — Primary key — NOT NULL — key
  • member_id — uuid — Foreign key → member.id — NOT NULL — key
  • created_at — timestamptz — NOT NULL — 생성일

mapping_member_business

  • member_id — uuid — Foreign key → member.id — NOT NULL — 회원
  • business_id — uuid — Foreign key → business.id — NOT NULL — 사업자

mapping_member_general_agency

  • member_id — uuid — Foreign key → member.id — NOT NULL — 회원
  • general_agency_id — uuid — Foreign key → general_agency.id — NOT NULL — GA사
  • created_at — timestamptz — NOT NULL — 생성일
  • contracted_at — timestamptz — 계약일
  • unique_number — varchar(14) — 고유번호

mapping_terms_general_agency

  • general_agency_id — uuid — Foreign key → general_agency.id — NOT NULL — GA사
  • terms_id — uuid — Foreign key → terms.id — NOT NULL — 이용약관
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • sequence — smallint — NOT NULL — 순번

member

  • id — uuid — Primary key — NOT NULL — key
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — 수정일
  • deleted_at — timestamptz — 삭제일
  • created_member_id — uuid — NOT NULL — 생성자
  • updated_member_id — uuid — 수정자
  • deleted_member_id — uuid — 삭제자
  • username — varchar(100) — 회원
  • password — varchar(255) — 비밀번호
  • name — varchar(100) — 이름
  • cellphone_number — varchar(20) — 휴대폰번호
  • ci — varchar(200) — ci
  • birth — date — 생년월일
  • email — varchar(100) — 이메일
  • memo — varchar(100) — 메모
  • started_at — timestamptz — 시행적용일
  • member_type — varchar(30) — NOT NULL — (MemberType)

member_note

  • id — uuid — Primary key — NOT NULL — key
  • member_id — uuid — Foreign key → member.id — NOT NULL — 회원
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_att — tiemstamptz — 수정일
  • updated_by — uuid — 수정자
  • content — varchar(1000) — NOT NULL — 메모/상담
  • type — varchar(50) — NOT NULL — (NoteType)

member_sender_info

  • id — uuid — Primary key — NOT NULL — key
  • message_vendor_account_id — uuid — Foreign key → message_vendor_account.id — NOT NULL — 문자업체연동정보
  • created_at — timestamptz — NOT NULL — 생성일
  • name — varchar(20) — NOT NULL — 관리용
  • phone_number — varchar(12) — NOT NULL — 발신번호
  • created_by — VARCHAR(255)

member_sender_info_default

  • member_id — uuid — Foreign key → member.id — NOT NULL — 회원
  • member_sender_info_id — uuid — Foreign key → member_sender_info.message_vendor_account_id — NOT NULL — 회원
  • created_at — timestamptz — NOT NULL — 생성일

member_terms_agreement

  • id — uuid — Primary key — NOT NULL — key
  • terms_id — uuid — Foreign key → terms.id — NOT NULL — 이용약관
  • member_id — uuid — Foreign key → member.id — NOT NULL — 회원
  • agreed_at — timestamptz — NOT NULL — 약관동의일
  • cancelled_at — timestamptz — 약관철회일
  • cancelled_by — uuid — 약관철회자

message_history

  • id — uuid — Primary key — NOT NULL — key
  • message_template_id — uuid — Foreign key → message_template.id — NOT NULL — 메시지
  • member_sender_info_id — uuid — Foreign key → member_sender_info.id — NOT NULL — 회원
  • message_reservation_id — uuid — Foreign key → message_reservation.id — NOT NULL — 예약메시지
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • insurance_enrollment_id — uuid — 보험상품
  • title — varchar(50) — 제목
  • content — text — NOT NULL — 내용
  • message_type — varchar(10) — NOT NULL — (MessageType)
  • sent_at — timestamptz — NOT NULL — 전송일
  • receiver_cellphone_number — varchar(20)

message_reservation

  • id — uuid — Primary key — NOT NULL — key
  • message_template_id — uuid — Foreign key → message_template.id — NOT NULL — 메시지
  • member_sender_info_id — uuid — Foreign key → member_sender_info.id — NOT NULL — 회원
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • cancelled_at — timestamptz — 취소일
  • cancelled_by — uuid — 취소자
  • insurance_product_id — uuid — 보험상품
  • receiver_member_id — uuid — NOT NULL — 수신자
  • receiver_cellphone_number — varchar(20) — NOT NULL — 수신자
  • title — varchar(50) — 제목
  • content — text — NOT NULL — 내용
  • message_type — varchar(10) — NOT NULL — (MessageType)
  • scheduled_at — timestamptz — NOT NULL — 예약전송일
  • status — varchar(30) — NOT NULL — (MessageReservationStatus)

message_template

  • id — uuid — Primary key — NOT NULL — key
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자
  • deleted_at — timestamptz — 삭제일
  • deleted_by — uuid — 삭제자
  • message_template_name — varchar(30) — 메시지
  • message_category — varchar(30) — NOT NULL — (MessageCategory)
  • used — int2 — NOT NULL — 사용여부
  • title — varchar(30) — 메시지
  • content — text — 메시지
  • type — varchar(10) — NOT NULL — (MessageType)

message_template_variable

  • id — uuid — Primary key — NOT NULL — key
  • created_at — timestamptz — NOT NULL — 생성일
  • created_by — uuid — NOT NULL — 생성자
  • updated_at — timestamptz — 수정일
  • updated_by — uuid — 수정자
  • name — varchar(30) — NOT NULL — 변수명
  • used — int2 — NOT NULL — 사용여부

message_vendor_account

  • id — uuid — Primary key — NOT NULL — key
  • created_at — timestamptz — NOT NULL — 생성일
  • updated_at — timestamptz — 수정일
  • created_by — uuid — NOT NULL — 생성자
  • updated_by — uuid — 수정자
  • api_key — varchar(100) — NOT NULL — apiKey
  • user_id — varchacr(100) — NOT NULL — 계정
  • memo — varchar(100) — 메모
  • is_test_mode — Boolean — 테스트모드
  • message_provider_type — varchar(100) — NOT NULL — (MessageProviderType)
  • name — varchar(20) — NOT NULL — 관리용

terms

  • id — uuid — Primary key — NOT NULL — key
  • created_at — timestamptz — NOT NULL — 생성일
  • deleted_at — timestamptz — 삭제일
  • created_by — uuid — NOT NULL — 생성자
  • deleted_by — uuid — 삭제자
  • used — int2 — NOT NULL — 사용여부
  • required — int2 — NOT NULL — 필수약관여부(-1:
  • title — varchar(50) — 제목
  • content — text — 내용
  • type — varchar(30) — NOT NULL — (TermsType)
  • started_at — timestamptz — NOT NULL — 시행일
  • revised_id — revised_id — 약관수정(최신본으로
  • reason — varchar(50) — 약관수정
  • location — varchar(30) — (TermsLocation)

verification_email

  • email — varchar(100) — Primary key — NOT NULL — 이메일
  • code — varchar(6) — NOT NULL — 인증번호
  • requested_at — timestamptz — 요청일
  • certificated_at — timestamptz — 인증일