shop

Tables (40)

cartItems

  • itemId — BIGSERIAL
  • cartId — BIGINT — NOT NULL
  • skuId — BIGINT — NOT NULL
  • qty — INTEGER — NOT NULL
  • addedAt — TIMESTAMPTZ — NOT NULL

cart_items

  • item_id — BIGSERIAL
  • cart_id — BIGINT — NOT NULL
  • sku_id — BIGINT — NOT NULL
  • qty — INTEGER — NOT NULL
  • added_at — TIMESTAMPTZ — NOT NULL

carts

  • cartId — BIGSERIAL
  • userId — BIGINT
  • cartToken — UUID
  • createdAt — TIMESTAMPTZ — NOT NULL

categories

  • categoryId — BIGSERIAL
  • name — VARCHAR(120) — NOT NULL
  • parentId — BIGINT
  • createdAt — TIMESTAMPTZ — NOT NULL

couponUsages

  • usageId — BIGSERIAL
  • couponId — BIGINT — NOT NULL
  • userId — BIGINT — NOT NULL
  • orderId — BIGINT — NOT NULL
  • usedAt — TIMESTAMPTZ — NOT NULL
  • discountedAmount — INTEGER — NOT NULL

coupon_usages

  • usage_id — BIGSERIAL
  • coupon_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • order_id — BIGINT — NOT NULL
  • used_at — TIMESTAMPTZ — NOT NULL
  • discounted_amount — INTEGER — NOT NULL

coupons

  • couponId — BIGSERIAL
  • code — VARCHAR(60) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • value — INTEGER — NOT NULL
  • minAmount — INTEGER
  • startsAt — TIMESTAMPTZ
  • endsAt — TIMESTAMPTZ
  • usageLimit — INTEGER
  • perUserLimit — INTEGER
  • isActive — BOOLEAN — NOT NULL

csTickets

  • ticketId — BIGSERIAL
  • userId — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • createdAt — TIMESTAMPTZ — NOT NULL

cs_tickets

  • ticket_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

inventory

  • inventoryId — BIGSERIAL
  • skuId — BIGINT — NOT NULL
  • storeId — BIGINT — NOT NULL
  • qtyAvailable — INTEGER — NOT NULL
  • updatedAt — TIMESTAMPTZ — NOT NULL

orderItems

  • orderItemId — BIGSERIAL
  • orderId — BIGINT — NOT NULL
  • skuId — BIGINT — NOT NULL
  • productName — VARCHAR(200) — NOT NULL
  • variantJson — JSONB — NOT NULL
  • price — INTEGER — NOT NULL
  • qty — INTEGER — NOT NULL
  • subtotal — INTEGER — NOT NULL

order_items

  • order_item_id — BIGSERIAL
  • order_id — BIGINT — NOT NULL
  • sku_id — BIGINT — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • variant_json — JSONB — NOT NULL
  • price — INTEGER — NOT NULL
  • qty — INTEGER — NOT NULL
  • subtotal — INTEGER — NOT NULL

orders

  • orderId — BIGSERIAL
  • userId — BIGINT
  • status — VARCHAR(30) — NOT NULL
  • totalPrice — INTEGER — NOT NULL
  • shippingFee — INTEGER — NOT NULL
  • discountTotal — INTEGER — NOT NULL
  • shippingAddress — JSONB
  • billingAddress — JSONB
  • createdAt — TIMESTAMPTZ — NOT NULL

outboxEvents

  • eventId — BIGSERIAL
  • eventType — VARCHAR(60) — NOT NULL
  • payloadJson — JSONB — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • createdAt — TIMESTAMPTZ — NOT NULL

outbox_events

  • event_id — BIGSERIAL
  • event_type — VARCHAR(60) — NOT NULL
  • payload_json — JSONB — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

payments

  • paymentId — BIGSERIAL
  • orderId — BIGINT — NOT NULL
  • provider — VARCHAR(40) — NOT NULL
  • amount — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • pgTransactionId — VARCHAR(191)
  • payloadJson — JSONB
  • createdAt — TIMESTAMPTZ — NOT NULL

permissions

  • permissionId — BIGSERIAL
  • name — VARCHAR(100) — NOT NULL

pointLedger

  • pointId — BIGSERIAL
  • userId — BIGINT — NOT NULL
  • delta — INTEGER — NOT NULL
  • reason — VARCHAR(120)
  • orderId — BIGINT
  • expiresAt — TIMESTAMPTZ
  • createdAt — TIMESTAMPTZ — NOT NULL

point_ledger

  • point_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • delta — INTEGER — NOT NULL
  • reason — VARCHAR(120)
  • order_id — BIGINT
  • expires_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

