A조

테이블 (8)

AP_Admin

  • user_admin_no — NUMBER — 기본 키 — NOT NULL
  • user_admin_joindate — DATE
  • user_admin_grade — VARCHAR2(10)
  • user_admin_id — VARCHAR2(100)
  • user_admin_pw — VARCHAR2(100)
  • user_admin_email — VARCHAR2(100)

AP_Board (AP_ProductBoard)

  • board_no (productboard_no) — NUMBER — 기본 키 — NOT NULL
  • user_no — NUMBER — 외래 키 → AP_User.user_no — NOT NULL
  • board_title (productboard_title) — VARCHAR2(50)
  • board_content (productboard_content) — VARCHAR2(4000)
  • board_writedate (productboard_writedate) — DATE

AP_Cart

  • cart_no — NUMBER — 기본 키 — NOT NULL
  • user_no — NUMBER — 외래 키 → AP_User.user_no — NOT NULL
  • product_no — NUMBER — 외래 키 → AP_Product.product_no — NOT NULL
  • product_count — NUMBER

AP_OrderDetail

  • orderdetail_no — NUMBER — 기본 키 — NOT NULL
  • product_no — NUMBER — 외래 키 → AP_Product.product_no — NOT NULL
  • user_no — NUMBER — 외래 키 → AP_User.user_no — NOT NULL
  • order_count (Field) — NUMBER
  • order_price (Field2) — NUMBER
  • order_date — DATE
  • order_status — VARCHAR2(10)

AP_Product

  • product_no — NUMBER — 기본 키 — NOT NULL
  • user_admin_no — NUMBER — 외래 키 → AP_Admin.user_admin_no — NOT NULL
  • product_name — VARCHAR2(50)
  • product_price — NUMBER
  • product_stock — NUMBER
  • product_date — DATE

AP_ProductGroup

  • productgroup_no — NUMBER — 기본 키 — NOT NULL
  • product_no — NUMBER — 외래 키 → AP_Product.product_no — NOT NULL
  • product_category_name — VARCHAR2(100)

AP_ProductImage

  • image_no — NUMBER — 기본 키 — NOT NULL
  • product_no — NUMBER — 외래 키 → AP_Product.product_no — NOT NULL
  • user_admin_no — NUMBER — 외래 키 → AP_Product.user_admin_no — NOT NULL
  • image_url — VARCHAR2(300)
  • image_original_fillename (image_original_filename) — VARCHAR2(400)

AP_User

  • user_no — NUMBER — 기본 키 — NOT NULL
  • user_id — VARCHAR2(100)
  • user_pw — VARCHAR2(100)
  • user_name — VARCHAR2(100)
  • user_phone — VARCHAR2(20)
  • user_email — VARCHAR2(100)
  • user_address — VARCHAR2(400)
  • user_joindate — DATE