id
uuid
PRIMARY KEY, DEFAULT gen_random_uuid()
user_id
uuid
NOT NULL, FK → users.id
category_id
uuid
NOT NULL, FK → categories.id
title
varchar(100)
NOT NULL
price
numeric(10,2)
NOT NULL, DEFAULT 0.00
status
listing_status
NOT NULL, DEFAULT 'active'
is_boosted
boolean
NOT NULL, DEFAULT false
boost_expires_at
timestamptz
NULLABLE
deleted_at
timestamptz
NULLABLE
created_at
timestamptz
NOT NULL, DEFAULT now()