productOptions

  • optionId — BIGSERIAL
  • productId — BIGINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • value — VARCHAR(100) — NOT NULL

product_options

  • option_id — BIGSERIAL
  • product_id — BIGINT — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • value — VARCHAR(100) — NOT NULL

products

  • productId — BIGSERIAL
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • price — INTEGER — NOT NULL
  • brand — VARCHAR(120)
  • categoryId — BIGINT
  • isActive — BOOLEAN — NOT NULL
  • createdAt — TIMESTAMPTZ — NOT NULL
  • updatedAt — TIMESTAMPTZ — NOT NULL

qna

  • qnaId — BIGSERIAL
  • productId — BIGINT — NOT NULL
  • userId — BIGINT — NOT NULL
  • question — TEXT — NOT NULL
  • answer — TEXT
  • status — VARCHAR(20) — NOT NULL
  • createdAt — TIMESTAMPTZ — NOT NULL

reviews

  • reviewId — BIGSERIAL
  • orderItemId — BIGINT — NOT NULL
  • userId — BIGINT — NOT NULL
  • rating — INTEGER — NOT NULL
  • content — TEXT
  • photoUrl — TEXT
  • status — VARCHAR(20) — NOT NULL
  • createdAt — TIMESTAMPTZ — NOT NULL

rolePermissions

  • roleId — BIGINT — Primary key — NOT NULL
  • permissionId — BIGINT — Primary key — NOT NULL

role_permissions

  • role_id — BIGINT — Primary key — NOT NULL
  • permission_id — BIGINT — Primary key — NOT NULL

roles

  • roleId — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL

shipments

  • shipmentId — BIGSERIAL
  • orderId — BIGINT — NOT NULL
  • carrier — VARCHAR(60)
  • trackingNo — VARCHAR(120)
  • status — VARCHAR(30) — NOT NULL
  • eventsJson — JSONB
  • shippedAt — TIMESTAMPTZ
  • deliveredAt — TIMESTAMPTZ

skus

  • skuId — BIGSERIAL
  • productId — BIGINT — NOT NULL
  • optionJson — JSONB — NOT NULL
  • stockQty — INTEGER — NOT NULL

socialAccounts

  • socialId — BIGSERIAL
  • userId — BIGINT — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • providerUid — VARCHAR(191) — NOT NULL
  • rawProfileJson — JSONB
  • createdAt — TIMESTAMPTZ — NOT NULL

social_accounts

  • social_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_uid — VARCHAR(191) — NOT NULL
  • raw_profile_json — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL

stores

  • storeId — BIGSERIAL
  • name — VARCHAR(120) — NOT NULL
  • address — TEXT
  • lat — DOUBLE
  • lng — DOUBLE
  • createdAt — TIMESTAMPTZ — NOT NULL

userEvents

  • eventId — BIGSERIAL
  • userId — BIGINT
  • type — VARCHAR(40) — NOT NULL
  • productId — BIGINT
  • metaJson — JSONB
  • occurredAt — TIMESTAMPTZ — NOT NULL

userProfiles

  • profileId — BIGSERIAL
  • userId — BIGINT — NOT NULL
  • address — TEXT
  • avatarUrl — TEXT
  • marketingEmail — BOOLEAN — NOT NULL
  • marketingSms — BOOLEAN — NOT NULL
  • creditToken — TEXT
  • createdAt — TIMESTAMPTZ — NOT NULL
  • updatedAt — TIMESTAMPTZ — NOT NULL

userRoles

  • userId — BIGINT — Primary key — NOT NULL
  • roleId — BIGINT — Primary key — NOT NULL

user_events

  • event_id — BIGSERIAL
  • user_id — BIGINT
  • type — VARCHAR(40) — NOT NULL
  • product_id — BIGINT
  • meta_json — JSONB
  • occurred_at — TIMESTAMPTZ — NOT NULL

user_profiles

  • profile_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • address — TEXT
  • avatar_url — TEXT
  • marketing_email — BOOLEAN — NOT NULL
  • marketing_sms — BOOLEAN — NOT NULL
  • credit_token — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

user_roles

  • user_id — BIGINT — Primary key — NOT NULL
  • role_id — BIGINT — Primary key — NOT NULL

users

  • user_id — BIGSERIAL
  • email — CITEXT — NOT NULL
  • password_hash — TEXT — NOT NULL
  • name — VARCHAR(100)
  • nickname — VARCHAR(100)
  • phone_number — VARCHAR(30)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → user_roles.user_id — NOT NULL
  • role_id — BIGINT — Foreign key → user_roles.role_id — NOT NULL

wishlist

  • userId — BIGINT — Primary key — NOT NULL
  • productId — BIGINT — Primary key — NOT NULL
  • createdAt — TIMESTAMPTZ — NOT NULL