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