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