LLINK(vendure)

Tables (83)

address

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • fullName — varchar — NOT NULL
  • company — varchar — NOT NULL
  • streetLine1 — varchar — NOT NULL
  • streetLine2 — varchar — NOT NULL
  • city — varchar — NOT NULL
  • province — varchar — NOT NULL
  • postalCode — varchar — NOT NULL
  • phoneNumber — varchar — NOT NULL
  • defaultShippingAddress — bool — NOT NULL
  • defaultBillingAddress — bool — NOT NULL
  • customerId — int4 — Foreign key → customer.id
  • countryId — int4 — Foreign key → region.id

administrator

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • firstName — varchar — NOT NULL
  • lastName — varchar — NOT NULL
  • emailAddress — varchar — NOT NULL
  • userId — int4 — Foreign key → user.id

asset

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • name — varchar — NOT NULL
  • type — varchar — NOT NULL
  • mimeType — varchar — NOT NULL
  • width — int4 — NOT NULL
  • height — int4 — NOT NULL
  • fileSize — int4 — NOT NULL
  • source — varchar — NOT NULL
  • preview — varchar — NOT NULL
  • focalPoint — text

asset_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • assetId — int4 — Foreign key → asset.id — NOT NULL

asset_tags_tag

  • assetId — int4 — Foreign key → asset.id — NOT NULL
  • tagId — inr4 — Foreign key → tag.id — NOT NULL

authentication_method

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • identifier — varchar
  • passwordHash — varchar
  • verificationToken — varchar
  • passwordResetToken — varchar
  • identifierChangeToken — varchar
  • pendingIdentifier — varchar
  • strategy — varchar
  • externalIdentifier — varchar
  • metadata — text
  • type — varchar — NOT NULL
  • userId — int4 — Foreign key → user.id

channel

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • code — varchar — NOT NULL — Unique
  • token — varchar — NOT NULL — Unique
  • description — varchar
  • defaultLanguageCode — varchar — NOT NULL
  • availableLanguageCodes — text
  • defaultCurrencyCode — varchar — NOT NULL
  • availableCurrencyCodes — text
  • trackInventory — bool — NOT NULL
  • outOfStockThreshold — int4 — NOT NULL
  • pricesIncludeTax — bool — NOT NULL
  • sellerId — int4 — Foreign key → seller.id
  • defaultTaxZoneId — int4 — Foreign key
  • defaultShippingZoneId — int4 — Foreign key

collection

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • isRoot — bool — NOT NULL
  • position — int4 — NOT NULL
  • isPrivate — bool — NOT NULL
  • filters — text — NOT NULL
  • inheritFilters — bool — NOT NULL
  • featuredAssetId — int4 — Foreign key → asset.id
  • parentId — int4 — Foreign key → collection.id

collection_asset

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • position — int4 — NOT NULL
  • collectionId — int4 — Foreign key → collection.id — NOT NULL
  • assetId — int4 — Foreign key → asset.id — NOT NULL

collection_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • collectionId — int4 — Foreign key → collection.id — NOT NULL

collection_closure

  • id_ancestor — int4 — Primary key — NOT NULL — FK로 collection 테이블을 참조(* ERD Cloud로 표현 불가)
  • id_descendant — int4 — Foreign key → collection.id — NOT NULL

collection_product_variants_product_variant

  • collectionId — int4 — Foreign key → collection.id — NOT NULL
  • productVariantId — int4 — Foreign key → product_variant.id — NOT NULL

collection_translation

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • languageCode — varchar — NOT NULL
  • name — varchar — NOT NULL
  • slug — varchar — NOT NULL
  • description — text — NOT NULL
  • baseId — int4 — Foreign key → collection.id

customer

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • title — varchar
  • firstName — varchar — NOT NULL
  • lastName — varchar — NOT NULL
  • phoneNumber — varchar
  • emailAddress — varchar — NOT NULL
  • userId — int4 — Foreign key → user.id

customer_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • customerId — int4 — Foreign key → customer.id — NOT NULL

customer_group

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • name — varchar — NOT NULL

customer_groups_customer_group

  • customerId — int4 — Foreign key → customer.id — NOT NULL
  • customerGroupId — int4 — Foreign key → customer_group.id — NOT NULL

facet

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • isPrivate — bool — NOT NULL
  • code — varchar — NOT NULL — Unique

facet_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • facetId — int4 — Foreign key → facet.id — NOT NULL

facet_translation

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • languageCode — varchar — NOT NULL
  • name — varchar — NOT NULL
  • baseId — int4 — Foreign key → facet.id

