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