bookMarket
Tables (13)
bookmarks
- bookmark_id — INT — Primary key — NOT NULL
- user_id — INT
- item_id — INT
- notification_enabled — BOOLEAN
categories
- category_id — INT — Primary key — NOT NULL
- category_name — VARCHAR(255)
chats
- chat_id — INT — Primary key — NOT NULL
- sender_id — INT
- receiver_id — INT
- message — TEXT
- sent_time — DATETIME
evaluations
- evaluation_id — INT — Primary key — NOT NULL
- review — TEXT
- rating — INT
- user_id — INT — Foreign key → users.user_id — NOT NULL
- item_id — INT — Foreign key → items.item_id — NOT NULL
follows
- follow_id — INT — Primary key — NOT NULL
- follower_id — INT
- following_id — INT
items
- item_id — INT — Primary key — NOT NULL
- title — VARCHAR(255)
- description — TEXT
- price — INT
- createdAt — DATE
- user_id — INT — Foreign key → users.user_id — NOT NULL
- location_id — INT — Foreign key → locations.location_id — NOT NULL
- updatedAt — DATE
locations
- location_id — INT — Primary key — NOT NULL
- location_name — VARCHAR(255)
offers
- offer_id — INT — Primary key — NOT NULL
- sender_id — INT
- receiver_id — INT
- proposal — TEXT
- negotiation_status — VARCHAR(50)
- item_id — INT — Foreign key → items.item_id — NOT NULL
photos
- photo_id — INT — Primary key — NOT NULL
- image_url — VARCHAR(255)
- item_id — INT — Foreign key → items.item_id — NOT NULL
profiles
- profile_id — INT — Primary key — NOT NULL
- profile_picture — VARCHAR(255)
- personal_info — TEXT
- exchange_history — TEXT
- user_id — INT — Foreign key → users.user_id — NOT NULL
reports
- report_id — INT — Primary key — NOT NULL
- reporter_id — INT
- reported_user_id — INT
- description — TEXT
- resolution_status — VARCHAR(50)
tags
- tag_id — INT — Primary key — NOT NULL
- tag_name — VARCHAR(255)
users
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255)
- createdAt — DATE
- location_id — INT — Foreign key → locations.location_id — NOT NULL
- updatedAt — DATE