fleamarket
Tables (5)
chat_room
- Key (post_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → post.Key — NOT NULL
- Key (buyer_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → user.Key — NOT NULL
item_image
- Key (image_id) — INT UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
- Field (image_data) — BLOB — NOT NULL
- Key (post_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → post.Key — NOT NULL
post
- Key (post_id) — INT UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
- Field (post_title) — VARCHAR(255) — NOT NULL
- Field (post_description) — VARCHAR(255) — NOT NULL
- Field (item_category) — VARCHAR(255) — NOT NULL
- Field (item_price) — INT UNSIGNED
- Key (seller_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → user.Key — NOT NULL
- Field (createdAt) — DATETIME — NOT NULL
- Field (updatedAt) — DATETIME — NOT NULL
user
- Key (user_id) — INT UNSIGNED AUTO_INCREMENT — Primary key — NOT NULL
- Field (login_id) — VARCHAR(20) — NOT NULL
- Field (login_pw) — VARCHAR(20) — NOT NULL
- Field (user_town) — VARCHAR(255) — NOT NULL
wish
- Key (post_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → post.Key — NOT NULL
- Key (buyer_id) — INT UNSIGNED AUTO_INCREMENT — Foreign key → user.Key — NOT NULL