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)