ada

Tables (6)

board_comments (게시물댓글)

  • b_c_id (댓글번호) — int — Primary key — NOT NULL
  • board_id (게시물id) — int — Foreign key → board_info.board_id — NOT NULL
  • b_c_writer (댓글작성자) — varchar
  • b_c_date (댓글작성일) — date
  • b_c_content (댓글내용) — varchar
  • b_c_like (댓글좋아요) — int

board_info (게시판정보)

  • board_id (게시물id) — int — Primary key — NOT NULL
  • board_num (게시물번호) — int
  • board_title (게시물제목) — varchar
  • board_likes (게시물좋아요수) — int
  • board_content (게시물내용) — varchar
  • board_writer (게시물작성자) — varchar
  • board_date (게시물작성일) — date
  • board_readcount (게시물조회수) — int
  • board_category (게시물카테고리) — varchar
  • board_image (게시물 사진 url) — varchar

order (주문)

  • user_num (회원번호) — int — Foreign key → user_info.user_num — NOT NULL
  • product_id (육아용품번호) — int — Foreign key → product_info.product_id — NOT NULL
  • order_date (주문일) — date

product_info (육아용품정보)

  • product_id (육아용품번호) — int — Primary key — NOT NULL
  • product_amount (육아용품수량) — int
  • product_point (육아용품가격포인트) — int
  • product_like (찜이눌린횟수) — int
  • product_image (육아용품사진url) — varchar
  • product_createtime (육아용품등록일) — date
  • product_name (육아용품이름) — varchar
  • product_about (육아용품설명) — varchar
  • product_status (육아용품상태) — char(14)

product_like (장바구니)

  • product_id (육아용품번호) — int — Primary key — NOT NULL
  • user_num (회원번호) — int — Foreign key → user_info.user_num — NOT NULL
  • product_name (육아용품이름) — varchar
  • product_likecount (장바구니 속 육아용품 갯수) — int
  • product_likeprice (장바구니 육아용품 총 가격) — int

user_info (회원정보)

  • user_num (회원번호) — int — Primary key — NOT NULL
  • user_id (회원ID) — varchar
  • user_name (회원이름) — varchar
  • user_pwd (비밀번호) — varchar
  • user_sex (성별) — char(2)
  • user_age (생년월일) — date
  • user_phone (핸드폰번호) — varchar
  • user_email (이메일) — varchar
  • user_grade (등급) — varchar
  • user_kakao (오픈카카오톡) — varchar
  • user_birth (자녀생일) — date
  • user_joindate (가입일) — date
  • user_point (보유포인트) — int