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