ASHOP

Tables (10)

AP_Board

  • board_no — NUMBER — Primary key — NOT NULL

AP_Cart

  • cart_no — NUMBER — Primary key — NOT NULL
  • product_count — NUMBER

AP_DeliverAddress

  • address_no — NUMBER — Primary key — NOT NULL
  • addresss_post — VARCHAR2(20)
  • address_form — VARCHAR2(20)
  • address_detail — VARCHAR2(20)

AP_Group_Category (Untitled2)

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

AP_Order

  • order_no — NUMBER — Primary key — NOT NULL
  • user_no — NUMBER — NOT NULL
  • order_date — DATE
  • order_status — VARCHAR2(10)

AP_OrderDetail

  • orderdetail_no — NUMBER — Primary key — NOT NULL
  • order_no — NUMBER — NOT NULL
  • product_count — NUMBER
  • product_price — NUMBER

AP_Product

  • product_no — NUMBER — Primary key — NOT NULL
  • product_code (category_code) — VARCHAR2(10)
  • product_name — VARCHAR2(50)
  • product_price — NUMBER
  • product_stock — NUMBER
  • product_info — VARCHAR2(4000)
  • product_date — DATE
  • product_supplier (product_hits) — NUMBER

AP_ProductGroup (Untitled)

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

AP_ProductImage (Untitled3)

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

AP_User

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