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