인쇄골목
테이블 (7)
OrderPhotos
- PhotoID — INT
- OrderID — INT
- PhotoURL — VARCHAR(255) — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- isDeleted — BOOLEAN
Orders
- OrderID — INT
- UserID — INT
- ShopID — INT
- OrderDetails — TEXT — NOT NULL
- OrderStatus — ENUM('Placed', 'In Progress', 'Completed', 'Cancelled')
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- isDeleted — BOOLEAN
PrintShops
- ShopID — INT
- Name — VARCHAR(255) — NOT NULL
- Description — TEXT
- Location — VARCHAR(255)
- Rating — FLOAT
- TotalReviews — INT
- Category — VARCHAR(255) — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- isDeleted — BOOLEAN
ReviewPhotos
- PhotoID — INT
- ReviewID — INT
- PhotoURL — VARCHAR(255) — NOT NULL
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- isDeleted — BOOLEAN
Reviews
- ReviewID — INT
- UserID — INT
- ShopID — INT
- Rating — FLOAT — NOT NULL
- Comment — TEXT — EX
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- isDeleted — BOOLEAN
UserFavorites
- FavoriteID — INT
- UserID — INT
- ShopID — INT
- createdAt — TIMESTAMP
Users
- UserID — INT
- Username — VARCHAR(255) — NOT NULL
- Email — VARCHAR(255) — NOT NULL
- PasswordHash — VARCHAR(255) — NOT NULL
- SocialLoginType — ENUM('Google', 'Facebook', 'Kakao', 'None')
- ProfilePictureURL — VARCHAR(255)
- createdAt — TIMESTAMP
- updatedAt — TIMESTAMP
- isDeleted — BOOLEAN