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