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