ASHOP2

Tables (10)

Untitled (AP_Product)

  • Key (product_no) — NUMBER — Primary key — NOT NULL
  • Key (admin_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (product_code) — VARCHAR2(20)
  • Field (product_name) — VARCHAR2(50)
  • Field (product_price) — NUMBER
  • Field2 (product_supplier) — VARCHAR2(50)
  • Field (product_stock) — NUMBER
  • Field2 (product_date) — DATE

Untitled (AP_ProductImage)

  • Key (image_no) — NUMBER — Primary key — NOT NULL
  • Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (image_url) — VARCHAR2(300)
  • Field (image_original_filename) — VARCHAR2(400)

Untitled (AP_ProductGroup)

  • Key (productgroup_no) — NUMBER — Primary key — NOT NULL
  • Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (group_category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (AP_Group_Category)

  • Key (group_category_no) — NUMBER — Primary key — NOT NULL
  • Field (group_category_name) — VARCHAR2(100)

Untitled (AP_User)

  • Key (user_no) — NUMBER — Primary key — NOT NULL
  • Field (user_id) — VARCHAR2(100)
  • Field (user_pw) — VARCHAR2(100)
  • Field (user_name) — VARCHAR2(100)
  • Field (user_phone) — VARCHAR2(20)
  • Field (user_email) — VARCHAR2(50)
  • Field (user_joindate) — DATE

Untitled (AP_Cart)

  • Key (cart_no) — NUMBER — Primary key — NOT NULL
  • Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (product_count) — NUMBER

Untitled (AP_OrderDetail)

  • Key (orderdetail_no) — NUMBER — Primary key — NOT NULL
  • Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (order_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (AP_Order)

  • Key (order_no) — NUMBER — Primary key — NOT NULL
  • Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (order_date)

Untitled (AP_Admin)

  • Key (admin_no) — NUMBER — Primary key — NOT NULL
  • Field (admin_id) — VARCHAR2(20)
  • Field (admin_pw) — VARCHAR2(100)
  • Field (admin_phone) — VARCHAR2(30)
  • Field (admin_email) — VARCHAR2(100)
  • Field (admin_joindate) — DATE

Untitled (AP_GoodsView)

  • Key (goodsview_no) — NUMBER — Primary key — NOT NULL
  • Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (image_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (goodsview_count) — NUMBER
  • Field (goodsview_date) — DATE