carrot
Tables (6)
Untitled2 (Location)
- Key (location_id) — Primary key — NOT NULL
- Field (city)
- Field (district)
Untitled2 (Category)
- Key (category_id) — Primary key — NOT NULL
- Field (name)
- Field (parent_category_id)
Untitled2 (Product)
- Key (product_id) — Primary key — NOT NULL
- Key (category_id) — Foreign key → Untitled2.Key — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL
- Key (location_id) — Foreign key → User.Key — NOT NULL
- Field (title)
- Field (description)
- Field2 (price)
- Field3 (condition)
- Field4 (created_at)
- Field5 (updated_at)
Untitled2 (Chat)
- Key2 (chat_id) — Primary key — NOT NULL
- Key (product_id) — Foreign key → Untitled2.Key — NOT NULL
- Key (category_id) — Foreign key → Untitled2.Key — NOT NULL
- user_id — Foreign key → Untitled2.user_id — NOT NULL
- Key (location_id) — Foreign key → Untitled2.Key — NOT NULL
- Field (created_at)
- Field2 (updated_at)
Untitled2 (Message)
- Key (message_id) — Primary key — NOT NULL
- Key2 (chat_id) — Foreign key → Untitled2.Key2 — NOT NULL
- Key (product_id) — Foreign key → Untitled2.Key — NOT NULL
- Key (category_id) — Foreign key → Untitled2.Key — NOT NULL
- user_id — Foreign key → Untitled2.user_id — NOT NULL
- Key (location_id) — Foreign key → Untitled2.Key — NOT NULL
- Field (content)
- Field (created_at)
User
- user_id — Primary key — NOT NULL
- Key (location_id) — Foreign key → Untitled2.Key — NOT NULL
- name
- Field2 (email)
- Field3 (password)
- Field4 (gender)
- Field (age)
- Field2