simple-mall-erd

Tables (9)

AdminLog (Untitled9)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • admin_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
  • action (작업내용) — VARCHAR(100)
  • target_id (영향을 받은 ID) — BIGINT
  • timestamp (Field) — TIMESTAMP

Cart (Untitled3)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
  • product_id (Key3) — BIGINT — Foreign key → Product.id — NOT NULL
  • quantity (담은 수량) — INT

Event (Untitled8)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(100)
  • description (Field2) — TEXT
  • start_date (Field3) — DATE
  • end_date (Field4) — DATE
  • admin_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL

Notice (Untitled7)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • title (Field) — VARCHAR(100)
  • content (Field2) — TEXT
  • admin_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
  • created_at (Field3) — TIMESTAMP

Order (Untitled4)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
  • total_price (Field) — DECIMAL(10,2)
  • status (Field2) — ENUM('pending', 'shipped', 'delivered', 'canceled')
  • created_at (Field3) — TIMESTAMP

OrderItem (Untitled5)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • product_id (Key2) — BIGINT — Foreign key → Product.id — NOT NULL
  • order_id (Key3) — BIGINT — Foreign key → Order.id — NOT NULL
  • quantity (Field) — INT
  • price (Field2) — DECIMAL(10,2)

Payment (Untitled6)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • order_id (Key2) — BIGINT — Foreign key → Order.id — NOT NULL
  • payment_method (Field) — ENUM('credit_catrd', 'paypal', 'bank_transfer')
  • status (Field2) — ENUM('paid', 'failed', 'refunded')
  • paid_at (Field3) — TIMESTAMP

Product (Untitled2)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(100)
  • price (Field2) — DECIMAL(10,2)
  • stock (Field3) — INT
  • category_id (Field4) — BIGINT
  • description (Field5) — TEXT
  • created_at (Field6) — TIMESTAMP
  • updated_at (Field7) — TIMESTAMP

User (Untitled)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • email (Field2) — VARCHAR(100)
  • password (Field3) — VARCHAR(255)
  • role (Field4) — ENUM('admin', 'customer')
  • created_at (Field5) — TIMESTAMP