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