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 — 인증일