soso-insuarance
테이블 (20)
GA
- id (Key) — Long — 기본 키 — NOT NULL
- status (Field13) — String
- name (Field) — String
- ceo_name (Field2) — String
- biz_number (Field3) — String
- biz_address (Field4) — String
- biz_type (Field5) — String
- biz_type_detail (Field6) — String
- phone (Field7) — String
- fax (Field8) — String
- created_admin_id (Field11) — Long
- last_updated_admin_id (Field12) — Long
- createdAt (Field9) — LocalDateTime
- updatedAt (Field10) — LocalDateTime
Log (로그)
admin (관리자)
- id (Key) — Long — 기본 키 — NOT NULL
- role_id (Field7) — Long
- company_id (Field8) — Long
- username (Field) — String
- password (Field2) — String
- name (Field3) — String
- phone (Field4) — String
- email (Field5) — String
- status (r) — String
- last_login_at (Field6) — LocasDateTime
- creat_admin_id (Field14) — Long
- last_update_admin_id (Field13) — Long
- createdAt (Field9) — LocalDateTime
- updatedAt (Field12) — LocalDateTime
admin_sms (문자연동정보)
- id (Key) — Long — 기본 키 — NOT NULL
- admin_id (Field) — Long
- api_key (Field3) — String
- identifier (Field2) — String
admin_sms_sender (발신번호)
- id (Key) — Long — 기본 키 — NOT NULL
- admin_sms_id (Field) — Long
- is_basic (Field3) — Boolean
- number (Field2) — String
- name (Field4) — String
category (보험 카테고리)
- id (Key) — Long — 기본 키 — NOT NULL
- Field
company (보험사)
- id (Key) — Long — 기본 키 — NOT NULL
- ga_id (Field15) — Long
- status (Field) — String
- type (Field2) — String
- name (Field3) — String
- ceo_name (Field4) — String
- biz_number (Field5) — String
- biz_address (Field6) — String
- phone (Field7) — String
- fax (Field8) — String
- manager_name (Field9) — String
- manager_phone (Field16) — String
- manager_email (Field17) — String
- created_admin_id (Field12) — Long
- last_updated_admin_id (Field13) — Long
- createdAt (Field10) — LocalDateTime
- updatedAt (Field11) — LocalDateTime
consult (상담)
- id (Key) — Long — 기본 키 — NOT NULL
- customer_id (Field) — Long
- content (Field2) — String
- writer_admin_id (Field3) — Long
- createdAt (Field4) — LocalDateTime
- updatedAt (Field5) — LocalDateTime
consultant (Untitled2)
- id (Key) — Long — 기본 키 — NOT NULL
- admin_id (Field) — Long
- ga_id (Field2) — Long
- number (Field3) — String
- contractedAt (Field4) — LocalDateTime
- role_id (Field5) — Long
consultant_detail (CopyOf관리자 메모)
- id (Key) — Long — 기본 키 — NOT NULL
- admin_id (Field) — Long
- content (Field2) — String
- writer_admin_id (Field3) — Long
- createdAt (Field4) — LocalDateTime
- updatedAt (Field5) — LocalDateTime
consultant_log (CopyOf로그)
customer (고객)
- id (Key) — Long — 기본 키 — NOT NULL
- name (고객명) — String
- username (Field) — String
- phone (Field2) — String
- birth (Field3) — String
- gender (Field4) — String
- insuarance_age (Field5) — String
- insuarance_age_increase_date (Field6) — LocalDate
- status (Field7) — String
- ga_id (Field15) — Long
- consultant_id (Field8) — Long
- createdAt (Field9) — LocalDateTime
- updatedAt (Field10) — LocalDateTime
- assignedAt (Field12) — LocalDateTime
- is_agree (Field11) — String
- is_agreed_at (Field13) — LocalDateTime
- note (Field14) — String
memo (관리자 메모)
- id (Key) — Long — 기본 키 — NOT NULL
- target_id (Field) — Long
- create_admin_id (Field3) — Long
- type (Field6) — String
- content (Field2) — String
- createdAt (Field4) — LocalDateTime
- updatedAt (Field5) — LocalDateTime
policy (보험 약관)
- id (Key) — Long — 기본 키 — NOT NULL
- name (Field) — String
- 개정시행일 (Field3) — LocalDate
- 표시화면 (Field2) — String
- is_use (Field9) — Boolean
- 동의구분 (Field4) — String
- content (Field5) — String
- isImportant (Field6) — Boolean
- createdAt (Field7) — LocalDateTime
- updatedAt (Field8) — LocalDateTime
policy_log (약관 개정 이력)
- id (Key) — Long — 기본 키 — NOT NULL
- policy_id (Field) — Long
- writer_admin_id (Field2) — Long
- updatedAt (Field3) — LocalDateTime
- note (Field4) — String
product (보험 상품)
- id (Key) — Long — 기본 키 — NOT NULL
- category_id (Field) — Long
- level (Field2) — Integer
- company_id (Field3) — Long
- name (Field4) — String
- 상품특징 (Field5) — String
- type (Field6) — String
- 고객정보입력폼? (Field8)
- 준법감시필 (Field7) — String
- 보장내용 (Field9) — String
- 가입예시 (Field10) — String
- 알아두실 사항 (Field11) — String
- createdAt (Field12) — LocalDateTime
- updatedAt (Field13) — LocalDateTime
role (권한)
- id (Key) — Long — 기본 키 — NOT NULL
- name (Field) — String
- note (Field2) — String
- isUse (Field3) — Boolean
- createdAt (Field4) — LocalDateTime
- updatedAt (Field5) — LocalDateTime
- created_admin_id (Field6) — Long
- last_update_admin_id (Field7) — Long
sms (Untitled3)
- id (Key) — Long — 기본 키 — NOT NULL
- sms_template_id (Field) — Long
- 발송요청일시 (Field2) — LocalDateTime
- 예약일시 (Field7) — LocalDateTime
- type (Field3) — String
- phone (Field4) — String
- status (Field5) — String
- 발송현황 (Field6) — String
- Field8
sms_template (문자 템플릿)
- id (Key) — Long — 기본 키 — NOT NULL
- name (Field) — String
- status (Field2) — Boolean
- type (Field5) — String
- tilte (Field3) — String
- content (Field4) — String
- createdAt (Field6) — LocalDateTime
- updatedAt (Field7) — LocalDateTime
- created_admin_id (Field8) — Long
- last_updated_admin_id (Field9) — Long
변수명? (Untitled)
- id (Key) — Long — 기본 키 — NOT NULL
- sms_template_id (Field) — Long
- name (Field2) — String