111111
Tables (15)
Q&A (qna)
- qna_id (질문 id) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user.id — NOT NULL
- title (제목) — VARCHAR(100) — NOT NULL
- content (내용) — TEXT — NOT NULL
- created_date (작성일) — DATE — NOT NULL
- answer (답변) — TEXT — NOT NULL
- answer_date (답변 작성일) — DATE — NOT NULL
- status (답변상태) — enum('답변중,'답변완료') — NOT NULL
faq (자주묻는질문)
- faq_id (faq 아이디) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user.id — NOT NULL
- title (faq 제목) — VARCHAR(100) — NOT NULL
- content (faq 내용) — TEXT — NOT NULL
- created_date (작성일) — created_date — NOT NULL
hash_tag (해시태그)
- hash_tag_id (해시태그 번호) — BIGINT — Primary key — NOT NULL
- hash_tag (해시태그) — VARCHAR(100)
notice (공지사항)
- notice_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user.id — NOT NULL
- title (공지사항 제목) — VARCHAR(100) — NOT NULL
- content (공지사항 내용) — TEXT — NOT NULL
- created_date (작성일) — DATETIME — NOT NULL
notice_image (공지사항 이미지)
- notice_iamge_id (이미지번호) — BIGINT — Primary key — NOT NULL
- notice_id (Key) — BIGINT — Foreign key → notice.notice_id — NOT NULL
- image_file_name (저장된 이미지 이름) — VARCHAR(100) — NOT NULL
popComment (팝업댓글)
- pop_comment_id (댓글 id) — BIGINT — Primary key — NOT NULL
- popup_id (팝업 id) — BIGINT — Foreign key → popup.popup_id — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user.id — NOT NULL
- contetnt (댓글 내용) — TEXT — NOT NULL
- created_date (작성일) — DATETIME — NOT NULL
poplike (찜)
- pop_like_id (Key) — BIGINT — Primary key — NOT NULL
- popup_id (팝업 id) — BIGINT — Foreign key → popup.popup_id — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user.id — NOT NULL
popup (팝업등록폼)
- popup_id (팝업 id) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user.id — NOT NULL
- title (팝업이름) — VARCHAR(100) — NOT NULL
- info (팝업정보) — TEXT — NOT NULL
- popup_hours (팝업운영시간) — TEXT — NOT NULL
- content (팝업스토어 소개) — TEXT — NOT NULL
- address (팝업스토어 주소) — VARCHAR(100) — NOT NULL
- brand_page (브랜드 홈페이지 바로가기) — TEXT
- role (승인 여부) — enum('승인중','승인','취소')) — NOT NULL
- created_date (작성일) — DATETIME — NOT NULL
- hash_tag (해시태그) — VARCHAR(10)
- hits (조회수) — BIGINT — NOT NULL
- monday_time (월) — VARCHAR(20) — NOT NULL
- tuesday_time (화) — VARCHAR(20)
- wednesday_time (수) — VARCHAR(20) — NOT NULL
- thursday_time (목) — VARCHAR(20)
- friday_time (금) — VARCHAR(20) — NOT NULL
- saturday_time (토) — VARCHAR(20) — NOT NULL
- sunday_time (일) — VARCHAR(20) — NOT NULL
- parking (주차여부) — VARCHAR(20)
- fee (입장료)
popupImage (팝업이미지)
- popup_image_id (이미지번호) — BIGINT — Primary key — NOT NULL
- popup_id (팝업 id) — BIGINT — Foreign key → popup.popup_id — NOT NULL
- image_file_name (저장된 이미지 이름) — VARCHAR(100) — NOT NULL
popup_hash_tag (해시태그 중간 테이블)
- popup_id (팝업 id) — BIGINT — Foreign key → popup.popup_id — NOT NULL
- hash_tag_id (해시태그 번호) — BIGINT — Foreign key → hash_tag.hash_tag_id — NOT NULL
review (리뷰 글)
- review_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user.id — NOT NULL
- title (리뷰 제목) — VARCHAR(100) — NOT NULL
- content (리뷰 내용) — TEXT — NOT NULL
- created_date (작성일) — DATETIME — NOT NULL
reviewcomment (리뷰 댓글)
- review_comment_id (댓글 id) — BIGINT — Primary key — NOT NULL
- review_id (리뷰글번호) — BIGINT — Foreign key → review.review_id — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user.id — NOT NULL
- conetnt (댓글 내용) — TEXT — NOT NULL
- created_date (작성일) — DATETIME — NOT NULL
reviewimage (리뷰 이미지)
- review_iamge_id (이미지번호) — BIGINT — Primary key — NOT NULL
- review_id (리뷰 글번호) — BIGINT — Foreign key → review.review_id — NOT NULL
- image_file_name (저장된 이미지 이름) — VARCHAR(100) — NOT NULL
user (회원)
- id (회원번호) — BIGINT — Primary key — NOT NULL
- user_nikname (닉네임) — VARCHAR(20) — NOT NULL
- user_id (회원 아이디) — VARCHAR(20) — NOT NULL
- name (회원 이름) — VARCHAR(30) — NOT NULL
- pwd (비밀번호) — VARCHAR(20)
- email (이메일) — VARCHAR(20)
- reg_date (가입일자) — DATETIME — NOT NULL
- bussiness_num (사업자번호) — VARCHAR(10)
- role (회원 권한) — ENUM('일반회원','사업자','관리자') — NOT NULL
- status (회원상태) — enum('활성','비활성')