ashop

Tables (8)

AP_Cart

  • cart_no — NUMBER — Primary key — NOT NULL
  • product_count (cart_count) — NUMBER
  • Field (cart_subtotalprice) — NUMBER

AP_Order

  • order_no — NUMBER — Primary key — NOT NULL
  • user_no — NUMBER — Foreign key → AP_User.user_no — NOT NULL
  • product_no (product_info_no) — NUMBER — Foreign key → AP_Product.product_no — NOT NULL
  • Key (product_info_img_no) — NUMBER — Foreign key → AP_Product.Key — NOT NULL
  • cart_no — NUMBER — Foreign key → AP_Cart.cart_no — NOT NULL
  • order_date — DATE
  • order_status — VARCHAR2(10)
  • Field (order_address_postno) — VARCHAR2(20)
  • Field (order_address_main) — VARCHAR2(50)
  • Field (order_address_details) — VARCHAR2(50)
  • Field (order_receive_name) — VARCHAR2(20)
  • Field (order_receive_phone) — VARCHAR2(20)
  • Field (order_product_count) — NUMBER
  • Field (order_product_totalprice) — NUMBER

AP_Product (AP_ProductInfo)

  • product_no (product_info_no) — NUMBER — Primary key — NOT NULL
  • Key (category_no) — VARCHAR2(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (product_info_img_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field (product_info_code) — VARCHAR(40)
  • product_name (product_info_name) — VARCHAR2(50)
  • product_price (product_info_price) — NUMBER
  • product_info (product_info_details) — VARCHAR2(200)
  • product_date (product_info_date) — DATE
  • Field (product_info_image) — VARCHAR2(500)
  • Field (product_info_stock) — NUMBER

AP_User

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

Untitled (AP_ProductCategory)

  • Key (category_no) — VARCHAR2(30) — Primary key — NOT NULL
  • Field (category_name) — VHARCHAR2(50)

Untitled (AP_UserAdmin)

  • Key (user_admin_no) — NUMBER — Primary key — NOT NULL
  • user_no — NUMBER — Foreign key → AP_User.user_no — NOT NULL
  • Field (user_seller_joindate) — DATE

Untitled (AP_ProductBoard)

  • Key (product_board_no) — NUMBER — Primary key — NOT NULL
  • user_no — NUMBER — Foreign key → AP_User.user_no — NOT NULL
  • Field (product_board_title) — VARCHAR2(200)
  • Field (product_board_content) — VARCHAR2(4000)
  • Field (product_board_writedate) — DATE

Untitled (AP_ProductInfoImage)

  • Key (product_info_img_no) — NUMBER — Primary key — NOT NULL
  • Field (product_info_img_url) — VARCHAR2(300)
  • Field (product_info_img_origianl_filename) — VARCHAR2(400)
  • Field (product_info_img_thumnail) — VARCHAR2(300)