halal

테이블 (8)

consumer_order_items

  • id — uuid
  • order_id — uuid — NOT NULL
  • product_id — uuid — NOT NULL
  • company_id — uuid — NOT NULL
  • quantity — int — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

consumer_orders

  • id — uuid
  • order_number — varchar(50) — NOT NULL
  • consumer_id — uuid — NOT NULL
  • delivery_address_id — uuid — NOT NULL
  • total_amount — DECIMAL(10,2) — NOT NULL
  • shipping_fee — DECIMAL(10,2) — NOT NULL
  • order_status — varchar(50) — NOT NULL
  • payment_status — varchar(50) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

consumers

  • id — uuid — 외래 키 → 기업.id — NOT NULL
  • email — varchar(255) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • password — varchar(255) — NOT NULL
  • profile_image — varchar(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

delivery_addresses

  • id — uuid
  • consumer_id — uuid — NOT NULL
  • recipient_name — varchar(100) — NOT NULL
  • recipient_phone — varchar(20) — NOT NULL
  • address — text — NOT NULL
  • is_default — boolean
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

product_reviews

  • id — uuid
  • consumer_id — uuid — NOT NULL
  • product_id — uuid — NOT NULL
  • rating — int — NOT NULL
  • review_text — text — NOT NULL
  • review_image — varchar(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

products

  • id — uuid
  • company_id — uuid — NOT NULL
  • price — DECIMAL(10,2) — NOT NULL
  • sales — int — NOT NULL
  • halal_certified — boolean — NOT NULL
  • halal_expiration — date
  • halal_certificate — varchar(255)
  • main_image_url — varchar(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

shopping_carts

  • id — uuid
  • consumer_id — uuid — NOT NULL
  • product_id — uuid — NOT NULL
  • quantity — int — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

기업 (companies)

  • id — uuid — 기본 키 — NOT NULL
  • business_registration_number — varchar(50) — NOT NULL
  • email — varchar(255) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • password — varchar(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP