TrackingDB

Tables (14)

Copy Of Copy Of StateInfo (CopyOfCopyOf상품 상태 테이블)

  • Field (shop_order_number) — varchar(50)
  • Field (state) — tinyint
  • Field2 (mail_date) — datetime

Copy Of Order2 (CopyOfCopyOfUntitled)

  • PK (order_id) — varchar — Primary key — NOT NULL
  • Field (order_date) — datetime
  • Field (delivery_id) — varchar
  • Field (packagingOption) — varchar
  • Field (insurance) — boolean

Copy Of OrderInfo (CopyOf주문 테이블)

  • PK (order_id) — int — Primary key — NOT NULL
  • Field (order_date) — datetime
  • Field (delivery_id) — varchar

Copy Of PackageInfo (CopyOf패키지 테이블)

  • PK (package_id) — number — Primary key — NOT NULL
  • FK (product_id) — number — Primary key — NOT NULL
  • Field (unitPrice) — number
  • Field2 (reducedPrice) — number
  • Field (localShippingCost) — number
  • Field (pickUp) — number
  • Field (generalCustoms) — number
  • Field (securityPackaging) — number
  • Field (insurance) — number
  • Field (localShippingCost_manual) — number
  • Field (increasedPrice) — number
  • Field (additional) — number
  • Field (warehouse) — number
  • Field (InternationalShippingCost) — number

Copy Of PackageInfo2 (CopyOf패키지 테이블2)

  • PK (package_id) — int — Primary key — NOT NULL

Copy Of ProductInfo (CopyOf상품 테이블)

  • PK (product_id) — int — Primary key — NOT NULL
  • Field (shop_order_number) — varchar(50)
  • Field (product_name) — varchar(100)
  • Field (product_count) — int
  • Field (product_price) — int
  • Field (product_image) — varchar(100)
  • Field (shoppingmall) — varchar(20)
  • Field (tracking_number) — varchar(100)
  • Field (estimated_day) — datetime
  • Field (delivery_company) — varchar(20)
  • Field (state) — char(5)
  • Field (hs) — int
  • Field2 (shipping_country) — char(3)
  • Field3 (center) — varchar(5)
  • Field (is_tracking) — boolean
  • Field (order_id) — varchar

Copy Of StateInfo (CopyOf상품 상태 테이블)

  • Field (shop_order_number) — varchar(50)
  • Field (state) — tinyint
  • Field2 (mail_date) — datetime
  • Field (tracking_number) — varchar(100)

Copy Of UserInfo (CopyOf고객 테이블)

  • PK (user_id) — varchar — Primary key — NOT NULL
  • Field (user_name) — varchar
  • Field (phone_number) — varchar
  • Field (address) — varchar
  • Field (customsClearanceNumber) — varchar
  • Field (subscribeType) — varchar

Order (CopyOfUntitled)

  • PK (order_id) — varchar — Primary key — NOT NULL
  • PK (user_id) — varchar — Foreign key → UserInfo.PK — NOT NULL
  • Field (order_date) — datetime
  • Field (delivery_id) — varchar
  • Field (packagingOption) — varchar
  • Field (insurance) — boolean

ProductInfo (상품 테이블)

  • PK (product_id) — int — Primary key — NOT NULL
  • Field (shop_order_number) — varchar(50)
  • Field (product_name) — varchar(100)
  • Field (product_count) — int
  • Field (product_price) — int
  • Field (product_image) — varchar(100)
  • Field (shoppingmall) — varchar(20)
  • Field (tracking_number) — varchar(100)
  • Field (estimated_day) — datetime
  • Field (delivery_company) — varchar(20)
  • Field (state) — char(5)
  • Field (hs) — int
  • Field2 (shipping_country) — char(3)
  • Field3 (center) — varchar(5)
  • Field (is_tracking) — boolean
  • Field (order_id) — varchar

ProductInfo (CopyOfUntitled3)

  • PK (product_id) — varchar — Primary key — NOT NULL
  • FK (order_id) — varchar — Foreign key → Order.PK — NOT NULL
  • Field (product_name) — varchar
  • Field (product_image) — varchar
  • Field (shoppingMall) — varchar
  • Field (trackingNumber) — varchar
  • Field (estimatedDay) — datetime
  • Field (deliveryCompany) — varchar
  • Field (isTracking) — boolean
  • Field (shipped) — boolean
  • Field (refund) — boolean
  • Field (canceled) — boolean
  • Field (mainReceivedDate) — datetime
  • Field (product_number) — varchar — NOT NULL

ProductInfo (상품)

  • PK (product_id) — int — Primary key — NOT NULL
  • Field (shop_order_number) — varchar(50)
  • Field (product_name) — varchar(100)
  • Field (product_count) — int
  • Field (product_price) — int
  • Field (product_image) — varchar(100)
  • Field (shoppingmall) — varchar(20)
  • Field (tracking_number) — varchar(100)
  • Field (estimated_day) — datetime
  • Field (delivery_company) — varchar(50)
  • Field (state) — char(5)
  • Field (is_tracking) — boolean
  • Field (order_id) — varchar
  • Field (email_state) — tinyint
  • Field (email_date) — datetime
  • Field (product_code) — varchar(50)

StateInfo (상품 상태 테이블)

  • PK (product_state_id) — int — Primary key — NOT NULL
  • Field (shop_order_number) — varchar(50)
  • Field (shipped) — boolean
  • Field (refund) — boolean
  • Field (canceled) — boolean
  • Field (issue) — boolean
  • Field (reg_date) — datetime
  • Field (shipped_date) — datetime
  • Field2 (refund_date) — datetime
  • Field3 (canceled_date) — datetime

UserInfo (CopyOfUntitled2)

  • PK (user_id) — varchar — Primary key — NOT NULL
  • Field (user_name) — varchar
  • Field (phone_number) — varchar
  • Field (address) — varchar
  • Field (customsClearanceNumber) — varchar
  • Field (subscribeType) — varchar