쇼핑몰 ERD

테이블 (8)

Delivery (Untitled7)

  • delivery_id (Key) — bigint — 기본 키 — NOT NULL
  • order_id (Field) — varchar2(20)
  • recipient_name (Field2) — varchar2(20)
  • recipient_phone (Field3) — varchar2(20)
  • zipcode (Field4) — varchar2(20)
  • address_detail (Field5) — varchar2(50)
  • Field6

Member (Untitled2)

  • id (Key) — varchar(20) — 기본 키 — NOT NULL
  • password (Field2) — bigint
  • name (Field3) — varchar2(10)
  • birthday (Field4) — varchar2(10)
  • phonenumber (Field5) — varchar2(20)
  • skin_type (Field6) — varchar2(20)
  • skin_troble (Field) — varchar2(20)
  • created_at (Field7) — date

Order (Untitled6)

  • order_ID (Key) — varchar2(20) — 기본 키 — NOT NULL
  • member_id (Key2) — varchar2(20) — 기본 키 — NOT NULL
  • order_status (Field) — varchar2(10)
  • total_price (Field2) — varchar2(20)
  • ordered_at (Field3) — date
  • Field4
  • Field5

Payment (Untitled4)

  • Key — 기본 키 — NOT NULL
  • orderName (Field) — varchar2(20)
  • Field2
  • Field3
  • Field4

Review (Untitled8)

  • review_id (Key) — varchar2(20) — 기본 키 — NOT NULL
  • product_id (Field) — varchar2(20)
  • member_id (Field2) — varchar2(20)
  • rating (Field3) — bigint
  • content (Field4) — varchar2(500)
  • created_at (Field5) — date

ShoppingCart (Untitled3)

  • id (Key) — varchar2(20) — 기본 키 — NOT NULL
  • product_id (Field) — varchar2(20)
  • price (Field2) — varchar2(20)
  • sale_price (Field3) — varchar2(20)
  • delivery_information (Field4) — varchar2(50)

Untitled

    product (Untitled5)

    • product_id (Key) — varchar2(20) — 기본 키 — NOT NULL
    • product_name (Field) — varchar2(20)
    • price (Field2) — varchar2(20)
    • sale_price (Field3) — varchar2(20)
    • Field4