bubbly

Tables (99)

Address

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "Address_type_enum" — NOT NULL
  • isDefault — boolean — NOT NULL
  • countryCode — "Address_countrycode_enum" — NOT NULL
  • postCode — varchar — NOT NULL
  • label — varchar
  • tel — varchar
  • corporationId — uuid
  • userId — uuid

AddressBase

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • countryCode — "AddressBase_countrycode_enum" — NOT NULL
  • postCode — varchar

AddressBaseTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "AddressBaseTrans_language_enum" — NOT NULL
  • addressBaseId — uuid
  • province — varchar — NOT NULL
  • district — varchar — NOT NULL
  • subDistrict — varchar

AddressTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "AddressTrans_language_enum" — NOT NULL
  • recipient — varchar — NOT NULL
  • province — varchar — NOT NULL
  • district — varchar — NOT NULL
  • detailedAddress — varchar — NOT NULL
  • addressId — uuid

Airport

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • countryCode — "Airport_countrycode_enum" — NOT NULL
  • code — varchar — NOT NULL

AirportTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "AirportTrans_language_enum" — NOT NULL
  • name — varchar — NOT NULL
  • airportId — uuid

Banner

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "Banner_type_enum" — NOT NULL
  • name — varchar — NOT NULL
  • enabled — boolean — NOT NULL

BannerTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "BannerTrans_language_enum" — NOT NULL
  • bannerId — uuid
  • details — json — NOT NULL

Brand

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • name — varchar — NOT NULL
  • image — varchar — NOT NULL

Cart

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp

CartItem

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • regularContract — boolean — NOT NULL
  • cartId — uuid
  • productId — uuid

Category

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "Category_type_enum" — NOT NULL
  • code — varchar(3) — NOT NULL
  • order — integer — NOT NULL
  • images — json
  • mpath — varchar
  • parentId — uuid

CategoryGroup

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • order — integer — NOT NULL
  • products — json

CategoryGroupTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "CategoryGroupTrans_language_enum" — NOT NULL
  • title — varchar — NOT NULL
  • tags — character
  • bannerHeading — json
  • bannersInside — json
  • groupId — uuid

CategoryTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "CategoryTrans_language_enum" — NOT NULL
  • name — varchar — NOT NULL
  • categoryId — uuid

Container

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "Container_type_enum" — NOT NULL
  • name — varchar — NOT NULL
  • internalLength — double — NOT NULL
  • internalWidth — double — NOT NULL
  • internalHeight — double — NOT NULL
  • doorWidth — double — NOT NULL
  • doorHeight — double — NOT NULL
  • cubicCapacity — double — NOT NULL
  • maximumLoad — double — NOT NULL

Corporation

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • status — "Corporation_status_enum" — NOT NULL
  • registrationNumber — varchar — NOT NULL
  • businessLicense — varchar — NOT NULL
  • taxNumber — varchar — NOT NULL
  • tel — varchar — NOT NULL
  • fax — varchar
  • email — varchar — NOT NULL
  • logo — varchar
  • pointId — uuid
  • name — varchar — NOT NULL
  • abbreviation — varchar
  • branchName — varchar
  • website — varchar
  • vendorId — uuid

CorporationTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "CorporationTrans_language_enum" — NOT NULL
  • name — varchar — NOT NULL
  • corporationId — uuid

CorporationVendor

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • name — varchar — NOT NULL
  • tel — varchar — NOT NULL
  • email — varchar — NOT NULL
  • storeName — varchar — NOT NULL
  • introduction — text — NOT NULL
  • storeLogo — varchar

Coupon

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • userId — uuid
  • corporationId — uuid

Currency

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • currencyFrom — "Currency_currencyfrom_enum" — NOT NULL
  • currencyTo — "Currency_currencyto_enum" — NOT NULL
  • exchangeRate — double — NOT NULL
  • lastUpdatedTime — timestamp — NOT NULL

