juntell
Tables (16)
admins
- id — uuid — Primary key — NOT NULL
- email — text — NOT NULL
- name — text — NOT NULL
- role — text — NOT NULL
- is_active — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
call_order
- no — bigint — Primary key — NOT NULL
- datetime — timestamptz
- device — text
- petName — text
- capacity — text
- color — text
- register — text
- carrier — text
- name — text
- phone — text
- subPhone — text
- birthday — text
- plan — text
- discount — text
- benefit — text
- freebie — text
- installment — text
- totalMonthPayment — text
- form_link — text
- is_processed — boolean
- is_consultation — boolean
- phone_change — boolean
iphone17_order
- no — bigint — Primary key — NOT NULL
- datetime — timestamptz
- profile_id — uuid — Foreign key → profiles.id
- model — text
- pet_name — text
- capacity — text
- color — text
- register — text
- carrier — text
- name — text
- phone — text
- birthday — text
- plan — text
- discount — text
- benefit — text
- freebie — text
- freebie_second — text
- installment — text
- installment_principal — text
- form_link — text
- is_guaranteed_return — boolean
- guardian — text
- guardian_birthday — text
- guardian_phone — text
- is_processed — boolean
- is_consultation — boolean
- phone_change — boolean
job-post (Untitled)
news (Untitled2)
online_order
- no — bigint — Primary key — NOT NULL
- datetime — timestamptz
- profile_id — uuid — Foreign key → profiles.id
- device — text
- model — text
- petName — text
- capacity — text
- color — text
- register — text
- carrier — text
- name — text
- phone — text
- birthday — text
- plan — text
- discount — text
- benefit — text
- freebie — text
- installment — text
- installment_principal — text
- form_link — text
- source — text
- is_processed — boolean
- is_consultation — boolean
- phone_change — boolean
preorder-galaxy26
- id — uuid — Primary key — NOT NULL
- name — text — NOT NULL
- phone — varchar(20) — NOT NULL
- birthday — text
- emergency_contact — varchar(20)
- description — text
- mobile_carrier — text
- model — text
- color — text
- funnel — text
- is_colors — boolean
- is_processed — boolean
- created_at — timestamptz
- updated_at — timestamptz
preorder_17e_orders
- no — bigint — Primary key — NOT NULL
- datetime — timestamptz
- profile_id — uuid — Foreign key → profiles.id
- device — text
- model — text
- petName — text
- capacity — text
- color — text
- register — text
- carrier — text
- name — text
- phone — text
- birthday — text
- plan — text
- discount — text
- benefit — text
- freebie — text
- installment — text
- installment_principal — text
- form_link — text
- is_processed — boolean
- is_consultation — boolean
- phone_change — boolean
preorder_alarm
- id — uuid — Primary key — NOT NULL
- event_id — text — NOT NULL — 이벤트 구분 (foldable8_preorder_2026, iphone18_preorder_2026 등)
- name — text — NOT NULL
- phone — varchar(20) — NOT NULL
- birthday — text
- model — text
- color — text
- mobile_carrier — text
- register_type — text
- funnel — text
- auth_method — text
- kakao_id — text
- status — text — NOT NULL — 5단계 정규값: 신청중 | 공식신청서작성 | 송장등록 | 배송출발 | 배송도착
- is_processed — boolean — 레거시 boolean. status 로 대체되나 하위호환 위해 유지
- tracking_number — text
- courier — text
- shipped_at — timestamptz
- delivered_at — timestamptz
- created_at — timestamptz
- updated_at — timestamptz
- capacity — text
- plan — text
- profile_id — uuid — Foreign key → profiles.id — 로그인 유저 연결. null 이면 phone 매칭으로 폴백
- source_table — text — 백필 출처 테이블명. 신규 접수 건은 null
- source_id — text — 백필 원본 PK (문자열). (source_table, source_id) UNIQUE 로 재실행 안전
- linked_order_table — text — 2단계 자동승격 시 매칭된 주문 테이블명 (다형 참조, FK 불가)
- linked_order_no — bigint — 매칭된 주문 PK (다형 참조, FK 불가)
- form_link — text — 공식 신청서 URL. 승격 시 매칭된 주문에서 복사
- form_submitted_at — timestamptz — 2단계 진입 시각
- invoiced_at — timestamptz — 3단계(송장등록) 진입 시각. CSV 업로드가 채운다
- admin_memo — text
- updated_by — text — 마지막 변경 어드민 이메일 (admins.email)
preorder_iphone17e
- id — bigint — Primary key — NOT NULL
- model — text
- name — text — NOT NULL
- phone — text — NOT NULL
- birthday — text — NOT NULL
- mobile_carrier — text
- description — text
- status — text
- is_consultation — boolean
- created_at — timestamptz
preorder_notifications
- id — bigint — Primary key — NOT NULL
- preorder_id — uuid — Foreign key → preorder_alarm.id — NOT NULL
- status — text — NOT NULL — 어떤 단계 전이로 생성됐나 (preorder_alarm.status 와 동일 도메인)
- template_code — text — NOT NULL — solapi 알림톡 템플릿 코드
- phone — text — NOT NULL — 발송 시점 전화번호 스냅샷 (원본 변경돼도 이력 보존)
- payload — jsonb — NOT NULL — 치환변수 (기기명·운송장번호·택배사·신청서링크 등)
- state — text — NOT NULL — pending | approved | sent | failed | canceled
- approved_by — text — 발송 승인한 어드민 이메일 (admins.email)
- approved_at — timestamptz
- sent_at — timestamptz
- error — text — solapi 실패 사유. 재발송은 새 행으로 생성
- created_at — timestamptz — NOT NULL
preorder_order_link_rules
- id — bigint — Primary key — NOT NULL
- event_id — text — NOT NULL
- order_table — text — NOT NULL — 매칭 대상 주문 테이블 (online_order, s26_orders, iphone17_order, preorder_17e_orders)
- model_pattern — text — NOT NULL — 승격 트리거 모델 코드 배열. 빈 배열이면 전체 모델
- is_active — boolean — NOT NULL
- created_at — timestamptz — NOT NULL
preorder_s26_orders
- no — bigint — Primary key — NOT NULL
- datetime — timestamptz
- profile_id — uuid — Foreign key → profiles.id
- device — text
- model — text
- petName — text
- capacity — text
- color — text
- register — text
- name — text
- phone — text
- birthday — text
- plan — text
- discount — text
- benefit — text
- freebie — text
- installment — text
- installment_principal — text
- is_processed — boolean
- is_consultation — boolean
profiles
- id — uuid — Primary key — NOT NULL
- email — text
- full_name — text
- phone — text
- birthday — text
- kakao_id — text
- naver_id — text
- provider — text
- is_active — boolean
- created_at — timestamptz — NOT NULL
s26_orders
- no — bigint — Primary key — NOT NULL
- datetime — timestamptz
- profile_id — uuid — Foreign key → profiles.id
- device — text
- model — text
- petName — text
- capacity — text
- color — text
- register — text
- carrier — text
- name — text
- phone — text
- birthday — text
- plan — text
- discount — text
- benefit — text
- freebie — text
- installment — text
- installment_principal — text
- form_link — text
- is_processed — boolean
- is_consultation — boolean
- phone_change — boolean
user (uuid)
- Field