[23'2학기-sql 프로그래밍 과제] 쇼핑몰 db 구축

테이블 (4)

Delivery (Untitled4)

  • delivery_id (Key) — 기본 키 — NOT NULL
  • departure_date (Field)
  • arrival_date (Field2)
  • delivery_address (Field3)
  • order_id (Key2) — Auto increment — 외래 키 → Orders.order_id — NOT NULL

Member (Untitled)

  • member_id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • address (Field2)
  • birthdate (Field3) — NOT NULL
  • phone (Field4)
  • email (Field6)
  • password (Field7)
  • sex (Field8)
  • signup_date (Field5)
  • modify_date (Field9)

Orders (Untitled2)

  • order_id (Key) — Auto increment — 기본 키 — NOT NULL
  • delivery_address (Field2)
  • order_date (Field3)
  • order_phone (Field)
  • order_name (Field5)
  • quantity (Field4)
  • order_modify_date (Field6)
  • member_id (Key3) — 외래 키 → Member.member_id — NOT NULL
  • product_id (Key2) — 외래 키 → Product.product_id — NOT NULL

Product (Untitled3)

  • product_id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • price (Field2)
  • color (Field3)
  • quantity (Field4)
  • size (Field5)