졸업요건

테이블 (11)

Cart (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • created_at (Field)
  • updated_at (Field2)
  • guest_uuid (Field3)
  • Member_id (Key2) — 외래 키 → Member.id — NOT NULL

Cart_product (Untitled9)

  • id (Key) — 기본 키 — NOT NULL
  • created_at (Field)
  • updated_at (Field3)
  • quantity (Field2)
  • cart_id (Key2) — 외래 키 → Cart.id — NOT NULL
  • option_id (Key3) — 외래 키 → product_option.id — NOT NULL

Member (Untitled)

  • id (Key) — 기본 키 — NOT NULL
  • created_at (Field6)
  • updated_at (Field7)
  • guest_uuid (Field5)
  • insta_id (Field2)
  • name (Field)
  • password (Field4)
  • phone (Field3)
  • user_id (Field8)

Order (Untitled5)

  • id (Key) — 기본 키 — NOT NULL
  • created_at (Field3)
  • updated_at (Field4)
  • ordered_at (Field)
  • order_status (Field2)
  • total_amount (Field5)
  • orderUuid (Field6)
  • currency (Field7)
  • pgtransactionId (Field8)
  • paymentMethod (Field9)
  • Member_id (Key2) — 외래 키 → Member.id — NOT NULL

Order_address (CopyOfUntitled2)

  • id (Key2) — 기본 키 — NOT NULL
  • created_at (Field7)
  • updated_at (Field8)
  • city (Field3)
  • country (Field)
  • state (Field2)
  • street_address (Field4)
  • detail_address (Field5)
  • zip_code (Field6)
  • district (Field14)
  • first_name (Field10)
  • last_name (Field11)
  • email (Field9)
  • phone (Field13)
  • insta_id (Field12)
  • order_id (Key) — 외래 키 → Order.id — NOT NULL

Order_product (Untitled8)

  • id (Key) — 기본 키 — NOT NULL
  • created_at (Field)
  • updated_at (Field4)
  • quantity (Field3)
  • price (Field2)
  • Order_id (Key2) — 외래 키 → Order.id — NOT NULL
  • option_id (Key3) — 외래 키 → product_option.id — NOT NULL

category (Untitled10)

  • id (Key) — 기본 키 — NOT NULL
  • category_middle (Field)
  • category_small (Field2)

product (Untitled11)

  • id (Key2) — 기본 키 — NOT NULL
  • name (Field)
  • brand (Field2)
  • product_code (Field3)
  • image_url (Field4)
  • short_description (Field5)
  • long_description (Field6)
  • category_id (Key) — 외래 키 → category.id — NOT NULL

product_option (Untitled12)

  • id (Key) — 기본 키 — NOT NULL
  • option_name (Field3)
  • price_mxn (Field)
  • sku_code (Field4)
  • weight (Field2)
  • product_id (Key2) — 외래 키 → product.id — NOT NULL

화장품 (Untitled3)

  • id (Key) — 기본 키 — NOT NULL
  • 이름 (Field)
  • 가격 (Field2)
  • 제품설명 (Field3)
  • 조회수 (Field4)
  • 제품타입 (Field5)

화장품 사진 (Untitled7)

  • id (Key) — 기본 키 — NOT NULL
  • 이미지 (Field)
  • 화장품_id (Key2) — 외래 키 → 화장품.id — NOT NULL