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)