bikemarket

Tables (5)

chat_messages

  • id — BIGINT
  • room_id — BIGINT — NOT NULL
  • sender_id — UUID — NOT NULL
  • content — TEXT — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

chat_rooms

  • id — BIGINT
  • product_id — BIGINT — NOT NULL
  • buyer_id — UUID — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

favorites

  • user_id — UUID — Primary key — NOT NULL
  • product_id — BIGINT — Primary key — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

products

  • id — BIGINT
  • seller_id — UUID — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT — NOT NULL
  • price — INT — NOT NULL
  • image_urls — TEXT — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • location — VARCHAR(50) — NOT NULL
  • status — product_status — NOT NULL
  • view_count — INT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

profiles

  • id — UUID
  • nickname — VARCHAR(20) — NOT NULL
  • profile_image_url — TEXT
  • location — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL