AltProject
Tables (6)
category
- category_id — long — Primary key — NOT NULL
- 카테고리이름 (category_name) — varchar
chatRoom
- room_number — long — Primary key — NOT NULL
- 판매자 (seller_id) — long — Foreign key → user.user_id — NOT NULL
- 구매자 (buyer_id) — long — Foreign key → user.user_id — NOT NULL
like
- like_id — long — Primary key — NOT NULL
- user_id (id2) — long — Foreign key → user.user_id — NOT NULL
- product_id — long — Foreign key → product.product_id — NOT NULL
order
- order_id — long — Primary key — NOT NULL
- 구매되는 제품 (buy_product) — long — Foreign key → product.product_id — NOT NULL
- 제시하는 제품 (request_product) — long — Foreign key → product.product_id — NOT NULL
product
- product_id — long — Primary key — NOT NULL
- 제품이름 (product_name) — varchar
- 제품상세정보 (product_detail) — varchar
- 작성시간 (time) — localDateTime
- 수정시간 (edit_time) — localDateTime
- 좋아요수 (like_count) — long
- category_id — long — Foreign key → category.category_id — NOT NULL
- user_id (id) — long — Foreign key → user.user_id — NOT NULL
user
- user_id (id) — long — Primary key — NOT NULL
- 이메일 (email) — varchar — NOT NULL
- 이름 (name) — varchar
- 패스워드 (password) — varchar