CarrotMarket_DB
Tables (7)
chat_tb
- id — BIGINT — Primary key — NOT NULL
- 구매자 (buyer) — BIGINT — Foreign key → user_tb.id — NOT NULL
- 판매자 (seller) — BIGINT — Foreign key → user_tb.id — NOT NULL
- product_id — BIGINT — Foreign key → product_tb.id — NOT NULL
- createAt — DATETIME
- updateAt — DATETIME
product_category_tb
- id — BIGINT — Primary key — NOT NULL
- 세부 상품 유형 (product_type) — VARCHAR
product_image_tb
- id — BIGINT — Primary key — NOT NULL
- 상품 id (product_id) — BIGINT — Foreign key → product_tb.id — NOT NULL
- createAt — DATETIME
- updateAt — DATETIME
- 경로 (image_path) — VARCHAR
product_tb
- id — BIGINT — Primary key — NOT NULL
- user.id (user_id) — BIGINT — Foreign key → user_tb.id — NOT NULL
- 상품 유형 id (type_id) — BIGINT — Foreign key → product_category_tb.id — NOT NULL
- createAt — DATETIME
- updateAt — DATETIME
- 제목 (title) — VARCHAR
- 내용 (content) — VARCHAR
- 좋아요 (interested) — INT
- 조회수 (views) — INT
- 판매 여부 (status) — VARCHAR
region_tb
- id — BIGINT — Primary key — NOT NULL
- user.id (user_id) — BIGINT — Foreign key → user_tb.id — NOT NULL
- createAt — DATETIME
- updateAt — DATETIME
- 동네 이름 (region_name) — VARCHAR
- 동네 인증 여부 (auth) — BOOLEAN
user_image_tb
- id — BIGINT — Primary key — NOT NULL
- createAt — DATETIME
- updateAt — DATETIME
- 경로 (image_path) — VARCHAR
user_tb
- id — BIGINT — Primary key — NOT NULL
- image.id (image_id) — BIGINT — Foreign key → user_image_tb.id — NOT NULL
- createAt — DATETIME
- updateAt — DATETIME
- 매너 온도 (manner_tem) — INT
- 매너 평가 (manner_eval) — VARCHAR
- 거래 후기 (review) — VARCHAR
- nickname — VARCHAR
- 활동 배지 (badge) — BIGINT
- 전화번호 (phone_number) — VARCHAR