SFC_20220127
Tables (12)
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)
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
- q&a_comment (Field4) — VARCHAR2(4000)
member_cart (Untitled5)
- wishlist_no (Key) — NUMVER — Primary key — NOT NULL
- member_no (Key2) — NUMVER — Foreign key → member.member_no — NOT NULL
- product_no (Key3) — NUMVER — Foreign key → productinfo.product_no — NOT NULL
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
- product_no (Key3) — NUMVER — Foreign key → productinfo.product_no — NOT NULL
- review_title (Field) — VARCHAR2(300)
- review_content (Field2) — VARCHAR2(4000)
- review_writedate (Field3) — DATE
- review_comment (Field4) — VARCHAR2(4000)
member_review_imageboard (CopyOfUntitled12)
- q&a_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_image (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_imageboard (Untitled14)
- productinfo_imageboard_no (Key) — NUMVER — Primary key — NOT NULL
- product_no (Key2) — NUMVER — Foreign key → productinfo.product_no — NOT NULL
- productinfo_image_name (Field) — VARCHAR2(300)
- productinfo_image_url (Field2) — VARCHAR2(1000)