ashop

Tables (10)

AP_Admin

  • user_admin_no (admin_no) — NUMBER — Primary key — NOT NULL
  • user_admin_id (admin_id) — VARCHAR2(100)
  • user_admin_pw (admin_pw) — VARCHAR2(100)
  • user_admin_email (admin_email) — VARCHAR2(100)
  • user_admin_grade (admin_grade) — VARCHAR2(10)
  • user_admin_joindate (admin_joindate) — DATE

AP_Cart

  • cart_no — NUMBER — Primary key — NOT NULL
  • user_no — NUMBER — Foreign key → AP_User.user_no — NOT NULL
  • product_no — NUMBER — Foreign key → AP_Product.product_no — NOT NULL
  • product_count — NUMBER

AP_Group_Category

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

AP_OrderDetail

  • orderdetail_no — NUMBER — Primary key — NOT NULL
  • product_no — NUMBER — Foreign key → AP_Product.product_no — NOT NULL
  • user_no — NUMBER — Foreign key → AP_User.user_no — NOT NULL
  • Field (order_date) — DATE

AP_Product

  • product_no — NUMBER — Primary key — NOT NULL
  • user_admin_no (admin_no) — NUMBER — Foreign key → AP_Admin.user_admin_no — NOT NULL
  • product_name — VARCHAR2(50)
  • product_price — NUMBER
  • product_supplier (product_info) — VARCHAR2(2000)
  • product_stock — NUMBER
  • product_date — DATE
  • Field (product_supplier) — VARCHAR2(100)

AP_ProductBoard

  • productboard_no — NUMBER — Primary key — NOT NULL
  • user_no — NUMBER — Foreign key — NOT NULL
  • productboard_title — VARCHAR2(50)
  • productboard_content — VARCHAR2(4000)
  • productboard_writedate — DATE

AP_ProductGroup

  • productgroup_no — NUMBER — Primary key — NOT NULL
  • product_no — NUMBER — Foreign key → AP_Product.product_no — NOT NULL
  • group_category_no — NUMBER — Foreign key → AP_Group_Category.group_category_no — NOT NULL

AP_ProductImage

  • image_no — NUMBER — Primary key — NOT NULL
  • product_no — NUMBER — Foreign key → AP_Product.product_no — NOT NULL
  • user_admin_no — NUMBER — Foreign key → AP_Product.user_admin_no — NOT NULL
  • image_url — VARCHAR2(300)
  • image_original_filename — VARCHAR2(400)

AP_User

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

Untitled (AP_productLike)

  • Key (like_no) — NUMBER — Primary key — NOT NULL
  • product_no — NUMBER — Foreign key → AP_Product.product_no — NOT NULL
  • user_no — NUMBER — Foreign key → AP_User.user_no — NOT NULL
  • Field (like_date) — DATE