product
Tables (17)
Cart
- uid — VARCHAR(255) — Primary key
CartItem
- id — VARCHAR(255) — Primary key
- state — VARCHAR(255)
- additionalRequest — TEXT
- quantity — INT
- productRef — VARCHAR(255)
- productOptionId — VARCHAR(255)
- uid (uid2) — VARCHAR(255) — Foreign key → Cart.uid
Nodes
- id — INT
- value — VARCHAR(255) — NOT NULL
- parent_id — INT
Order
- oid — VARCHAR(255) — Primary key
- uid — VARCHAR(255)
- fbInvoiceNo — VARCHAR(255)
- additionalRequests — TEXT
- state — VARCHAR(255)
- reviewerName — VARCHAR(255)
OrderCardInfo
- cardId — VARCHAR(255)
- cardNumber — VARCHAR(255)
- cardExpiry — DATE
- cardBrand — VARCHAR(255)
- cardHolderName — VARCHAR(255)
- created — DATETIME
- updated — DATETIME
- oid — VARCHAR(255)
OrderDeliveryInfo
- oid — VARCHAR(255)
- name — VARCHAR(255)
- isDefault — BOOLEAN
- postalCode — VARCHAR(255)
- address — TEXT
- addressDetail — TEXT
- recipientFirstName — VARCHAR(255)
- recipientLastName — VARCHAR(255)
- recipientFirstNameKana — VARCHAR(255)
- recipientLastNameKana — VARCHAR(255)
- recipientPhoneNumber — VARCHAR(255)
- shippingType — VARCHAR(255)
- estimatedArrivalDate — DATE
OrderItem
- itemId (id) — VARCHAR(255) — Primary key
- productRef — VARCHAR(255)
- productOptionId — VARCHAR(255)
- orderConfirmationPageUrl — VARCHAR(255)
- customsInfo — TEXT
- oid (oid3) — VARCHAR(255) — Foreign key → Order.oid
- id (id2) — int — Foreign key → ProductVersion.id — NOT NULL
OrderPaymentInfo
- oid — VARCHAR(255)
- state — VARCHAR(255)
- method — VARCHAR(255)
OrderPriceInfo
- oid — VARCHAR(255)
- commissionRates — DECIMAL(10, 2)
- currencyRate — DECIMAL(10, 2)
- domesticShippingRates — DECIMAL(10, 2)
- internationalShippingRates — DECIMAL(10, 2)
- tariffRates — DECIMAL(10, 2)
OrderUserInfo
- oid — VARCHAR(255)
- lastName — VARCHAR(255)
- firstName — VARCHAR(255)
- lastNameKana — VARCHAR(255)
- firstNameKana — VARCHAR(255)
- phoneNumber — VARCHAR(255)
- email — VARCHAR(255)
Product
- id — int — Primary key — NOT NULL
- url — string
ProductExtra
- weight — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- id — int — Foreign key → ProductVersion.id — NOT NULL
ProductOption
- id — VARCHAR(255) — Primary key
- productId — VARCHAR(255)
- type — VARCHAR(255)
- price — DECIMAL(10, 2)
- stock — INT
- id (id2) — int — Foreign key → ProductVersion.id — NOT NULL
ProductVersion
- id — int — Primary key — NOT NULL
- pid — int — NOT NULL
- hash — VARCHAR(255)
- sku — VARCHAR(255)
- title — VARCHAR(255)
- sitename — VARCHAR(255)
- category — VARCHAR(255)
- thumbnailUrl — VARCHAR(255)
- details — TEXT
- price_default — DECIMAL(10, 2)
- price_discount — DECIMAL(10, 2)
- price_localShipping — DECIMAL(10, 2)
- stock — INT
- weight — DECIMAL(10, 2)
- hscode — VARCHAR(255)
- volume — DECIMAL(10, 2)
Untitled
- Key — VARCHAR(255) — Primary key — NOT NULL
- Key2 — VARCHAR(255) — Primary key — NOT NULL
- Key3 — VARCHAR(255) — Primary key — NOT NULL
- Key4 — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
Untitled2
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
Untitled3
- id — VARCHAR(255) — Primary key — NOT NULL
- productId — VARCHAR(255) — Primary key — NOT NULL
- data — jsonb