DeliveryPriceAir

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • chargesExport — json — NOT NULL
  • freightCharges — json — NOT NULL
  • chargesImport — json — NOT NULL
  • airportFromId — uuid
  • airportToId — uuid

DeliveryPriceAirKr

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • consolCosts — json — NOT NULL
  • truckId — uuid

DeliveryPriceAirTh

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • truckId — uuid

DeliveryPriceCheck

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • deliveryMethod — "DeliveryPriceCheck_deliverymethod_enum" — NOT NULL
  • checkItemsForExpress — json
  • checkItemsForAir — json
  • checkItemsForLCL — json
  • checkItemsForFCL — json
  • serviceCharge — integer — NOT NULL
  • districtId — uuid
  • destinationId — uuid

DeliveryPriceExpress

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "DeliveryPriceExpress_type_enum" — NOT NULL
  • countryFrom — "DeliveryPriceExpress_countryfrom_enum" — NOT NULL
  • countryTo — "DeliveryPriceExpress_countryto_enum" — NOT NULL
  • priceInfos — json — NOT NULL
  • maxLength — double — NOT NULL
  • maxPerimeter — double — NOT NULL
  • maxWeight — double — NOT NULL

DeliveryPriceFCL

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • serviceChargeRate — integer — NOT NULL
  • chargesExport — json
  • freightCharges — json
  • chargesImport — json
  • portFromId — uuid
  • portToId — uuid

DeliveryPriceFCLKr

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • truckingCosts — json
  • addressFromId — uuid
  • portToId — uuid

DeliveryPriceFCLTh

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • truckingCosts — json
  • portFromId — uuid
  • addressToId — uuid

DeliveryPriceLCL

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • chargesExport — json — NOT NULL
  • freightCharges — json — NOT NULL
  • chargesImport — json — NOT NULL
  • portFromId — uuid
  • portToId — uuid

DeliveryPriceLCLKr

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • shippingCosts — json — NOT NULL
  • overCostsCBM — json — NOT NULL
  • overCostsWeight — json — NOT NULL
  • overCostsLength — json — NOT NULL
  • addressFromId — uuid
  • portToId — uuid

DeliveryPriceLCLTh

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • truckId — uuid

DeliveryTruck

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • countryCode — "DeliveryTruck_countrycode_enum" — NOT NULL
  • width — double — NOT NULL
  • length — double — NOT NULL
  • height — double
  • maxCBM — double — NOT NULL
  • maxWeight — double — NOT NULL
  • priceUnit — "DeliveryTruck_priceunit_enum" — NOT NULL
  • price — double — NOT NULL
  • addressFromId — uuid
  • airportFromId — uuid
  • portFromId — uuid
  • addressToId — uuid
  • airportToId — uuid
  • portToId — uuid
  • distance — double

DeliveryTruckTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "DeliveryTruckTrans_language_enum" — NOT NULL
  • name — varchar — NOT NULL
  • truckId — uuid

DummyProduct

  • id — serial
  • name — varchar — NOT NULL
  • originalPrice — integer — NOT NULL
  • price — double — NOT NULL
  • deliveryFee — double — NOT NULL
  • brandName — varchar — NOT NULL
  • vendorName — varchar — NOT NULL
  • titleImage — varchar — NOT NULL
  • discountRate — double — NOT NULL

Event

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp

EventTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "EventTrans_language_enum" — NOT NULL
  • title — varchar — NOT NULL
  • tags — json
  • image — json — NOT NULL
  • eventId — uuid

HSCode

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • countryCode — "HSCode_countrycode_enum" — NOT NULL
  • hscode — varchar — NOT NULL
  • year — integer — NOT NULL

HSCodeManual

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "HSCodeManual_type_enum" — NOT NULL
  • hscode — varchar — NOT NULL
  • year — integer — NOT NULL

HSCodeManualTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "HSCodeManualTrans_language_enum" — NOT NULL
  • html — text — NOT NULL
  • manualId — uuid

