ERD

erDiagram
base_entity {
	LocalDateTime created_at
	LocalDateTime updated_at
}

users ||--o{ follow: have
users ||--o{ review: have
users ||--o{ product: have
users ||--o{ question: have
users ||--|| cart: have
users {
	bigint id PK

	varchar nickname
	varchar email
	varchar address
	varchar profile_image
	bigint following_count
	bigint follower_count
}

follow {
	bigint id PK

	bigint following_user_id FK
	bigint follower_user_id FK
}

users ||--o{ question : have
question {
	bigint id PK

	bigint author_id FK

	varchar content
	int count
}

question ||--o{ question_image : have
question_image {
	bigint id PK

	bigint question_id FK

	varchar image_url
	bigint order
}

users ||--o{ question_comment : have
question ||--o{ question_comment : have
question_comment {
	bigint id PK

	bigint author_id FK
	bigint question_id FK

	varchar content
}

users ||--o{ question_comment_reply : have
question_comment ||--O{ question_comment_reply : have
question_comment_reply  {
	bigint id PK

	bigint author_id FK

	varchar content
}
question ||--o{ question_keyword : have
question_keyword  {
	bigint id PK

	varchar name
	varchar category
}
question ||--o{ q_qk_link : have
question_keyword ||--o{ q_qk_link : have
q_qk_link {
	bigint id PK

	bigint question_id FK
	bigint keyword_id FK
}

users ||--o{ post : have
post ||--o{ post_image : have
post ||--o{ post_comment : have
post {
	bigint id PK
	bigint user_id FK
	varchar title
	varchar content
	int visit_count
	int scrap_count
	bigint writer
	bigint residence
	bigint area
	bigint budget
	bigint family
	bigint style
	bigint color_main
	bigint color_wall
	bigint color_floor
	bigint construction
	bigint expertise
	bigint agent
}
post_image {
	bigint id PK
	bigint post_id FK

	varchar url
	bigint order
}
post_comment {
	bigint id PK

	bigint post_id FK
	bigint author_id FK

	varchar title
	varchar content
}
users ||--o{ scrap_post : have
post ||--o{ scrap_post : have
scrap_post {
	bigint id PK

	bigint user_id FK
	bigint post_id FK
}

review {
	bigint id PK

	bigint product_id FK
	bigint user_id FK

	int durability_point
	int price_point
	int design_poin
	int shipping_point
	varchar contents
	int help_point
}

question {
	bigint id PK

	bigint product_id FK
	bigint user_id FK

	varchar purchase_status
	varchar contents
}

seller {
	bigint id PK
	bigint user_id FK
	varchar seller_name
}

product ||--o{ review: have
product ||--o{ question: have
product ||--|{ order_item: have
product ||--|{ cart_item: have
product ||--|{ seller: have
product {
	bigint id PK
	varchar name
	bigint price
	varchar contents
}

delivery {
	bigint id PK
	bigint order_id FK
	varchar delivery_status
	varchar address
	LocalDate delivery_date
}

orders ||--|| delivery: have
orders ||--|{ order_item: have
orders {
	bigint id PK
	bigint customer_id FK
	bigint total_price

}

cart_item {
	bigint id PK
	bigint cart_id FK
	bigint product_id FK
}

order_item {
	bigint id PK
	bigint order_id FK
	bigint product_id FK
	bigint cart_id FK
	bigint quantity
	bigint price
}

cart ||--o{ cart_item: have
cart {
	bigint id PK
	varchar user_id FK
}

item_scrap {
	bigint id PK
	bigint user_id
	bigint product_id
}

category |o--o{ category: have
category {
	bigint id PK
	bigint parent_id FK
}

review_image {
}