carrot
Tables (5)
Untitled (product_img)
- Key (url) — varchar(255) — Primary key — NOT NULL
- product_id — int(11) — Foreign key → products.product_id — NOT NULL
Untitled (chatrooms)
- room_id — int(11) — Primary key — NOT NULL
- product_id — int(11) — Foreign key → products.product_id — NOT NULL
- user_id (seller_id) — int(11) — Foreign key → users.user_id — NOT NULL
- user_id (buyer_id) — int(11) — Foreign key → users.user_id — NOT NULL
Untitled (chats)
- chat_id — int(11) — Primary key — NOT NULL
- content — longtext — NOT NULL
- time — timestamp — NOT NULL
- room_id — int(11) — Foreign key → Untitled.room_id — NOT NULL
- user_id (sender_id) — int(11) — Foreign key → users.user_id — NOT NULL
- read — bit(1) — NOT NULL
products
- product_id — int(11) — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- price — int(11)
- register_date — timestamp — NOT NULL
- category — varchar(20) — NOT NULL
- content — longtext — NOT NULL
- user_id — int(11) — Foreign key → users.user_id — NOT NULL
users
- user_id — int(11) — Primary key — NOT NULL
- area — VARCHAR(20)