Product Wish List Application ER Diagram
erDiagram
User {
INTEGER id PK
STRING email
STRING phone
BOOLEAN has_initial_profile
STRING photo
TEXT address
INTEGER gender_id FK
INTEGER country_id FK
DATE birthday
DATETIME created_at
DATETIME updated_at
}
Product {
INTEGER id PK
STRING name
STRING description
DECIMAL price
DATETIME created_at
DATETIME updated_at
}
ProductWhishList {
INTEGER id PK
INTEGER user_id FK
INTEGER product_id FK
BOOLEAN is_wished
DATETIME created_at
}
User ||--o{ ProductWhishList : "has"
Product ||--o{ ProductWhishList : "has"