carrot_market_clone

Tables (7)

Answer (CopyOfCopyOfCopyOfUntitled22)

  • Answer Id (id) — INT — Primary key — NOT NULL
  • Post Id (postId) — INT — Foreign key → Post.Post Id — NOT NULL
  • User Id (userId) — INT — Foreign key → Post.User Id — NOT NULL
  • User (user) — User
  • Answer Text (answer) — MEDIUMTEXT
  • CreatedAt (createdAt) — DATETIME
  • UpdatedAt (updatedAt) — DATETIME
  • Post (post) — Post

Fav (CopyOfCopyOfUntitled2)

  • Favorite Id (id) — INT — Primary key — NOT NULL
  • Product Id (productId) — INT — Foreign key → Product.Product id — NOT NULL
  • User Id (userId) — INT — Foreign key → Product.User id — NOT NULL
  • User (user) — User
  • Product (product) — Product
  • CreatedAt (createdAt) — DATETIME
  • UpdatedAt (updatedAt) — DATETIME

Post (CopyOfCopyOfUntitled22)

  • Post Id (id) — INT — Primary key — NOT NULL
  • User Id (userId) — INT — Foreign key → User.User id — NOT NULL
  • User (user) — User
  • Question (question) — MEDIUMTEXT
  • Answers (answers) — Answer[]
  • Wonderings (wonderings) — Wondering[]
  • CreatedAt (createdAt) — DATETIME
  • UpdatedAt (updatedAt) — DATETIME

Product (CopyOfUntitled2)

  • Product id (id) — INT — Primary key — NOT NULL
  • User id (userId) — INT — Foreign key → User.User id — NOT NULL
  • User (user) — User
  • Image URL (image) — VARCHAR(255)
  • Product Name (name) — VARCHAR(255)
  • Product Price (price) — INT
  • Product Description (description) — MEDIUMTEXT
  • Favorites (favs) — Fav[]
  • CreatedAt (createdAt) — DATETIME
  • UpdatedAt (updatedAt) — DATETIME

Token (CopyOfUntitled)

  • Token id (id) — INT — Primary key — NOT NULL
  • User id (userId) — INT — Foreign key → User.User id — NOT NULL
  • Token Value (payload) — VARCHAR(255)
  • User (user) — User
  • CreatedAt (createdAt) — DATETIME
  • UpdatedAt (updatedAt) — DATETIME

User (Untitled)

  • User id (id) — INT — Primary key — NOT NULL
  • User name (name) — VARCHAR(255)
  • User phone (phone) — VARCHAR(255)
  • User email (email) — VARCHAR(255)
  • User Image URL (avatar) — VARCHAR(255)
  • User Tokens (tokens) — Token[]
  • Products (products) — Products[]
  • Favorites (favs) — Fav[]
  • CreatedAt (createdAt) — DATETIME
  • UpdatedAt (updatedAt) — DATETIME

Wondering

  • Wondering Id (id) — INT — Primary key — NOT NULL
  • Post Id (postId) — INT — Foreign key → Post.Post Id — NOT NULL
  • User Id (userId) — INT — Foreign key → Post.User Id — NOT NULL
  • User (user) — User
  • Answer Text (answer) — MEDIUMTEXT
  • CreatedAt (createdAt) — DATETIME
  • UpdatedAt (updatedAt) — DATETIME
  • Post (post) — Post