5555

Tables (5)

categories

  • category_id — UUID
  • category_name — VARCHAR(100) — NOT NULL
  • category_description — TEXT
  • category_created_at — TIMESTAMP

order_items

  • order_item_id — UUID
  • order_item_order_id — UUID — Foreign key → orders.order_id — NOT NULL
  • order_item_product_id — UUID — Foreign key → products.product_id — NOT NULL
  • order_item_quantity — INTEGER — NOT NULL
  • order_item_price — NUMERIC(12,2) — NOT NULL

orders

  • order_id — UUID
  • order_user_id — UUID — Foreign key → users.user_id — NOT NULL
  • order_total_amount — NUMERIC(12,2) — NOT NULL
  • order_status — VARCHAR(20) — NOT NULL
  • order_created_at — TIMESTAMP

products

  • product_id — UUID
  • product_category_id — UUID — Foreign key → categories.category_id — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • product_price — NUMERIC(12,2) — NOT NULL
  • product_stock_quantity — INTEGER — NOT NULL
  • product_status — VARCHAR(20)
  • product_created_at — TIMESTAMP

users

  • user_id — UUID — NOT NULL
  • user_email — VARCHAR(255) — NOT NULL
  • user_password — VARCHAR(255) — NOT NULL
  • user_status — VARCHAR(20) — NOT NULL
  • user_created_at — TIMESTAMP — NOT NULL
  • user_updated_at — TIMESTAMP