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