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