review
Tables (13)
Category (category)
- UID (id) — bigint — Primary key — NOT NULL
- Parent (parent_id) — bigint — Foreign key → Category.UID — NOT NULL
- Created At (created_at) — date
- Updated At (updated_at)
- Name (name) — varchar(20)
- Description (desc) — text
ExpertReview (expert_review)
- UID (id) — bigint — Primary key — NOT NULL
- Product (product_id) — bigint — Foreign key → Product.UID — NOT NULL
- User (user_id) — bigint — Foreign key → User.UID — NOT NULL
- Created At (created_at) — date
- Updated At (updated_at) — date
- Review (review) — text
- Rating (rating) — int
- PerformanceRating (performance_rating) — int
- DesignRating (design_rating) — int
- DurabilityRating (durability_rating) — int
- PriceRating (price_rating) — int
- ReviewLink (review_link) — varchar(200)
- IsRecommended (is_recommended) — bit(1)
File (file)
- UID (id) — bigint — Primary key — NOT NULL
- Product (product_id) — bigint — Foreign key → Product.UID — NOT NULL
- UserReview (user_review_id) — bigint — Foreign key → UserReview.UID — NOT NULL
- ExpertReview (expert_review_id) — bigint — Foreign key → ExpertReview.UID — NOT NULL
- Uploaded By (uploaded_by) — bigint — Foreign key → User.UID — NOT NULL
- Updated By (updated_by) — bigint — Foreign key → User.UID — NOT NULL
- Path (path) — varchar(200)
- Name (name) — varchar(50)
- Type (type) — int
- Size (size) — int
Like (Untitled2)
- UID (id) — bigint — Primary key — NOT NULL
- User (user_id) — bigint — Foreign key → User.UID — NOT NULL
- Expert Review (expert_review_id) — bigint — Foreign key → ExpertReview.UID — NOT NULL
- User Review (user_review_id) — bigint — Foreign key → UserReview.UID — NOT NULL
- Like (like) — bit(1)
- Comment (comment) — text
- Created At (created_at) — date
- Updated At (updated_at) — date
Manufactor (manufactor)
- UID (id) — bigint — Primary key — NOT NULL
- Name (name) — varchar(20)
- Description (desc) — text
- Website (website) — varchar(200)
Notification (notification)
- UID (id) — bigint — Primary key — NOT NULL
- User (user_id) — bigint — Foreign key → User.UID — NOT NULL
- Sender (sender_id) — bigint — Foreign key → User.UID — NOT NULL
- Notified At (notified_at) — date
- Title (title) — varchar(50)
- Body (body) — varchar(200)
- Action (action) — varchar(200)
- Read At (read_at) — date
- Product (product_id) — bigint — Foreign key → Product.UID — NOT NULL
- UserReview (user_review_id) — bigint — Foreign key → UserReview.UID — NOT NULL
- ExpertReview (expert_review_id) — bigint — Foreign key → ExpertReview.UID — NOT NULL
- Like (like_id) — bigint — Foreign key → Like.UID — NOT NULL
Oauth (oauth)
- UID (id) — bigint — Primary key — NOT NULL
- User Id (user_id) — bigint — Foreign key → User.UID — NOT NULL
- Token (token) — varchar(100)
- Provider (provider) — varchar(100)
Price (price)
- UID (id) — bigint — Primary key — NOT NULL
- Product (product_id) — bigint — Foreign key → Product.UID — NOT NULL
- Created At (created_at) — date
- Currency (currency) — varchar(10)
- Price (price) — bigint
Product (product)
- UID (id) — bigint — Primary key — NOT NULL
- Category (category_id) — bigint — Foreign key → Category.UID — NOT NULL
- Manufactor (manufactor_id) — bigint — Foreign key → Manufactor.UID — NOT NULL
- Created At (created_at) — date
- Updated At (updated_at) — date
- Name (name) — varchar(100)
- Description (desc) — text
- Website (website) — varchar(200)
Session (session)
- UID (id) — bigint — Primary key — NOT NULL
- User Id (user_id) — bigint — Foreign key → User.UID — NOT NULL
- Created At (created_at) — date
- Remote IP (remote_ip) — varchar(20)
- User Agent (user_agent) — varchar(40)
- Valid Until (valid_until)
User (user)
- UID (id) — bigint — Primary key — NOT NULL
- Username (username) — varchar(20)
- Password Hash (passwd) — varchar(100)
- Real Name (real_name) — varchar(20)
- Email (email) — varchar(40)
- Bio (bio) — text
- Created At (created_at) — date
- Created At IP (created_at_ip) — varchar(20)
- Updated At (updated_at) — date
- Updated At IP (updated_at_ip) — varchar(20)
- State (state) — int
- Trust Score (trust_score) — bigint
- Rank (class) — int
- Type (type) — int
UserReview (user_review)
- UID (id) — bigint — Primary key — NOT NULL
- Product (product_id) — bigint — Foreign key → Product.UID — NOT NULL
- User (user_id) — bigint — Foreign key → User.UID — NOT NULL
- Created At (created_at) — date
- Updated At (updated_at) — date
- Review (review) — text
- Rating (rating) — int
- IsRecommended (is_recommended) — bit(1)
Verification (verification)
- UID (id) — bigint — Primary key — NOT NULL
- User Id (user_id) — bigint — Foreign key → User.UID — NOT NULL
- Code (code) — varchar(100)
- Type (type) — int
- New Email (new_email) — varchar(40)
- Valid Until (valid_until) — date