Natura
Tables (13)
ai_recommendations
- recommendation_id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- recommendation_type — VARCHAR(30) — NOT NULL
- score — DECIMAL(5,2)
- reason — TEXT
- created_at — TIMESTAMP — NOT NULL
cart_items
- cart_item_id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
categories
- category_id — BIGSERIAL
- parent_id — BIGINT
- category_name — VARCHAR(100) — NOT NULL
- depth — INT — NOT NULL
- sort_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
delivery_addresses
- address_id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- recipient_name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- zipcode — VARCHAR(10) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- detail_address — VARCHAR(100)
- delivery_memo — VARCHAR(200)
- is_default — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
health_surveys
- survey_id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- diseases — TEXT
- allergies — TEXT — 알러지
- diet_habits — TEXT
- restricted_foods — TEXT
- ai_analysis — TEXT — AI
- version — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
mileage_history
- mileage_id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- order_id — BIGINT
- amount — DECIMAL(10,2) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- description — VARCHAR(200)
- balance — DECIMAL(10,2) — NOT NULL — 변경
- created_at — TIMESTAMP — NOT NULL
order_items
- order_item_id — BIGSERIAL
- order_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- quantity — INT — NOT NULL
- unit_price — DECIMAL(10,2) — NOT NULL
- subtotal — DECIMAL(10,2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
payments
- payment_id — BIGSERIAL
- order_id — BIGINT — NOT NULL
- payment_method — VARCHAR(30) — NOT NULL
- payment_amount — DECIMAL(10,2) — NOT NULL
- mileage_used — DECIMAL(10,2)
- payment_status — VARCHAR(20) — NOT NULL
- transaction_id — VARCHAR(100) — 결제
- paid_at — TIMESTAMP
- refunded_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
product_images
- image_id — BIGSERIAL
- product_id — BIGINT — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
- is_main — BOOLEAN — NOT NULL
- sort_order — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
products
- product_id — BIGSERIAL
- category_id — BIGINT — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- product_code — VARCHAR(50)
- food_code — VARCHAR(50)
- description — TEXT
- detail_description — TEXT
- original_price — DECIMAL(10,2) — NOT NULL
- discount_rate — INT
- sale_price — DECIMAL(10,2) — NOT NULL
- stock_quantity — INT — NOT NULL
- low_stock_threshold — INT
- delivery_fee — DECIMAL(10,2)
- storage_method — VARCHAR(50) — 보관방법:
- status — VARCHAR(20) — NOT NULL — 상태:
- sales_count — INT — NOT NULL
- view_count — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
reviews
- review_id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- order_item_id — BIGINT — NOT NULL — 주문
- rating — INT — NOT NULL
- content — TEXT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_profiles
- profile_id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- gender — VARCHAR(10)
- age — INT
- height — DECIMAL(5,2)
- weight — DECIMAL(5,2)
- bmi — DECIMAL(5,2)
- updated_at — TIMESTAMP — NOT NULL
users
- user_id — BIGSERIAL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL — 상태:
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL