marketplace-test-project

Tables (5)

articles (Articles)

  • Id (id) — bigint — Primary key — NOT NULL
  • CreatedAt (created_at) — timestamp_tz
  • UpdatedAt (updated_at) — timestamp_tz
  • Title (title) — text
  • Content (content) — text
  • Thumbnail (thumbnail) — text
  • Featured (featured) — boolean

bids (Bids)

  • Id (id) — bigint — Primary key — NOT NULL
  • OfferId (offer_id) — UUID — Foreign key → offers.Id — NOT NULL
  • UserId (user_id) — text — Foreign key → users.Id — NOT NULL
  • CreatedAt (created_at) — timestamp_tz
  • Bid (bid) — bigint

comments (Comments)

  • Id (id) — UUID — Primary key — NOT NULL
  • UserId (user_id) — text — Foreign key → users.Id — NOT NULL
  • OfferId (offer_id) — UUID — Foreign key → offers.Id — NOT NULL
  • Content (content) — text
  • CreatedAt (created_at) — timestamp_tz

offers (Offers)

  • Id (id) — UUID — Primary key — NOT NULL
  • CreatedAt (created_at) — timestamp_tz
  • UpdatedAt (updated_at) — timestamp_tz
  • Name (name) — text
  • Description (description) — text
  • StartBid (start_bid) — bigint
  • Thumbnail (thumbnail) — text

users (Users)

  • Id (id) — text — Primary key — NOT NULL
  • CreatedAt (created_at) — timestamp_tz
  • UpdatedAt (updated_at) — timestamp_tz
  • Name (name) — text
  • LastSeen (last_seen) — timestamp_tz