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