Database

Core Entities

User Entity

- id: Long (Primary Key)
- username: String (Unique)
- email: String (Unique)
- password: String (Encoded)
- fullName: String
- phoneNumber: String
- address: Text
- role: Enum (USER, ADMIN)
- isActive: Boolean
- createdAt: DateTime
- updatedAt: DateTime

Product Entity

- id: Long (Primary Key)
- productId: String (Unique)
- title: String
- description: Text
- price: BigDecimal
- status: Enum (AVAILABLE, SOLD, RESERVED)
- accountLevel: Integer
- gameServer: String
- featuredCharacters: String (JSON)
- images: String (JSON Array)
- type: Enum (STARTER, PREMIUM, WHALE)
- lastUpdateDate: DateTime
- createdAt: DateTime
- updatedAt: DateTime

Order Entity

- id: Long (Primary Key)
- orderNumber: String (Unique)
- userId: Long (Foreign Key)
- totalAmount: BigDecimal
- status: Enum (PENDING, PROCESSING, COMPLETED, FAILED, CANCELLED)
- paymentMethod: String
- paymentStatus: Enum (PENDING, PAID, FAILED)
- qrCodeUrl: String
- transactionId: String
- notes: Text
- createdAt: DateTime
- updatedAt: DateTime

Character Entity (Wiki)

- id: Long (Primary Key)
- name: String
- nickname: String
- class: Enum (ATTACKER, RUNNER, DEFENDER)
- element: Enum (RED, BLUE, GREEN, DARK, LIGHT)
- rarity: Enum (EX, BF, STEP_UP)
- image: String
- characterTrait: Text
- trait1: Text
- trait2: Text
- boostTrait: Text
- hyperboostTrait: Text
- skill1: Text
- skill2: Text
- strongPoints: Text
- weakPoints: Text
- counterStrategies: Text
- recommendedMedals: Text
- recommendedSupports: Text
- playstyleGuide: Text
- videoGuides: String (JSON Array)
- createdAt: DateTime
- updatedAt: DateTime