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