shopping

Tables (9)

Untitled (shopping_member_address)

  • Key (m_id) — Foreign key → shopping _member.Key — NOT NULL
  • Field (m_address-name)
  • Field2 (m_address_phone) — null
  • Field (m_address) — null

Untitled (shoppintg_product_review)

  • member_id (Key) — Primary key — NOT NULL
  • product_no (varchar2(30)) — Primary key
  • Field2 (char(8))
  • product_review_content (varchar2(1500))
  • Field4 (number(1))
  • Field (product_review_date) — null

Untitled (coupon)

  • c_no (varchar2(30)) — Primary key — NOT NULL
  • seller_id (varchar2()30)) — Foreign key → shopping_seller.seller_id — NOT NULL
  • c_effective_date (date)
  • c_price (number)

Untitled (shopping_order)

  • order_no (char(8)) — not null — Primary key — NOT NULL
  • Key (m_id) — Foreign key → shopping _member.Key — NOT NULL
  • Key (m_grade_no) — not null — Foreign key → shopping _member.Key — NOT NULL
  • order_date (date)
  • order_adress (varchar2(100)) — null
  • order_address_name (varchar2(50)) — null
  • order_address_tel (char(11)) — null
  • order_ea (number)
  • order_credit_money (order_pay)
  • order_credit_kind (number(1))

shopping _member (shopping_member)

  • Key (m_id) — Primary key — NOT NULL
  • Key (m_grade_no) — not null — Foreign key → shopping_member_grade.Key — NOT NULL
  • Field (m_passwd)
  • Field2 (m_name)
  • Field3 (m_phone)
  • Field4 (m_email)
  • Field5 (m_point)
  • Field (m_birth)
  • Field2 (m_grade)

shopping_member_grade

  • Key (m_grade_no) — not null — Primary key — NOT NULL
  • Field (m_grade_name) — null

shopping_parcel (Untitled)

  • parcel_no (char(4)) — not null — Primary key — NOT NULL
  • member_id (Key) — Foreign key → Untitled.member_id — NOT NULL
  • product_no (varchar2(30)) — Foreign key → Untitled.product_no
  • parcel_name (varchar2(50))
  • parcel_tel_no (char(11))
  • parcel_price (number)

shopping_product (product)

  • Key (product_no) — not null — Primary key — NOT NULL
  • Key (seller_id) — not null — Foreign key → shopping_seller.seller_id — NOT NULL
  • Field (product_name) — null
  • Field2 (product_origin) — null
  • Field3 (product_ea) — null
  • Field4 (product_price) — null
  • Field (product_kc_no) — null
  • Field3 (product_main_img)
  • Field (product_sumbnail_img)

shopping_seller

  • seller_id (varchar2()30)) — Primary key — NOT NULL
  • seller_passwd (varchar2(30))
  • seller_business_no — not null
  • Field3 (seller_business_name) — null
  • Field4 (seller_ceo) — null
  • Field (seller_business_tel) — null
  • Field2 (seller_business_tel_no) — null
  • Field3 (seller_business_address) — null
  • Field (seller_business_addressv) — null