HSCodeStandard

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • hscode — varchar — NOT NULL
  • year — integer — NOT NULL

HSCodeStandardTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "HSCodeStandardTrans_language_enum" — NOT NULL
  • name — varchar — NOT NULL
  • hscodeId — uuid

HSCodeTariff

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "HSCodeTariff_type_enum" — NOT NULL
  • priority — integer — NOT NULL
  • tariffCost — double
  • tariffRate — double
  • hscodeId — uuid
  • tariffCostUnit — "HSCodeTariff_tariffcostunit_enum"
  • isAppliedToAllCountries — boolean — NOT NULL
  • appliedCountries — "HSCodeTariff_appliedcountries_enum"

HSCodeTariffTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "HSCodeTariffTrans_language_enum" — NOT NULL
  • name — varchar — NOT NULL
  • tariffId — uuid

HSCodeTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "HSCodeTrans_language_enum" — NOT NULL
  • name — varchar — NOT NULL
  • hscodeId — uuid

Notice

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp

NoticeDocument

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "NoticeDocument_type_enum" — NOT NULL

NoticeDocumentTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "NoticeDocumentTrans_language_enum" — NOT NULL
  • html — text — NOT NULL
  • noticeDocumentId — uuid

NoticeTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "NoticeTrans_language_enum" — NOT NULL
  • title — varchar — NOT NULL
  • content — text — NOT NULL
  • noticeId — uuid

Order

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • status — "Order_status_enum" — NOT NULL
  • deliveryMethod — "Order_deliverymethod_enum" — NOT NULL
  • paymentMethod — "Order_paymentmethod_enum" — NOT NULL
  • bankTransfer — json
  • totalPrice — integer — NOT NULL
  • checkItemsForExpress — json
  • checkItemsForAir — json
  • checkItemsForLCL — json
  • checkItemsForFCL — json
  • userId — uuid
  • districtId — uuid
  • destinationId — uuid

Package

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "Package_type_enum" — NOT NULL
  • weight — double — NOT NULL
  • length — double — NOT NULL
  • width — double — NOT NULL
  • height — double — NOT NULL
  • maximumProductQuantity — integer
  • maximumWeight — integer
  • maximumCBM — integer
  • images — json
  • productId — uuid

PackageTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "PackageTrans_language_enum" — NOT NULL
  • name — varchar
  • packageId — uuid

PaymentAccount

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • accountNumber — varchar — NOT NULL
  • bankLogo — varchar — NOT NULL
  • accountHolder — varchar — NOT NULL
  • countryCode — "PaymentAccount_countrycode_enum" — NOT NULL

PaymentAccountTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "PaymentAccountTrans_language_enum" — NOT NULL
  • bankName — varchar — NOT NULL
  • accountId — uuid

Point

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp

PointExchangeRate

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • currency — "PointExchangeRate_currency_enum" — NOT NULL
  • rate — integer — NOT NULL

PointHistory

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • pointId — uuid

PointPolicy

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "PointPolicy_type_enum" — NOT NULL
  • priority — integer — NOT NULL
  • method — "PointPolicy_method_enum" — NOT NULL
  • percentage — double
  • amount — integer — NOT NULL
  • dayTypes — "PointPolicy_daytypes_enum"
  • dateStart — timestamp
  • dateEnd — timestamp
  • corporationId — uuid

Port

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • countryCode — "Port_countrycode_enum" — NOT NULL
  • code — varchar — NOT NULL

PortTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "PortTrans_language_enum" — NOT NULL
  • name — varchar — NOT NULL
  • portId — uuid

