shop_2022/02/06
Tables (14)
admin (Untitled15)
- admin_no (Key) — NUMVER — Primary key — NOT NULL
- admin_id (Field) — VARCHAR2(100)
- admin_pw (Field2) — VARCHAR2(100)
- admin_nick (Field3) — VARCHAR2(100)
admin_Q&A _comment (Untitled6)
- admin_q&a_comment_no (Key) — NUMBER — Primary key — NOT NULL
- q&a_no (Key2) — NUMVER — Foreign key → member_Q&A.q&a_no — NOT NULL
- q&a_comment_content (Field) — VARCHAR2(4000)
- q&a_comment_writedate (Field2) — DATE
category (Untitled2)
- category_no (Key) — NUMVER — Primary key — NOT NULL
- category_name (Field6) — VARCHAR2(100)
member (Untitled)
- member_no (Key) — NUMVER — Primary key — NOT NULL
- member_id (Field) — VARCHAR2(100)
- member_pw (Field2) — VARCHAR2(100)
- member_gender (Field3) — VARCHAR2(1)
- member_birth (Field4) — DATE
- member_phone (Field5) — VARCHAR2(30)
- member_email (Field6) — VARCHAR2(100)
- member_joindate (Field7) — DATE
- member_address (Field8) — VARCHAR2(500)
member_Q&A (Untitled10)
- q&a_no (Key) — NUMVER — Primary key — NOT NULL
- member_no (Key2) — NUMVER — Foreign key → member.member_no — NOT NULL
- category_no (Key3) — NUMVER — Foreign key → category.category_no — NOT NULL
- q&a_title (Field) — VARCHAR2(300)
- q&a_content (Field2) — VARCHAR2(4000)
- q&a_writedate (Field3) — DATE
member_cart (Untitled5)
- cart_no (Key) — NUMVER — Primary key — NOT NULL
- member_no (Key2) — NUMVER — Foreign key → member.member_no — NOT NULL
- option_no (Field2) — NUMBER — Foreign key → product_option.option_no
- order_count (Field) — NUMVER
member_order (Untitled9)
- order_no (Key) — NUMVER — Primary key — NOT NULL
- member_no (Key2) — NUMVER — Foreign key → member.member_no — NOT NULL
- option_no (Field5) — NUMBER — Foreign key → product_option.option_no
- order_date (Field) — DATE
- order_price (Field2) — NUMVER
- order_count (Field3) — NUMVER
- order_payment (Field4) — VARCHAR2(100)
member_q&a_imageboard (Untitled12)
- q&a_imageboard_no (Key) — NUMVER — Primary key — NOT NULL
- q&a_no (Key2) — NUMVER — Foreign key → member_Q&A.q&a_no — NOT NULL
- member_no (Key22) — NUMVER — Foreign key → member_Q&A.member_no — NOT NULL
- category_no (Key3) — NUMVER — Foreign key → member_Q&A.category_no — NOT NULL
- q&a_image_ name (Field) — VARCHAR2(300)
- q&a_image_url (Field2) — VARCHAR2(1000)
member_review (Untitled11)
- review_no (Key) — NUMVER — Primary key — NOT NULL
- member_no (Key2) — NUMVER — Foreign key → member.member_no — NOT NULL
- order_no (Key3) — NUMVER — Foreign key → member_order.order_no — NOT NULL
- review_value (Field) — VARCHAR2(300)
- review_content (Field2) — VARCHAR2(4000)
- review_writedate (Field3) — DATE
member_review_comment (Untitled7)
- review_comment_no (Key) — NUMBER — Primary key — NOT NULL
- review_no (Key2) — NUMVER — Foreign key → member_review.review_no — NOT NULL
- order_no (Key3) — NUMVER — Foreign key → member_review.order_no — NOT NULL
- review_comment_content (Field) — VARCHAR2(4000)
- review_comment_writedate (Field2) — DATE
member_review_imageboard (CopyOfUntitled12)
- review_imageboard_no (Key) — NUMVER — Primary key — NOT NULL
- review_no (Key2) — NUMVER — Foreign key → member_review.review_no — NOT NULL
- review_image_ name (Field) — VARCHAR2(300)
- review_image_url (Field2) — VARCHAR2(1000)
product_option (Untitled4)
- option_no (Field) — NUMBER — Primary key
- product_no (Key) — NUMVER — Foreign key → productinfo.product_no — NOT NULL
- option_name (Field2) — VARCHAR2(300)
- product_count (Field4) — NUMBER
productinfo (Untitled3)
- product_no (Key) — NUMVER — Primary key — NOT NULL
- category_no (Key2) — NUMVER — Foreign key → category.category_no — NOT NULL
- product_name (Field) — VARCHAR2(300)
- product_thumbnail (Field2) — VARCHAR2(300)
- product_price (Field3) — NUMVER
- product_saleprice (Field4) — NUMVER
- product_writedate (Field5) — DATE
- product_content (Field6) — VARCHAR2(4000)
- product_warning (Field9) — VARCHAR2(4000)
productinfo_image (Untitled14)
- product_image_no (Key) — NUMVER — Primary key — NOT NULL
- product_no (Key2) — NUMVER — Foreign key → productinfo.product_no — NOT NULL
- product_image_name (Field) — VARCHAR2(300)
- product_image_url (Field2) — VARCHAR2(1000)