ㅁㅁㅁㅁ

Tables (8)

Copy Of Order (CopyOfOrder)

  • orderId — BIGINT
  • userId — BIGINT — NOT NULL
  • orderStatus — VARCHAR(50) — NOT NULL
  • totalAmount — INT — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

Copy Of User (CopyOfUser)

  • id — BIGINT
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — ENUM('ADMIN', 'USER') — NOT NULL
  • address — VARCHAR(255)
  • name — VARCHAR(255)
  • isEnabled — BOOLEAN

Order

  • orderId — BIGINT
  • userId — BIGINT — NOT NULL
  • orderStatus — VARCHAR(50) — NOT NULL
  • totalAmount — INT — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

OrderItem

  • orderItemId — BIGINT
  • orderId — BIGINT — NOT NULL
  • productId — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • price — INT — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

Payment

  • paymentId — BIGINT
  • orderId — BIGINT — NOT NULL
  • paymentStatus — VARCHAR(50) — NOT NULL
  • paymentDate — DATETIME — NOT NULL
  • paymentMethod — ENUM('CREDIT_CARD', 'PAYPAL', 'BANK_TRANSFER') — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME

Product

  • id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — INT — NOT NULL
  • stock — INT — NOT NULL
  • isFlashSale — BOOLEAN
  • flashSaleStartTime — DATETIME

User

  • id — BIGINT
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • role — ENUM('ADMIN', 'USER') — NOT NULL
  • address — VARCHAR(255)
  • name — VARCHAR(255)
  • isEnabled — BOOLEAN

WishList

  • id — BIGINT
  • userId — BIGINT — NOT NULL
  • productId — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME