مخطط قواعد البيانات ERD

erDiagram USERS { bigint id PK varchar name varchar email UK timestamp email_verified_at varchar password varchar phone date birthday boolean is_active timestamp created_at timestamp updated_at } CATEGORIES { bigint id PK varchar name_ar varchar name_en varchar slug UK varchar icon boolean is_active int sort_order timestamp created_at timestamp updated_at } PRODUCTS { bigint id PK varchar name varchar sku UK text description decimal price decimal discount_percentage int stock bigint category_id FK bigint brand_id FK enum status boolean featured timestamp created_at timestamp updated_at } ORDERS { bigint id PK varchar order_number UK bigint user_id FK enum status decimal total_amount decimal shipping_amount decimal discount_amount enum payment_status varchar payment_method text notes timestamp created_at timestamp updated_at } ORDER_ITEMS { bigint id PK bigint order_id FK bigint product_id FK int quantity decimal unit_price decimal total_price } BRANDS { bigint id PK varchar name varchar slug UK varchar logo boolean is_active } PRODUCT_IMAGES { bigint id PK bigint product_id FK varchar file_path varchar alt_text int sort_order } PRODUCT_REVIEWS { bigint id PK bigint product_id FK bigint user_id FK tinyint rating text comment boolean is_approved } SHIPPING_ADDRESSES { bigint id PK bigint user_id FK varchar title varchar full_name varchar phone varchar country varchar city varchar address_line_1 boolean is_default } LOYALTY_POINTS { bigint id PK bigint user_id FK int points_balance int total_earned int total_redeemed enum loyalty_tier } COUPONS { bigint id PK varchar code UK enum discount_type decimal value decimal min_order_amount int usage_limit timestamp starts_at timestamp expires_at boolean is_active } USERS ||--o{ ORDERS : "places" USERS ||--o{ SHIPPING_ADDRESSES : "has" USERS ||--|| LOYALTY_POINTS : "has" USERS ||--o{ PRODUCT_REVIEWS : "writes" CATEGORIES ||--o{ PRODUCTS : "contains" BRANDS ||--o{ PRODUCTS : "manufactures" PRODUCTS ||--o{ ORDER_ITEMS : "ordered_in" PRODUCTS ||--o{ PRODUCT_IMAGES : "has" PRODUCTS ||--o{ PRODUCT_REVIEWS : "receives" ORDERS ||--o{ ORDER_ITEMS : "contains"