1
Tables (29)
admins_profiles
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- level — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
cart_items
- cart_item_id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- product_id — VARCHAR(36) — Foreign key → products.product_id — NOT NULL
- product_option_id — VARCHAR(36) — Foreign key → product_options.product_option_id — NOT NULL
- quantity — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
coupons
- coupon_id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- discount_method — VARCHAR(20) — NOT NULL
- discount_value — NUMERIC(12,2) — NOT NULL
- min_order_amount — NUMERIC(12,2)
- max_discount_amount — NUMERIC(12,2) — NOT NULL
- started_at — TIMESTAMP
- ended_at — TIMESTAMP
- status — VARCHAR(20)
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
deliveries
- delivery_id — VARCHAR(36) — Primary key — NOT NULL
- order_id — VARCHAR(36) — Foreign key → orders.order_id — NOT NULL
- address_id — VARCHAR(36) — Foreign key → delivery_addresses.address_id
- tracking_number — VARCHAR(100)
- delivery_type — VARCHAR(10) — NOT NULL
- carrier — VARCHAR(20) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- memo — TEXT
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
delivery_addresses
- address_id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- address_name — VARCHAR(100) — NOT NULL
- recipient_name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- address — TEXT — NOT NULL
- address_detail — VARCHAR(255)
- postal_code — VARCHAR(10)
- is_default — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
delivery_histories
- history_id — VARCHAR(36) — Primary key — NOT NULL
- delivery_id — VARCHAR(36) — Foreign key → deliveries.delivery_id — NOT NULL
- status — VARCHAR(30) — NOT NULL
- location_type — VARCHAR(20) — NOT NULL
- warehouse_id — VARCHAR(36) — Foreign key → warehouses.warehouse_id
- hub_id — VARCHAR(36) — Foreign key → logistics_hubs.hub_id
- location — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
inventory_histories
- history_id — VARCHAR(36) — Primary key — NOT NULL
- inventory_id — VARCHAR(36) — Foreign key → warehouse_inventory.inventory_id — NOT NULL
- change_quantity — INTEGER — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
logistics_hubs
- hub_id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(100)
- hub_type — VARCHAR(20)
- address — TEXT
- contact_phone — VARCHAR(20)
- status — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
members_profiles
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- nickname — VARCHAR(100)
- point_balance — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
membership_categories
- category_id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — NUMERIC(10,2) — NOT NULL
- description — TEXT
- benefits — TEXT
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
order_claims
- claim_id — VARCHAR(36) — Primary key — NOT NULL
- order_item_id — VARCHAR(36) — Foreign key → order_items.order_item_id — NOT NULL
- claim_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- reason — TEXT — NOT NULL
- refund_amount — NUMERIC(12,2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
order_discounts
- order_discount_id — VARCHAR(36) — Primary key — NOT NULL
- order_id — VARCHAR(36) — Foreign key → orders.order_id — NOT NULL
- order_item_id — VARCHAR(36) — Foreign key → order_items.order_item_id — NOT NULL
- user_coupon_id — VARCHAR(36) — Foreign key → user_coupons.user_coupon_id
- coupon_id — VARCHAR(36) — Foreign key → coupons.coupon_id
- promotion_id — VARCHAR(36) — Foreign key → promotions.promotion_id
- discount_type — VARCHAR(20) — NOT NULL
- applied_amount — NUMERIC(12,2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
order_items
- order_item_id — VARCHAR(36) — Primary key — NOT NULL
- order_id — VARCHAR(36) — Foreign key → orders.order_id — NOT NULL
- store_order_id — VARCHAR(36) — Foreign key → store_orders.store_order_id — NOT NULL
- delivery_id — VARCHAR(36) — Foreign key → deliveries.delivery_id
- product_id — VARCHAR(36) — Foreign key → products.product_id — NOT NULL
- product_option_id — VARCHAR(36) — Foreign key → product_options.product_option_id — NOT NULL
- quantity — INTEGER — NOT NULL
- unit_price — NUMERIC(12,2) — NOT NULL
- product_name — VARCHAR(500)
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
orders
- order_id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- address_id — VARCHAR(36) — Foreign key → delivery_addresses.address_id
- membership_id — VARCHAR(36) — Foreign key → user_memberships.membership_id
- total_price — NUMERIC(12,2) — NOT NULL
- delivery_fee — NUMERIC(8,2) — NOT NULL
- discount_amount — NUMERIC(12,2)
- final_price — NUMERIC(12,2) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
payments
- payment_id — VARCHAR(36) — Primary key — NOT NULL
- order_id — VARCHAR(36) — Foreign key → orders.order_id — NOT NULL
- payment_method — VARCHAR(30)
- amount — NUMERIC(12,2)
- status — VARCHAR(20)
- pg_transaction_id — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
product_categories
- category_id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- depth — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
product_options
- product_option_id — VARCHAR(36) — Primary key — NOT NULL
- product_id — VARCHAR(36) — Foreign key → products.product_id — NOT NULL
- options_name — VARCHAR(255)
- extra_price — NUMERIC(12,2)
- status — VARCHAR(20)
- display_order — INTEGER
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
products
- product_id — VARCHAR(36) — Primary key — NOT NULL
- store_id — VARCHAR(36) — Foreign key → stores.store_id — NOT NULL
- category_id — VARCHAR(36) — Foreign key → product_categories.category_id
- name — VARCHAR(500) — NOT NULL
- price — NUMERIC(12,2) — NOT NULL
- description — TEXT
- is_rocket — BOOLEAN — NOT NULL
- thumbnail_url — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
promotions
- promotion_id — VARCHAR(36) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- discount_method — VARCHAR(20) — NOT NULL
- discount_value — NUMERIC(12,2) — NOT NULL
- target_type — VARCHAR(20)
- started_at — TIMESTAMP — NOT NULL
- ended_at — TIMESTAMP
- status — VARCHAR(20)
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
review_images
- image_id — VARCHAR(36) — Primary key — NOT NULL
- review_id — VARCHAR(36) — Foreign key → reviews.review_id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- sort_order — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
reviews
- review_id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- product_id — VARCHAR(36) — Foreign key → products.product_id — NOT NULL
- order_item_id — VARCHAR(36) — Foreign key → order_items.order_item_id
- title — VARCHAR(255)
- content — TEXT — NOT NULL
- rating — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
sellers_profiles
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- business_number — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
store_orders
- store_order_id — VARCHAR(36) — Primary key — NOT NULL
- order_id — VARCHAR(36) — Foreign key → orders.order_id — NOT NULL
- store_id — VARCHAR(36) — Foreign key → stores.store_id — NOT NULL
- delivery_id — VARCHAR(36) — Foreign key → deliveries.delivery_id
- subtotal_price — NUMERIC(12,2) — NOT NULL
- subtotal_delivery_fee — NUMERIC(8,2)
- status — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
stores
- store_id — VARCHAR(36) — Primary key — NOT NULL
- seller_id — VARCHAR(36) — Foreign key → sellers_profiles.user_id — NOT NULL
- store_name — VARCHAR(255) — NOT NULL
- address — TEXT
- phone — VARCHAR(20)
- description — TEXT
- logo_url — VARCHAR(500)
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
user_coupons
- user_coupon_id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- coupon_id — VARCHAR(36) — Foreign key → coupons.coupon_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- used_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
user_memberships
- membership_id — VARCHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(36) — Foreign key → users.user_id — NOT NULL
- category_id — VARCHAR(36) — Foreign key → membership_categories.category_id — NOT NULL
- payment_method — VARCHAR(30) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- auto_renewal — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
users
- user_id — VARCHAR(36) — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
warehouse_inventory
- inventory_id — VARCHAR(36) — Primary key — NOT NULL
- warehouse_id — VARCHAR(36) — Foreign key → warehouses.warehouse_id — NOT NULL
- product_option_id — VARCHAR(36) — Foreign key → product_options.product_option_id — NOT NULL
- quantity — INTEGER — NOT NULL
- reserved_quantity — INTEGER — NOT NULL
- safety_stock — INTEGER — NOT NULL
- version — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)
warehouses
- warehouse_id — VARCHAR(36) — Primary key — NOT NULL
- warehouse_name — VARCHAR(255) — NOT NULL
- address — TEXT — NOT NULL
- region — VARCHAR(255) — NOT NULL
- contact_phone — VARCHAR(20)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- created_by — VARCHAR(36)
- updated_at — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(36)
- deleted_at — TIMESTAMP
- deleted_by — VARCHAR(36)