못난이_작물_ERD
테이블 (23)
admin_logs
- id — BIGINT — 기본 키 — NOT NULL
- admin_id — BIGINT — 외래 키 → users.id — NOT NULL
- action — ENUM — NOT NULL
- target_type — ENUM — NOT NULL
- target_id — BIGINT — NOT NULL
- reason — VARCHAR(300)
- ip_address — VARCHAR(45)
- created_at — DATETIME — NOT NULL
admin_profiles
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- admin_name — VARCHAR(100) — NOT NULL
- department — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
ai_review_summaries
- id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — 외래 키 → products.id — NOT NULL
- summary — TEXT — NOT NULL
- review_count — INT — NOT NULL
- status — ENUM — NOT NULL
- is_active — BOOLEAN — NOT NULL
- error_message — VARCHAR(500)
- generated_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
cart_items
- id — BIGINT — 기본 키 — NOT NULL
- cart_id — BIGINT — 외래 키 → carts.id — NOT NULL
- product_id — BIGINT — 외래 키 → products.id — NOT NULL
- quantity — INT — NOT NULL
- price_snapshot — DECIMAL(10,0) — NOT NULL
- is_price_changed — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
carts
- id — BIGINT — 기본 키 — NOT NULL
- buyer_id — BIGINT — 외래 키 → users.id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
chatbot_faqs
- id — BIGINT — 기본 키 — NOT NULL
- category — VARCHAR(100)
- question — VARCHAR(500) — NOT NULL
- answer — TEXT — NOT NULL
- keywords — VARCHAR(500)
- is_active — BOOLEAN — NOT NULL
- created_by — BIGINT — 외래 키 → users.id — NOT NULL
- updated_by — BIGINT — 외래 키 → users.id
- deleted_by — BIGINT — 외래 키 → users.id
- deleted_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
chatbot_logs
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id
- session_id — VARCHAR(100)
- question — TEXT — NOT NULL
- answer — TEXT
- source_type — ENUM — NOT NULL
- source_id — BIGINT
- is_answered — BOOLEAN — NOT NULL
- error_message — VARCHAR(500)
- created_at — DATETIME — NOT NULL
notifications
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id
- type — VARCHAR(50) — NOT NULL
- message — VARCHAR(500) — NOT NULL
- target_url — VARCHAR(500)
- is_read — BOOLEAN — NOT NULL
- is_global — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
order_items
- id — BIGINT — 기본 키 — NOT NULL
- order_id — BIGINT — 외래 키 → orders.id — NOT NULL
- product_id — BIGINT — 외래 키 → products.id — NOT NULL
- seller_id — BIGINT — 외래 키 → users.id — NOT NULL
- quantity — INT — NOT NULL
- price — DECIMAL(10,0) — NOT NULL
- shipping_fee — DECIMAL(10,0) — NOT NULL
- status — ENUM — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
orders
- id — BIGINT — 기본 키 — NOT NULL
- order_number — VARCHAR(100) — NOT NULL
- buyer_id — BIGINT — 외래 키 → users.id — NOT NULL
- shipping_address — VARCHAR(500) — NOT NULL
- total_amount — DECIMAL(10,0) — NOT NULL
- total_shipping_fee — DECIMAL(10,0) — NOT NULL
- payment_method — ENUM — NOT NULL
- delivery_type — ENUM('delivery','pickup') — NOT NULL
- pickup_datetime — DATETIME
- status — ENUM — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- Key3 — 외래 키 — NOT NULL
- Key3 (Key32) — 외래 키 — NOT NULL
pickup_locations
- id — BIGINT — 기본 키 — NOT NULL
- seller_id — BIGINT — 외래 키 → users.id — NOT NULL
- address — VARCHAR(500) — NOT NULL
- latitude — DECIMAL(10,7)
- longitude — DECIMAL(10,7)
- operating_hours — VARCHAR(200)
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
posts
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- product_id — BIGINT — 외래 키 → products.id
- category — ENUM — NOT NULL
- title — VARCHAR(300) — NOT NULL
- content — TEXT — NOT NULL
- is_pinned — BOOLEAN — NOT NULL
- faq_type — VARCHAR(50)
- sort_order — INT
- view_count — INT — NOT NULL
- parent_id — BIGINT — 외래 키 → posts.id
- image_url — VARCHAR(500)
- deleted_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
product_images
- id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — 외래 키 → products.id — NOT NULL
- uuid — VARCHAR(100) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- sort_order — TINYINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
product_recommendations
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id
- session_id — VARCHAR(100)
- product_id — BIGINT — 외래 키 → products.id — NOT NULL
- reason — ENUM — NOT NULL
- score — DECIMAL(5,4) — NOT NULL
- rank_order — SMALLINT — NOT NULL
- expires_at — DATETIME
- generated_at — DATETIME — NOT NULL
products
- id — BIGINT — 기본 키 — NOT NULL
- seller_id — BIGINT — 외래 키 → users.id — NOT NULL
- category — VARCHAR(100) — NOT NULL
- name — VARCHAR(200) — NOT NULL
- description — TEXT
- price — DECIMAL(10,0) — NOT NULL
- discount_price — DECIMAL(10,0)
- discount_start_at — DATETIME
- discount_end_at — DATETIME
- thumbnail_url — VARCHAR(500)
- origin — VARCHAR(200) — NOT NULL
- expiry_date — DATE — NOT NULL
- is_pickup_available — BOOLEAN — NOT NULL
- stock_quantity — INT — NOT NULL
- status — ENUM — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
reports
- id — BIGINT — 기본 키 — NOT NULL
- reporter_id — BIGINT — 외래 키 → users.id — NOT NULL
- target_type — ENUM — NOT NULL
- target_id — BIGINT — NOT NULL
- reason — ENUM — NOT NULL
- detail — VARCHAR(300)
- status — ENUM — NOT NULL
- reviewed_by — BIGINT — 외래 키 → users.id
- reviewed_at — DATETIME
- created_at — DATETIME — NOT NULL
reviews
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- product_id — BIGINT — 외래 키 → products.id — NOT NULL
- order_item_id — BIGINT — 외래 키 → order_items.id — NOT NULL
- rating — TINYINT — NOT NULL
- content — TEXT — NOT NULL
- is_analyzed — BOOLEAN — NOT NULL
- deleted_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
sales_rankings
- id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — 외래 키 → products.id — NOT NULL
- seller_id — BIGINT — 외래 키 → users.id — NOT NULL
- period_type — ENUM — NOT NULL
- period_date — DATE — NOT NULL
- sales_count — INT — NOT NULL
- rank — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
seller_profiles
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- business_number — VARCHAR(20) — NOT NULL
- bank_account — VARCHAR(100) — NOT NULL
- farm_name — VARCHAR(200)
- farm_location — VARCHAR(500)
- farm_description — TEXT
- farm_photo_url — VARCHAR(500)
- farm_philosophy — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
settlements
- id — BIGINT — 기본 키 — NOT NULL
- seller_id — BIGINT — 외래 키 → users.id — NOT NULL
- order_item_id — BIGINT — 외래 키 → order_items.id — NOT NULL
- sale_amount — DECIMAL(10,0) — NOT NULL
- commission — DECIMAL(10,0) — NOT NULL
- settlement_amount — DECIMAL(10,0) — NOT NULL
- status — ENUM — NOT NULL
- settled_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
social_accounts
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id — NOT NULL
- provider — ENUM — NOT NULL
- provider_id — VARCHAR(255) — NOT NULL
- access_token — VARCHAR(500)
- linked_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(500)
- phone — VARCHAR(20)
- role — ENUM — NOT NULL
- push_agree — BOOLEAN — NOT NULL
- email_agree — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- deleted_at — DATETIME
- withdrawal_reason — VARCHAR(300)
- deleted_by — BIGINT — 외래 키 → users.id
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
verification_tokens
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.id
- target — VARCHAR(255) — NOT NULL
- token — VARCHAR(100) — NOT NULL
- purpose — ENUM — NOT NULL
- expires_at — DATETIME — NOT NULL
- used_at — DATETIME
- created_at — DATETIME — NOT NULL