SFC_JBS
Tables (12)
Untitled (member_info)
- Key (member_no) — INT — Primary key — NOT NULL
- Field (member_id) — VARCHAR(100)
- Field (member_pw) — VARCHAR(100)
- Field (member_gender) — VARCHAR(1)
- Field (member_birth) — DATETIME
- Field (member_phone) — VARCHAR(40)
- Field (member_email) — VARCHAR(100)
- Field (member_joindate) — DATETIME
- Field (member_address) — VARCHAR(1000)
Untitled (category)
- Key (category_no) — INT — Primary key — NOT NULL
- Field (category_name) — VARCHAR(100)
Untitled (product_option)
- Key (option_no) — INT — Primary key — NOT NULL
- Key (product_no) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (product_count) — INT
- Field (option_name) — VARCHAR(300)
Untitled (product)
- Key (product_no) — INT — Primary key — NOT NULL
- Key (category_no) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (product_name) — VARCHAR(300)
- Field (product_price) — INT
- Field (product_saleprice) — INT
- Field (product_content) — VARCHAR(4000)
- Field (product_warning) — VARCHAR(4000)
- Field (product_writedate) — DATETIME
- Field (product_image) — VARCHAR(1000)
Untitled (cart)
- Key (cart_no) — INT — Primary key — NOT NULL
- Key (member_no) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (product_no) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (product_image)
- Key (product_image_no) — INT — Primary key — NOT NULL
- Key (product_no) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (product_image_url) — VARCHAR(1000)
- Field (product_image_name) — VARCHAR(500)
Untitled (admin)
- Key (admin_no) — INT — Primary key — NOT NULL
- Field (admin_id) — VARCHAR(100)
- Field (admin_pw) — VARCHAR(100)
- Field (admin_nick) — VARCHAR(100)
Untitled (member_qna)
- Key (qna_no) — INT — Primary key — NOT NULL
- Key (member_no) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (category_no) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (qna_title) — VARCHAR(500)
- Field (qna_content) — VARCHAR(4000)
- Field (qna_writedate) — DATETIME
- Field (qna_comment) — VARCHAR(4000)
Untitled (qna_image)
- Key (qna_Image_no) — INT — Primary key — NOT NULL
- Key (qna_no) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (qna_Image_url) — VARCHAR(1000)
- Field (qna_Image_name) — VARCHAR(500)
Untitled2 (order)
- Key (order_no) — INT — Primary key — NOT NULL
- Key (member_no) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (option_no) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (order_date) — DATETIME
- Field (order_price) — INT
- Field (order_count) — INT
- Field (order_payment) — VARCHAR(100)
Untitled2 (member_review)
- Key (review_no) — INT — Primary key — NOT NULL
- Key (member_no) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (product_no) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (review_title) — VARCHAR(500)
- Field (review_content) — VARCHAR(4000)
- Field (review_writedate) — DATETIME
- Field (review_comment) — VARCHAR(4000)
Untitled2 (review_image)
- Key (review_image_no) — INT — Primary key — NOT NULL
- Key (review_no) — INT — Foreign key → Untitled2.Key — NOT NULL
- Field (review_image_url) — VARCHAR(1000)
- Field (review_image_name) — VARCHAR(500)