미녀와야수

테이블 (8)

carrier (Untitled6)

  • delivery_id (Key) — number — 기본 키 — NOT NULL
  • carrier_name (Field) — varchar2(20)
  • carrier_phone (Field2) — varchar2(20)

cart (Untitled)

  • cart_id (Key) — number — 기본 키 — NOT NULL
  • cart_count (Field) — int
  • cart_date (Field2) — Date

coupon (Untitled4)

  • coupon_id (Key) — number — 기본 키 — NOT NULL
  • coupon_category (Field) — varchar2(20)
  • coupon_detail (Field2) — varchar2(100)
  • coupone_percent (Field3) — double

delivery (Untitled5)

  • delivery_id (Key) — number — 기본 키 — NOT NULL
  • delivery_status (Field) — varchar2(20)
  • delivery_date (Field2) — Date

order (Untitled8)

  • order_id (Key) — number — 기본 키 — NOT NULL
  • order_status (Field) — varchar2(5)
  • order_date (Field2) — Date

payment (Untitled2)

  • pay_id (Key) — number — 기본 키 — NOT NULL
  • pay_method (Field) — varchar2(20)
  • pay_status (Field2) — varchar2(5)
  • pay_amount (Field3) — double
  • pay_date (Field4) — Date

review (Untitled7)

  • review_id (Key) — number — 기본 키 — NOT NULL
  • rating (Field) — double
  • review_content (Field2) — varchar2(150)
  • review_date (Field3) — Date

vendor (Untitled3)

  • vendor_id (Key) — number — 기본 키 — NOT NULL
  • vendor_name (Field) — varchar2(20)
  • vendor_detail (Field2) — varchar2(100)