matching

Tables (4)

Elevation (elevation)

  • RoleId (role_id) — Primary key — NOT NULL
  • UserId (user_id) — int — Foreign key → Users.UserId — NOT NULL
  • Content (content)
  • Status (status) — enum — request accepted rejected expired
  • Timestamp (timestamp)

Offer (offer)

  • BuyId (buy_id) — Primary key — NOT NULL
  • UserId (user_id) — int — Foreign key → Users.UserId — NOT NULL
  • ProductId (product_id) — int — Foreign key → Product.ProductId — NOT NULL
  • Content (content)
  • Status (status) — enum — NOT NULL — request accepted rejected expired
  • Timestamp (timestamp)

Product (product)

  • ProductId (product_id) — int — Primary key — NOT NULL
  • UserId (user_id) — int — Foreign key → Users.UserId — NOT NULL
  • Name (name)

Users (users)

  • UserId (user_id) — int — Primary key — NOT NULL
  • Name (name)
  • Profile (profile)
  • Role (role) — enum