c조 NS
테이블 (9)
Basket (basket)
- Basket ID (basket_id) — NUMEBER — 기본 키 — NOT NULL
- Member ID (member_id) — VARCHAR(255) — 외래 키 → Member.Member ID — NOT NULL
- Basket Amount (basket_amount) — NUMBER
- Product ID (product_id) — NUMBER — 외래 키 → Product.Product ID — NOT NULL
Member (member)
- Member ID (member_id) — VARCHAR(255) — 기본 키 — NOT NULL
- Member PW (member_pw) — VARCHAR(255)
- Member Name (member_name) — VARCHAR(255)
- Member Phone (member_phone) — VARCHAR(255)
- Member_Gender (member_gender) — VARCHAR2(10 BYTE)
- Member_Email (member_email) — VARCHAR(255)
- Member_Birth Day (member_birthday) — DATE
- Member_role — NUMBER
Member_Order (order)
- Order ID (order_id) — NUMBER — 기본 키 — NOT NULL
- Member ID (member_id) — VARCHAR(255) — 외래 키 → Member.Member ID — NOT NULL
- Order State (order_state) — VARCHAR(255)
- Order Date (order_date) — DATE
- Order Price (order_price) — NUMBER
- Order Payment Method (order_payment_method) — VARCHAR(255)
- Order Receive Address (order_receive_address) — VARCHAR(255)
- Order Receive Name (order_receive_name) — VARCHAR(255)
- Order Receive Phone (order_receive_phone) — VARCHAR(255)
Notice Board (notice_board)
- Notice Board ID (notice_board_id) — NUMBER — 기본 키 — NOT NULL
- Member ID (member_id) — VARCHAR(255) — 외래 키 → Member.Member ID — NOT NULL
- Notice Board Title (notice_board_title) — VARCHAR(255)
- Notice Board Content (notice_board_content) — VARCHAR(255)
- Notice Board Date (notice_board_date) — DATE
- Notice Board Hit (notice_board_hit) — NUMBER
OrderDetail (order_detail)
- Order Detail ID (order_detail_id) — NUMBER — 기본 키 — NOT NULL
- Order ID (order_id) — NUMBER — 외래 키 → Member_Order.Order ID — NOT NULL
- Member ID (member_id) — VARCHAR(255) — 외래 키 → Member_Order.Member ID — NOT NULL
- Order Detail Amount (order_detail_amount) — NUMBER
- Order Detail Price (order_detail_price) — NUMBER
- Order Detail Review (oredr_detail_review) — NUMBER(0, 1)
- Product ID (product_id2) — NUMBER — 외래 키 → Product.Product ID — NOT NULL
Product (product)
- Product ID (product_id) — NUMBER — 기본 키 — NOT NULL
- Product Name (product_name) — VARCHAR(255)
- Product Price (product_price) — NUMBER
- Product Main IMG Path (product_main_img_path) — VARCHAR(255)
- Product Content IMG Path (product_content_img_path) — VARCHAR(255)
- Product Stock (product_stock) — NUMBER
- Product Category (product_category) — VARCHAR(255)
- Product Content (product_content) — VARCHAR(255)
QNA Board (qna_board)
- QNA Board ID (qna_board_id) — NUMBER — 기본 키 — NOT NULL
- Member ID (member_id) — VARCHAR(255) — 외래 키 → Member.Member ID — NOT NULL
- QNA Board Title (qna_board_title) — VARCHAR(255)
- QNA Board Date (qna_board_date) — DATE
- QNA Board Content (qna_board_content) — VARCHAR(255)
- QNA Board Group No (qna_board_group_no) — NUMBER
- QNA Board Lock (qna_board_lock) — NUMBER(0,1)
- QNA Board Reply State (qna_board_reply_state) — NUMBER(0,1)
- QNA Board Hit (qna_board_hit) — NUMBER
- Product ID (product_id2) — NUMBER — 외래 키 → Product.Product ID — NOT NULL
Review Board (review_board)
- Review Board ID (review_board_id) — NUMBER — 기본 키
- Member ID (member_id) — VARCHAR(255) — 외래 키 → Member.Member ID — NOT NULL
- Review Board Title (review_board_title) — VARCHAR(255)
- Review Board Content (review_board_content) — VARCHAR(255)
- Review Board Date (review_board_date) — DATE
- Review Board Score (review_board_score) — NUMBER
- Review Board Hit (review_board_hit) — NUMBER
- Reveiw Board IMG Path (review_board_img_path) — VARCHAR(255)
- Product ID (product_id2) — NUMBER — 외래 키 → Product.Product ID — NOT NULL
Review Reply (review reply)
- Review Reply ID (review_reply_id) — NUMBER — 기본 키 — NOT NULL
- Review Board ID (review_board_id) — NUMBER — 외래 키 → Review Board.Review Board ID
- Member ID (review_board_member_id) — VARCHAR(255) — 외래 키 → Review Board.Member ID — NOT NULL
- Member ID (member_id) — VARCHAR(255) — 외래 키 → Member.Member ID — NOT NULL
- Review Reply Content (review_reply_content) — VARCHAR(255)
- Review Reply Date (review_reply_date) — Date
- Review Reply Group No (review_reply_group_no) — NUMBER
- Review Reply Depth (review_reply_depth) — NUMBER
- Review Reply Group Order (review_reply_group_order) — NUMBER