ㅁㅁㅁㅁ
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