facet_value

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • code — varchar — NOT NULL
  • facetId — int4 — Foreign key → facet.id — NOT NULL

facet_value_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • facetValueId — int4 — Foreign key → facet_value.id — NOT NULL

facet_value_translation

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • languageCode — varchar — NOT NULL
  • name — varchar — NOT NULL
  • baseId — int4 — Foreign key → facet_value.id

fulfillment

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • state — varchar — NOT NULL
  • trackingCode — varchar — NOT NULL
  • method — varchar — NOT NULL
  • handlerCode — varchar — NOT NULL

global_settings

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • availableLanguages — text — NOT NULL
  • trackInventory — bool — NOT NULL
  • outOfStockThreshold — int4 — NOT NULL

history_entry

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • type — varchar — NOT NULL
  • isPublic — bool — NOT NULL
  • data — text — NOT NULL
  • discriminator — varchar — NOT NULL
  • orderId — int4 — Foreign key → order.id
  • administratorId — int4 — Foreign key → administrator.id
  • customerId — int4 — Foreign key → customer.id

job_record

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • queueName — varchar — NOT NULL
  • data — text
  • state — varchar — NOT NULL
  • progress — int4 — NOT NULL
  • result — text
  • error — varchar
  • startedAt — timestamp(6)
  • settledAt — timestamp(6)
  • isSettled — bool — NOT NULL
  • retries — int4 — NOT NULL
  • attempts — int4 — NOT NULL

job_record_buffer

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • bufferId — varchar — NOT NULL
  • job — text — NOT NULL

migrations

  • id — serial4 — Primary key — NOT NULL
  • timestamp — int8 — NOT NULL
  • name — varchar — NOT NULL

order

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • type — varchar — NOT NULL
  • code — varchar — NOT NULL
  • state — varchar — NOT NULL
  • active — bool — NOT NULL
  • orderPlacedAt — timestamp
  • couponCodes — text — NOT NULL
  • shippingAddress — text — NOT NULL
  • billingAddress — text — NOT NULL
  • currencyCode — varchar — NOT NULL
  • customerId — int4 — Foreign key → customer.id
  • aggregateOrderId — int4 — Foreign key → order.id
  • taxZoneId — int4
  • subTotal — int4 — NOT NULL
  • subTotalWithTax — int4 — NOT NULL
  • shipping — int4 — NOT NULL
  • shippingWithTax — int4 — NOT NULL

order_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • orderId — int4 — Foreign key → order.id — NOT NULL

order_fulfillments_fulfillment

  • orderId — int4 — Foreign key → order.id — NOT NULL
  • fulfillmentId — int4 — Foreign key → fulfillment.id — NOT NULL

order_line

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • quantity — int4 — NOT NULL
  • orderPlacedQuantity — int4 — NOT NULL
  • listPriceIncludesTax — bool — NOT NULL
  • adjustments — text — NOT NULL
  • taxLines — text — NOT NULL
  • sellerChannelId — int4
  • initialListPrice — int4
  • listPrice — int4 — NOT NULL
  • orderId — int4 — Foreign key → order.id
  • featuredAssetId — int4 — Foreign key → asset.id
  • taxCategoryId — int4 — Foreign key → tax_category.id
  • productVariantId — int4 — Foreign key → product_variant.id — NOT NULL
  • shippingLineId — int4 — Foreign key → shipping_line.id

order_line_reference

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • quantity — int4 — NOT NULL
  • discriminator — varchar — NOT NULL
  • orderLineId — int4 — Foreign key → order_line.id — NOT NULL
  • fulfillmentId — int4 — Foreign key → fulfillment.id
  • refundId — int4 — Foreign key → refund.id
  • modificationId — int4 — Foreign key → order_modification.id

order_modification

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • note — varchar — NOT NULL
  • shippingAddressChange — text
  • billingAddressChange — text
  • priceChange — int4 — NOT NULL
  • orderId — int4 — Foreign key → order.id
  • refundId — int4 — Foreign key → refund.id
  • paymentId — int4 — Foreign key → payment.id

order_promotions_promotion

  • promotionId — int4 — Foreign key → promotion.id — NOT NULL
  • orderId — in4 — Foreign key → order.id — NOT NULL

payment

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • method — varchar — NOT NULL
  • state — varchar — NOT NULL
  • errorMessage — varchar
  • transactionId — varchar
  • metadata — text — NOT NULL
  • amount — int4 — NOT NULL
  • orderId — int4 — Foreign key → order.id

payment_method

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • code — varchar — NOT NULL
  • enabled — bool — NOT NULL
  • checker — text
  • handler — text — NOT NULL

payment_method_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • paymentMethodId — int4 — Foreign key → payment_method.id — NOT NULL

payment_method_translation

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • languageCode — varchar — NOT NULL
  • name — varchar — NOT NULL
  • description — text — NOT NULL
  • baseId — int4 — Foreign key → payment_method.id

product

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • enabled — bool — NOT NULL
  • featuredAssetId — int4 — Foreign key → asset.id

product_asset

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • position — int4 — NOT NULL
  • productId — int4 — Foreign key → product.id — NOT NULL
  • assetId — int4 — Foreign key → asset.id — NOT NULL

product_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • productId — int4 — Foreign key → product.id — NOT NULL

product_facet_values_facet_value

  • facetValueId — int4 — Foreign key → facet_value.id — NOT NULL
  • productId — int4 — Foreign key → product.id — NOT NULL

product_option

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • code — varchar — NOT NULL
  • groupId — int4 — Foreign key → product_option_group.id — NOT NULL

product_option_group

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • code — varchar — NOT NULL
  • productId — int4 — Foreign key → product.id

product_option_group_translation

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • languageCode — varchar — NOT NULL
  • name — varchar — NOT NULL
  • baseId — int4 — Foreign key → product_option_group.id

product_option_translation

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • languageCode — varchar — NOT NULL
  • name — varchar — NOT NULL
  • baseId — int4 — Foreign key → product_option.id

product_translation

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • languageCode — varchar — NOT NULL
  • name — varchar — NOT NULL
  • slug — varchar — NOT NULL
  • description — text — NOT NULL
  • baseId — int4 — Foreign key → product.id

product_variant

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • enabled — bool — NOT NULL
  • sku — varchar — NOT NULL
  • outOfStockThreshold — int4 — NOT NULL
  • useGlobalOutOfStockThreshold — bool — NOT NULL
  • trackInventory — varchar — NOT NULL
  • productId — int4 — Foreign key → product.id — NOT NULL
  • featuredAssetId — int4 — Foreign key → asset.id
  • taxCategoryId — int4 — Foreign key → tax_category.id

product_variant_asset

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • position — int4 — NOT NULL
  • assetId — int4 — Foreign key → asset.id — NOT NULL
  • productVariantId — int4 — Foreign key → product_variant.id — NOT NULL

product_variant_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • productVariantId — int4 — Foreign key → product_variant.id — NOT NULL

product_variant_facet_values_facet_value

  • facetValueId — int4 — Foreign key → facet_value.id — NOT NULL
  • productVariantId — int4 — Foreign key → product_variant.id — NOT NULL

product_variant_options_product_option

  • productVariantId — int4 — Foreign key → product_variant.id — NOT NULL
  • productOptionId — int4 — Foreign key → product_option.id — NOT NULL

product_variant_price

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • currencyCode — varchar — NOT NULL
  • channelId — int4
  • price — int4 — NOT NULL
  • variantId — int4 — Foreign key → product_variant.id

product_variant_translation

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • languageCode — varchar — NOT NULL
  • name — varchar — NOT NULL
  • baseId — int4 — Foreign key → product_variant.id

promotion

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • startsAt — timestamp
  • endsAt — timestamp
  • couponCode — varchar
  • perCustomerUsageLimit — int4
  • usageLimit — int4
  • enabled — bool — NOT NULL
  • conditions — text — NOT NULL
  • actions — text — NOT NULL
  • priorityScore — int4 — NOT NULL

promotion_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • promotionId — int4 — Foreign key → promotion.id — NOT NULL

promotion_translation

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • languageCode — varchar — NOT NULL
  • name — varchar — NOT NULL
  • description — text — NOT NULL
  • baseId — int4 — Foreign key → promotion.id

refund

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • method — varchar — NOT NULL
  • reason — varchar
  • state — varchar — NOT NULL
  • transactionId — varchar
  • metadata — text — NOT NULL
  • items — int4 — NOT NULL
  • shipping — int4 — NOT NULL
  • adjustment — int4 — NOT NULL
  • total — int4 — NOT NULL
  • paymentId — int4 — Foreign key → payment.id — NOT NULL

region

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • code — varchar — NOT NULL
  • type — varchar — NOT NULL
  • enabled — bool — NOT NULL
  • discriminator — varchar — NOT NULL
  • parentId — int4 — Foreign key → region.id

