subak
Tables (7)
COMMENT (댓글)
- cm_id (댓글아이디) — Primary key — NOT NULL
- post_Id (게시글아이디) — Foreign key → POST.post_Id — NOT NULL
- member_Id (회원아이디) — Foreign key → MEMBER.member_Id — NOT NULL
- cm_content (댓글내용)
- cm_date (댓글작성일)
HEART (좋아요)
- like_id (좋아요아이디) — Primary key — NOT NULL
- member_Id (회원아이디) — Foreign key → MEMBER.member_Id — NOT NULL
- post_Id (게시글아이디) — Foreign key → POST.post_Id — NOT NULL
MEMBER (멤버)
- member_Id (회원아이디) — Primary key — NOT NULL
- member_email (회원이메일)
- member_name (이름)
- member_pw (비밀번호)
- member_phone (전화번호)
- member_temp (매너온도)
- member_picture (프로필사진)
- authentication_type (인증타입)
POST (게시글)
- post_Id (게시글아이디) — Primary key — NOT NULL
- member_Id (회원아이디) — Foreign key → MEMBER.member_Id — NOT NULL
- category (카테고리)
- post_title (제목)
- price (가격)
- like (즐겨찾기)
- post_time (게시시간)
- views (조회수)
- post_image (게시글사진)
- product_status (상품상태)
- post_status (게시글상태)
REVIEW (리뷰)
- review_id (리뷰아이디) — Primary key — NOT NULL
- member_Id (회원아이디) — Foreign key → MEMBER.member_Id — NOT NULL
- post_Id (게시글아이디) — Foreign key → POST.post_Id — NOT NULL
- score (리뷰점수)