ASHOP2
Tables (10)
Untitled (AP_Product)
- Key (product_no) — NUMBER — Primary key — NOT NULL
- Key (admin_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (product_code) — VARCHAR2(20)
- Field (product_name) — VARCHAR2(50)
- Field (product_price) — NUMBER
- Field2 (product_supplier) — VARCHAR2(50)
- Field (product_stock) — NUMBER
- Field2 (product_date) — DATE
Untitled (AP_ProductImage)
- Key (image_no) — NUMBER — Primary key — NOT NULL
- Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — VARCHAR2(300)
- Field (image_original_filename) — VARCHAR2(400)
Untitled (AP_ProductGroup)
- Key (productgroup_no) — NUMBER — Primary key — NOT NULL
- Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (group_category_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (AP_Group_Category)
- Key (group_category_no) — NUMBER — Primary key — NOT NULL
- Field (group_category_name) — VARCHAR2(100)
Untitled (AP_User)
- Key (user_no) — NUMBER — Primary key — NOT NULL
- Field (user_id) — VARCHAR2(100)
- Field (user_pw) — VARCHAR2(100)
- Field (user_name) — VARCHAR2(100)
- Field (user_phone) — VARCHAR2(20)
- Field (user_email) — VARCHAR2(50)
- Field (user_joindate) — DATE
Untitled (AP_Cart)
- Key (cart_no) — NUMBER — Primary key — NOT NULL
- Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (product_count) — NUMBER
Untitled (AP_OrderDetail)
- Key (orderdetail_no) — NUMBER — Primary key — NOT NULL
- Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (order_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (AP_Order)
- Key (order_no) — NUMBER — Primary key — NOT NULL
- Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (order_date)
Untitled (AP_Admin)
- Key (admin_no) — NUMBER — Primary key — NOT NULL
- Field (admin_id) — VARCHAR2(20)
- Field (admin_pw) — VARCHAR2(100)
- Field (admin_phone) — VARCHAR2(30)
- Field (admin_email) — VARCHAR2(100)
- Field (admin_joindate) — DATE
Untitled (AP_GoodsView)
- Key (goodsview_no) — NUMBER — Primary key — NOT NULL
- Key (product_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (image_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (goodsview_count) — NUMBER
- Field (goodsview_date) — DATE