region_translation

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • languageCode — varchar — NOT NULL
  • name — varchar — NOT NULL
  • baseId — int4 — Foreign key → region.id — NOT NULL

role

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • code — varchar — NOT NULL
  • description — varchar — NOT NULL
  • permissions — text — NOT NULL

role_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • roleId — int4 — Foreign key → role.id — NOT NULL

search_index_item

  • languageCode — varchar — Primary key — NOT NULL
  • productVariantId — int4 — Primary key — NOT NULL
  • channelId — int4 — Primary key — NOT NULL
  • enabled — bool — NOT NULL
  • productName — varchar — NOT NULL
  • productVariantName — varchar — NOT NULL
  • description — text — NOT NULL
  • slug — varchar — NOT NULL
  • sku — varchar — NOT NULL
  • facetIds — text — NOT NULL
  • facetValueIds — text — NOT NULL
  • collectionIds — text — NOT NULL
  • collectionSlugs — text — NOT NULL
  • channelIds — text — NOT NULL
  • productPreview — varchar — NOT NULL
  • productPreviewFocalPoint — text
  • productVariantPreview — varchar — NOT NULL
  • productVariantPreviewFocalPoint — text
  • inStock — bool — NOT NULL
  • productInStock — bool — NOT NULL
  • productId — int4 — NOT NULL
  • productAssetId — int4
  • productVariantAssetId — int4
  • price — int4 — NOT NULL
  • priceWithTax — int4 — NOT NULL

seller

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • name — varchar — NOT NULL

session

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • token — varchar — NOT NULL
  • expires — timestamp — NOT NULL
  • invalidated — bool — NOT NULL
  • authenticationStrategy — varchar
  • type — varchar — NOT NULL
  • activeChannelId — int4 — Foreign key → channel.id
  • activeOrderId — int4 — Foreign key → order.id
  • userId — int4 — Foreign key → user.id

shipping_line

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • listPriceIncludesTax — bool — NOT NULL
  • adjustments — text — NOT NULL
  • taxLines — text — NOT NULL
  • listPrice — int4 — NOT NULL
  • shippingMethodId — int4 — Foreign key → shipping_method.id — NOT NULL
  • orderId — int4 — Foreign key → order.id

shipping_method

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • code — varchar — NOT NULL
  • checker — text — NOT NULL
  • calculator — text — NOT NULL
  • fulfillmentHandlerCode — varchar — NOT NULL

shipping_method_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • shippingMethodId — int4 — Foreign key → shipping_method.id — NOT NULL

shipping_method_translation

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • languageCode — varchar — NOT NULL
  • name — varchar — NOT NULL
  • description — varchar — NOT NULL
  • baseId — int4 — Foreign key → shipping_method.id

stock_level

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • stockOnHand — int4 — NOT NULL
  • stockAllocated — int4 — NOT NULL
  • stockLocationId — int4 — Foreign key → stock_location.id — NOT NULL
  • productVariantId — int4 — Foreign key → product_variant.id — NOT NULL

stock_location

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • name — varchar — NOT NULL
  • description — varchar — NOT NULL

stock_location_channels_channel

  • channelId — int4 — Foreign key → channel.id — NOT NULL
  • stockLocationId — int4 — Foreign key → stock_location.id — NOT NULL

stock_movement

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • type — varchar — NOT NULL
  • quantity — int4 — NOT NULL
  • discriminator — varchar — NOT NULL
  • productVariantId — int4 — Foreign key → product_variant.id
  • stockLocationId — int4 — Foreign key → stock_location.id — NOT NULL
  • orderLineId — int4 — Foreign key → order_line.id

surcharge

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • description — varchar — NOT NULL
  • listPriceIncludesTax — bool — NOT NULL
  • sku — varchar — NOT NULL
  • taxLines — text — NOT NULL
  • listPrice — int4 — NOT NULL
  • orderModificationId — int4
  • orderId — int4 — Foreign key → order.id

tag

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • value — varchar — NOT NULL

tax_category

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • name — varchar — NOT NULL
  • isDefault — bool — NOT NULL

tax_rate

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • name — varchar — NOT NULL
  • enabled — bool — NOT NULL
  • value — numeric(5, 2) — NOT NULL
  • categoryId — int4 — Foreign key → tax_category.id
  • zoneId — int4 — Foreign key
  • customerGroupId — int4 — Foreign key → customer_group.id

user

  • id — serial4 — Primary key — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • identifier — varchar — NOT NULL
  • verified — bool — NOT NULL
  • lastLogin — timestamp

and 3 more tables