pagopa-erd

Tables (10)

cart (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)

  • id (Key) — INT — Primary key — NOT NULL
  • quantity (Field) — INT
  • created_at (Field2) — TIMESTAMP
  • user_id (Key2) — INT — Foreign key → users.id — NOT NULL
  • product_id (Key3) — INT — Foreign key → products.id — NOT NULL

categories (CopyOfCopyOfUntitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • depth (Field3) — INT — 0(대분류), 1(중분류), 2(소분류)

categories (CopyOfCopyOfCopyOfUntitled23)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • depth (Field3) — INT — 0(대분류), 1(중분류), 2(소분류)
  • parent_id (Key2) — INT — Foreign key → categories.id — NOT NULL

order_items (CopyOfCopyOfCopyOfCopyOfUntitled22)

  • id (Key) — INT — Primary key — NOT NULL
  • quantity (Field) — INT
  • price (Field3) — DECIMAL(10, 2)
  • order_id (Key2) — INT — Foreign key → orders.id — NOT NULL
  • product_id (Key3) — INT — Foreign key → products.id — NOT NULL

orders (CopyOfCopyOfCopyOfUntitled22)

  • id (Key) — INT — Primary key — NOT NULL
  • order_number (Field) — VARCHAR(255)
  • total_amount (Field3) — DECIMAL(10, 2)
  • status (Field2) — ENUM
  • payment_method (Field4) — ENUM
  • created_at (Field5) — TIMESTAMP
  • user_id (Key2) — INT — Foreign key → users.id — NOT NULL

product_images (CopyOfUntitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • image_url (Field) — VARCHAR(512)
  • order (Field2) — INT
  • is_thumbnail (Field3) — BOOLEAN
  • product_id (Key2) — INT — Foreign key → products.id — NOT NULL

products (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR(255)
  • description (Field2) — TEXT
  • price (Field3) — DECIMAL(10, 2)
  • discount_price (Field4) — DECIMAL(10, 2)
  • stock (Field5) — INT
  • status (Field6) — ENUM — ['active', 'inactive', 'soldout', 'hidden']
  • category_id (Key2) — INT — Foreign key → categories.id — NOT NULL
  • user_id (Key3) — INT — Foreign key → users.id — NOT NULL

reviews (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)

  • id (Key) — INT — Primary key — NOT NULL
  • rating (Field) — INT
  • content (Field3) — TEXT
  • images (Field2) — ['url', 'url']
  • created_at (Field4) — TIMESTAMP
  • product_id (Key2) — INT — Foreign key → products.id — NOT NULL
  • user_id (Key3) — INT — Foreign key → users.id — NOT NULL
  • order_item_id (Key4) — INT — Foreign key → order_items.id — NOT NULL

scraps (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfUntitled22)

  • id (Key) — INT — Primary key — NOT NULL
  • created_at (Field4) — TIMESTAMP
  • target_id (Field2) — INT
  • target_type (Field) — ENUM — ['product']
  • user_id (Key2) — INT — Foreign key → users.id — NOT NULL

users (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • email (Field) — VARCHAR(255) — unique
  • nickname (Field2) — VARCHAR(255) — unique
  • profile_image (Field3) — VARCHAR(512)
  • role (Field4) — ENUM — ['user', 'seller', 'admin']
  • created_at (Field5) — TIMESTAMP
  • updated_at (Field6) — TIMESTAMP