Product

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • status — "Product_status_enum" — NOT NULL
  • pid — varchar — NOT NULL
  • weight — double — NOT NULL
  • length — double — NOT NULL
  • width — double — NOT NULL
  • height — double — NOT NULL
  • titleImage — json — NOT NULL
  • images — json
  • rateDiscount — double — NOT NULL
  • salesCount — integer — NOT NULL
  • salesAmount — double — NOT NULL
  • rateReview — double — NOT NULL
  • countReview — integer — NOT NULL
  • countLike — integer — NOT NULL
  • badges — "Product_badges_enum"
  • deliveryMethods — "Product_deliverymethods_enum"
  • specialCategories — "Product_specialcategories_enum"
  • corporationId — uuid
  • categoryId — uuid
  • brandId — uuid
  • shippingOriginId — uuid
  • customInfo — json

ProductLike

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • userId — uuid
  • productId — uuid

ProductOption

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • productId — uuid

ProductOptionTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "ProductOptionTrans_language_enum" — NOT NULL
  • optionName — varchar — NOT NULL
  • optionId — uuid

ProductOptionValue

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • optionId — uuid

ProductOptionValueTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "ProductOptionValueTrans_language_enum" — NOT NULL
  • optionValue — varchar — NOT NULL
  • valueId — uuid

ProductQnA

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • status — "ProductQnA_status_enum" — NOT NULL
  • isPrivate — boolean — NOT NULL
  • requiredToNotify — boolean — NOT NULL
  • question — text — NOT NULL
  • answer — text
  • answerDate — timestamp
  • userId — uuid
  • staffId — uuid
  • productId — uuid

ProductReview

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • rating — integer — NOT NULL
  • details — text — NOT NULL
  • images — json
  • userId — uuid
  • productId — uuid

ProductSpec

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • isMandatory — boolean — NOT NULL

ProductSpecTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "ProductSpecTrans_language_enum" — NOT NULL
  • specName — varchar — NOT NULL
  • specId — uuid

ProductSpecValue

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • specId — uuid
  • productId — uuid

ProductSpecValueTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "ProductSpecValueTrans_language_enum" — NOT NULL
  • specValue — varchar — NOT NULL
  • specId — uuid

ProductTrans

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "ProductTrans_language_enum" — NOT NULL
  • title — varchar — NOT NULL
  • model — varchar
  • description — varchar
  • descriptionImages — json
  • productId — uuid

Request

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "Request_type_enum" — NOT NULL
  • status — "Request_status_enum" — NOT NULL
  • issuedDate — timestamp — NOT NULL
  • comment — varchar — archa
  • corporationId — uuid

RequestJoin

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • status — "RequestJoin_status_enum" — NOT NULL
  • comment — varchar — archa
  • actionType — "RequestJoin_actiontype_enum"
  • actionAt — timestamp
  • corporationId — uuid
  • userId — uuid

RequestPath

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • type — "RequestPath_type_enum" — NOT NULL
  • order — integer — NOT NULL
  • corporationId — uuid
  • approverId — uuid

RequestStatus

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • status — "RequestStatus_status_enum" — NOT NULL
  • requiredToCheck — boolean — NOT NULL
  • order — integer — NOT NULL
  • comment — varchar — archa
  • actionType — "RequestStatus_actiontype_enum"
  • actionAt — timestamp
  • requestId — uuid
  • approverId — uuid

SearchKeyword

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "SearchKeyword_language_enum" — NOT NULL
  • keyword — varchar — NOT NULL
  • count — integer — NOT NULL

SearchKeywordRank

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • language — "SearchKeywordRank_language_enum" — NOT NULL
  • keyword — varchar — NOT NULL
  • rank — integer — NOT NULL
  • isNew — boolean — NOT NULL

ServiceChargeRate

  • id — uuid — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • deletedAt — timestamp
  • basic — double — NOT NULL
  • fulfillment — double — NOT NULL
  • paymentGateway — double — NOT NULL
  • deliveryInExportCountry — double — NOT NULL
  • delivery — double — NOT NULL
  • custom — double — NOT NULL
  • deliveryInImportCountry — double — NOT NULL
  • exchangeRate — double — NOT NULL

and 19 more tables