carrotMarket

Tables (9)

Copy Of Copy Of Untitled (likes)

  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (post_id) — bigint — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (createdAt) — datetime — NOT NULL

Copy Of Copy Of Untitled2 (images)

  • Key (image_id) — bigint — Primary key — NOT NULL — auto_increment
  • Key (post_id) — bigint — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Field (url) — varchar(250) — NOT NULL

Copy Of Untitled (posts)

  • Key (post_id) — bigint — Primary key — NOT NULL — auto_increment
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (location_id) — bigint — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Field (title) — varchar(50) — NOT NULL
  • Field (decription) — text — NOT NULL
  • Field (price) — integer
  • Field (type) — varchar(50) — NOT NULL — forSale, free
  • Field (status) — varchar(50) — NOT NULL — forSale, reserved, sold
  • Field (created_at) — datetime — NOT NULL

Copy Of Untitled2 (locations)

  • Key (location_id) — bigint — Primary key — NOT NULL — auto_increment
  • Field (city) — varchar(50) — NOT NULL
  • Field (addr1) — varchar(50) — NOT NULL
  • Field (addr2) — varchar(50) — NOT NULL

Untitled (users)

  • Key (user_id) — bigint — Primary key — NOT NULL — auto_increment
  • Key (phone) — varchar(20) — Primary key — NOT NULL
  • Key (location_id) — bigint — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (password) — varchar(50) — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (chatRoom_user)

  • Key (chatRoom_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (role) — varchar(50) — NOT NULL — seller, buyer

Untitled (post_chatRooom)

  • Key (post_id) — bigint — Foreign key → Copy Of Untitled.Key — NOT NULL
  • Key (chatRoom_id) — bigint — Foreign key → Untitled.Key — NOT NULL — auto_increment

Untitled (chatRooms)

  • Key (chatRoom_id) — bigint — Primary key — NOT NULL — auto_increment
  • Field (createdAt) — datetime — NOT NULL

Untitled (messages)

  • Key (message_id) — bigint — Primary key — NOT NULL
  • Key (chatRoom_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL — auto_increment
  • Field (content) — text — NOT NULL
  • Field (createdAt) — datetime — NOT NULL