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