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)