delivery_process

Tables (6)

deliveries (CopyOfUntitled)

  • delivery_id (id) — bigint — Primary key — NOT NULL — PK
  • order_option_id (주문옵션 id) — bigint — 주문옵션id
  • order_production_id (배송 종류) — bigint — 주문상품id
  • order_id (배송사) — bigint — 주문id
  • bundle_id (Field10) — bigint — 번들id
  • is_exchange (Field9) — boolean — 교환인지 여부
  • delivery_method_type (송장번호) — varchar — 배송방법
  • user_id (배송상태 status) — bigint — 고객id
  • seller_id (주문 완료 시각) — bigint — 판매자id
  • sales_user_id (Field7) — bigint — 판매자 sales_user id
  • receiver_name (Field4) — varchar — 수취인명
  • receiver_phone (Field5) — varchar — 수취인 전화번호
  • zip_code (Field6) — varchar — 우편번호
  • created_at (배송 시작 시각) — datetime — 생성시각
  • created_by (집화 시각) — varchar — 생성자
  • created_by_role (집화 알림톡 발송 시각) — varchar — 생성자role
  • updated_at (Field) — datetime — 변경시각
  • updated_by (Field2) — varchar — 변경자
  • updated_by_role (Field3) — varchar — 변경자role

delivery_process_events (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL — PK
  • delivery_process_id (id) — bigint — Foreign key → delivery_processes.id — NOT NULL — delivery_process id
  • event_type (Field2) — varchar — 이벤트 타입
  • event_time (Field3) — datetime — 이벤트가 발생한 시각
  • created_at (Field4) — datetime — 생성시각
  • created_by (Field5) — varchar — 생성자
  • created_by_role (Field6) — varchar — 생성자role

delivery_processes (Untitled)

  • id — bigint — Primary key — NOT NULL — PK
  • order_option_id (주문옵션 id) — bigint — 주문옵션id
  • delivery_method_type (배송 종류) — varchar — 배송방법
  • delivery_company (배송사) — varchar — 택배사이름
  • invoice_id (Field8) — varchar — 송장번호
  • status (배송상태 status) — varchar — 상태
  • payment_complete_time (주문 완료 시각) — datetime — 결제완료시각
  • delivery_start_time (배송 시작 시각) — datetime — 배송시작시각
  • delivery_pickup_time (집화 시각) — datetime — 집화시각
  • pickup_alimtalk_time (집화 알림톡 발송 시각) — datetime — 집화알림톡발송시각
  • delivery_complete_time (배송 완료 시각) — datetime — 배송완료시각
  • created_at (Field2) — datetime — 생성시각
  • created_by (Field3) — varchar — 생성자
  • created_by_role (Field4) — varchar — 생성자role
  • updated_at (Field5) — datetime — 변경시각
  • updated_by (Field6) — varchar — 변경자
  • updated_by_role (Field7) — varchar — 변경자role

delivery_processes (CopyOfUntitled2)

  • id — bigint — Primary key — NOT NULL — PK
  • order_option_id (주문옵션 id) — bigint — 주문옵션id
  • delivery_method_type (배송 종류) — varchar — 배송방법
  • delivery_company (배송사) — varchar — 택배사이름
  • invoice_id (Field8) — varchar — 송장번호
  • status (배송상태 status) — varchar — 상태
  • delivery_start_time (배송 시작 시각) — datetime — 배송시작시각
  • delivery_pickup_time (집화 시각) — datetime — 집화시각
  • pickup_alimtalk_time (집화 알림톡 발송 시각) — datetime — 집화알림톡발송시각
  • delivery_complete_time (배송 완료 시각) — datetime — 배송완료시각
  • created_at (Field2) — datetime — 생성시각
  • created_by (Field3) — varchar — 생성자
  • created_by_role (Field4) — varchar — 생성자role
  • updated_at (Field5) — datetime — 변경시각
  • updated_by (Field6) — varchar — 변경자
  • updated_by_role (Field7) — varchar — 변경자role

delivery_processes (CopyOfCopyOfUntitled2)

  • id — bigint — Primary key — NOT NULL — PK
  • order_option_id (주문옵션 id) — bigint — 주문옵션id
  • delivery_method_type (배송 종류) — varchar — 배송방법
  • delivery_company (배송사) — varchar — 택배사이름
  • invoice_id (Field8) — varchar — 송장번호
  • status (배송상태 status) — varchar — 상태
  • created_at (Field2) — datetime — 생성시각
  • created_by (Field3) — varchar — 생성자
  • created_by_role (Field4) — varchar — 생성자role
  • updated_at (Field5) — datetime — 변경시각
  • updated_by (Field6) — varchar — 변경자
  • updated_by_role (Field7) — varchar — 변경자role

delivery_processes (CopyOfCopyOfUntitled22)

  • id — bigint — Primary key — NOT NULL — PK
  • order_option_id (주문옵션 id) — bigint — 주문옵션id
  • status (배송상태 status) — varchar — 상태
  • delivery_start_time (배송 시작 시각) — datetime — 배송시작시각
  • delivery_pickup_time (집화 시각) — datetime — 집화시각
  • pickup_alimtalk_time (집화 알림톡 발송 시각) — datetime — 집화알림톡발송시각
  • delivery_complete_time (배송 완료 시각) — datetime — 배송완료시각
  • created_at (Field2) — datetime — 생성시각
  • created_by (Field3) — varchar — 생성자
  • created_by_role (Field4) — varchar — 생성자role
  • updated_at (Field5) — datetime — 변경시각
  • updated_by (Field6) — varchar — 변경자
  • updated_by_role (Field7) — varchar — 변경자role