zicgo__

Tables (12)

companies

  • company_id — BIGINT
  • company_name — VARCHAR(100) — NOT NULL
  • business_no — VARCHAR(20) — 추가 정의 필요: 사업자번호 사용 여부
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

contact_groups

  • contact_group_id — BIGINT
  • company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
  • group_name — VARCHAR(100) — NOT NULL
  • default_yn — TINYINT(1) — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

contacts

  • contact_id — BIGINT
  • company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
  • contact_group_id — BIGINT — Foreign key → contact_groups.contact_group_id
  • contact_name — VARCHAR(80) — NOT NULL
  • company_name — VARCHAR(100)
  • mobile_number — VARCHAR(30)
  • fax_number — VARCHAR(30)
  • email — VARCHAR(150) — 추가 정의 필요: 스토리보드상 이메일 표시 여부
  • memo — VARCHAR(500)
  • created_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • CHECK — (mobile_number IS NOT NULL OR fax_number IS NOT NULL) — NOT NULL

fax_numbers

  • fax_number_id — BIGINT
  • company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
  • fax_number — VARCHAR(30) — NOT NULL
  • display_name — VARCHAR(100)
  • default_yn — TINYINT(1) — NOT NULL
  • use_yn — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

fax_recipients

  • fax_recipient_id — BIGINT
  • fax_send_id — BIGINT — Foreign key → fax_sends.fax_send_id — NOT NULL
  • recipient_name — VARCHAR(80)
  • company_name — VARCHAR(100)
  • fax_number — VARCHAR(30) — NOT NULL
  • result_status — VARCHAR(20) — NOT NULL
  • result_code — VARCHAR(50) — 추가 정의 필요: 외부 팩스 API 결과 코드
  • result_message — VARCHAR(255)
  • external_fax_id — VARCHAR(100) — 추가 정의 필요: 외부 팩스 API 식별자
  • sent_at — DATETIME
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • CHECK — (result_status IN ('WAITING', 'SENDING', 'SUCCESS', 'FAIL', 'CANCELLED'))

fax_send_files

  • fax_send_file_id — BIGINT
  • fax_send_id — BIGINT — Foreign key → fax_sends.fax_send_id — NOT NULL
  • file_id — BIGINT — Foreign key → file_uploads.file_id — NOT NULL
  • page_count — INT — 추가 정의 필요: 문서 변환 후 페이지 수
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

fax_sends

  • fax_send_id — BIGINT
  • company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
  • sender_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • fax_number_id — BIGINT — Foreign key → fax_numbers.fax_number_id — NOT NULL
  • fax_type — VARCHAR(20) — NOT NULL
  • send_method — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200) — 추가 정의 필요: 스토리보드상 제목 필드 사용 여부
  • request_status — VARCHAR(20) — NOT NULL
  • reserved_at — DATETIME
  • requested_at — DATETIME
  • completed_at — DATETIME
  • total_count — INT — NOT NULL
  • success_count — INT — NOT NULL
  • fail_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • CHECK — (fax_type IN ('NORMAL', 'BULK', 'AD'))
  • CHECK — (send_method IN ('IMMEDIATE', 'RESERVED'))
  • CHECK — (request_status IN ('READY', 'REQUESTED', 'SENDING', 'COMPLETED', 'FAILED', 'CANCELLED'))

file_uploads

  • file_id — BIGINT
  • company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
  • uploaded_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • file_type — VARCHAR(30) — NOT NULL
  • original_name — VARCHAR(255) — NOT NULL
  • stored_name — VARCHAR(255) — NOT NULL
  • storage_path — VARCHAR(500) — NOT NULL — 추가 정의 필요: 파일 저장 위치
  • mime_type — VARCHAR(100)
  • file_size — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • CHECK — (file_type IN ('FAX_ATTACHMENT'))

sender_numbers

  • sender_number_id — BIGINT
  • company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
  • sender_number — VARCHAR(30) — NOT NULL
  • display_name — VARCHAR(100)
  • default_yn — TINYINT(1) — NOT NULL
  • use_yn — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

sms_recipients

  • sms_recipient_id — BIGINT
  • sms_send_id — BIGINT — Foreign key → sms_sends.sms_send_id — NOT NULL
  • recipient_name — VARCHAR(80)
  • company_name — VARCHAR(100)
  • mobile_number — VARCHAR(30) — NOT NULL
  • result_status — VARCHAR(20) — NOT NULL
  • result_code — VARCHAR(50) — 추가 정의 필요: 외부 문자 API 결과 코드
  • result_message — VARCHAR(255)
  • external_message_id — VARCHAR(100) — 추가 정의 필요: 외부 문자 API 식별자
  • sent_at — DATETIME
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • CHECK — (result_status IN ('WAITING', 'SENDING', 'SUCCESS', 'FAIL', 'CANCELLED'))

sms_sends

  • sms_send_id — BIGINT
  • company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
  • sender_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • sender_number_id — BIGINT — Foreign key → sender_numbers.sender_number_id — NOT NULL
  • send_method — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200)
  • message_body — TEXT — NOT NULL
  • request_status — VARCHAR(20) — NOT NULL
  • reserved_at — DATETIME
  • requested_at — DATETIME
  • completed_at — DATETIME
  • total_count — INT — NOT NULL
  • success_count — INT — NOT NULL
  • fail_count — INT — NOT NULL
  • expected_point — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • CHECK — (send_method IN ('IMMEDIATE', 'RESERVED'))
  • CHECK — (request_status IN ('READY', 'REQUESTED', 'SENDING', 'COMPLETED', 'FAILED', 'CANCELLED'))

users

  • user_id — BIGINT
  • company_id — BIGINT — Foreign key → companies.company_id — NOT NULL
  • login_id — VARCHAR(80) — NOT NULL
  • user_name — VARCHAR(80) — NOT NULL
  • email — VARCHAR(150)
  • phone_number — VARCHAR(30)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME