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