Today's house

Tables (14)

administrator (관리자)

  • admin_no (Field) — Primary key
  • admin_id (Field2)
  • admin_pw (Field3)

book_mark (북마크)

  • book_mark_id (Field) — Primary key
  • prod_id (Field4) — Foreign key → product.prod_id
  • user_no (NUMBER) — Foreign key → user.user_no

deal_of_today (오늘의 딜)

  • dot_date (Field2)
  • dot_due_day (Field3)
  • dot_discount (Field4)
  • prod_id (Field5) — Foreign key → product.prod_id

exhibition (기획전)

  • exh_date (Field3)
  • exh_due_day (Field4)
  • admin_no (Field5) — Foreign key → administrator.admin_no
  • prod_id (Field) — Foreign key → product.prod_id

file (파일업로드)

  • file_no (Field2) — Primary key
  • admin_no (Field)
  • origin_name (Field3)
  • stored_name (Field4)
  • file_date (Field5)
  • notice_no (Field7) — Foreign key → notice.notice_no

inquiry (1:1 문의)

  • inquiry_no (Field) — Primary key
  • inquiry_title (Field3)
  • inquiry_sort (Field4)
  • inquiry_content (Field5)
  • inquiry_date (Field6)
  • inquiry_reply_date (Field7)
  • user_no (NUMBER) — Foreign key → user.user_no
  • admin_no (Field2) — Foreign key → administrator.admin_no

notice (공지사항)

  • notice_no (Field) — Primary key
  • notice_title (Field3)
  • notice_sort (Field4)
  • notice_content (Field5)
  • notice_date (Field6)
  • notice_corrected_date (Field7)
  • admin_no (Field8) — Foreign key → administrator.admin_no

order_details (주문내역)

  • order_no (Field3) — Primary key
  • user_no (NUMBER) — Foreign key → user.user_no
  • order_date (Field4)
  • delivery_status (Field5)
  • prod_id (Field) — Foreign key → product.prod_id

pay (결재)

  • pay_no (Field) — Primary key
  • pay_method (Field4)
  • pay_date (Field5)
  • user_no (NUMBER) — Foreign key → user.user_no
  • prod_id (Field2) — Foreign key → product.prod_id

product (상품)

  • prod_id (Field) — Primary key
  • prod_name (Field2)
  • prod_sort (Field3)
  • prod_price (Field4)
  • prod_comment (Field6)
  • number_of_prods (Field7)
  • user_no (NUMBER) — Foreign key → user.user_no
  • pay_no (Field5) — Foreign key → pay.pay_no
  • user_no (NUMBER2) — Foreign key → shopping_basket.user_no

review (리뷰)

  • rev_no (Field) — Primary key
  • prod_id (Field7) — Foreign key → product.prod_id
  • user_no (NUMBER) — Foreign key → user.user_no
  • user_no (Field2)
  • prod_no (Field3)
  • rev_content (Field4)
  • rev_date (Field5)
  • rev_corrected_date (Field6)

shopping_basket (장바구니)

  • user_no (NUMBER) — Foreign key → user.user_no
  • bas_count (Field3)
  • prod_id (Field) — Foreign key → product.prod_id

used_market (중고마켓)

  • used_no (Field2) — Primary key
  • used_name (Field3)
  • used_sort (Field4)
  • used_price (Field5)
  • used_date (Field6)
  • user_no (NUMBER) — Foreign key → user.user_no

user (사용자)

  • user_no (NUMBER) — Primary key
  • user_name (Field)
  • user_id (Field2)
  • user_pw (Field3)
  • user_address (Field4)
  • user_gender (Field5)
  • user_phone (Field6)
  • user_email (Field7)