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