popup_day
Tables (20)
faq_tbl (자주묻는질문)
- faq_id (faq 아이디) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
- title (faq 제목) — VARCHAR(100) — NOT NULL
- content (faq 내용) — TEXT — NOT NULL
- created_at (작성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
hash_tag_tbl (해시태그)
- hash_tag_id (해시태그 번호) — BIGINT — Primary key — NOT NULL
- hash_tag (해시태그) — VARCHAR(100)
hits_tbl (조회수)
- hits_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
- popup_id (팝업 id) — BIGINT — Foreign key → popup_tbl.popup_id — NOT NULL
- viewed_at (조회수 시간) — DATETIME
my_gifticon_tbl (기프티콘)
- gifticon_id (기프티콘번호) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
- shop_id (포인트샵 글번호) — BIGINT — Foreign key → point_shop_tbl.shop_id — NOT NULL
- image_file_name (기프티콘 이미지) — VARCHAR(100)
notice_image_tbl (공지사항 이미지)
- notice_iamge_id (이미지번호) — BIGINT — Primary key — NOT NULL
- notice_id (Key) — BIGINT — Foreign key → notice_tbl.notice_id — NOT NULL
- image_file_name (저장된 이미지 이름) — VARCHAR(100) — NOT NULL
notice_tbl (공지사항)
- notice_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
- title (공지사항 제목) — VARCHAR(100) — NOT NULL
- content (공지사항 내용) — TEXT — NOT NULL
- created_at (작성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
point_history_tbl (포인트적립내역)
- history_id (내역 번호) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
- change_amount (포인트 증감) — BIGINT
- point_type (포인트 적립타입) — ENUM('회원가입','리뷰','댓글')
- previous_point (증감 전 포인트) — BIGINT
- new_point (증감 후 포인트) — BIGINT
- point_date (적립일) — DATETIME
point_shop_tbl (포인트 사용처 등록폼)
- shop_id (포인트샵 글번호) — BIGINT — Primary key — NOT NULL
- product_name (이름) — VARCHAR(100)
- product_price (가격) — BIGINT
- product_count (수량) — BIGINT
- image_file_name (이미지이름) — VARCHAR(100)
- created_at (작성일) — DATETIME
- updated_at (수정일) — DATETIME
- status (상태) — enum('활성','비활성')
pop_like_tbl (찜)
- pop_like_id (Key) — BIGINT — Primary key — NOT NULL
- popup_id (팝업 id) — BIGINT — Foreign key → popup_tbl.popup_id — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
popup_comment_tbl (팝업댓글)
- popup_comment_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
- popup_id (팝업 id) — BIGINT — Foreign key → popup_tbl.popup_id — NOT NULL
- conetnt (댓글) — TEXT
- created_at (댓글 작성일) — DATETIME
- updated_at (댓글 수정일) — DATETIME
popup_hash_tag_tbl (해시태그 중간 테이블)
- popup_id (팝업 id) — BIGINT — Foreign key → popup_tbl.popup_id — NOT NULL
- hash_tag_id (해시태그 번호) — BIGINT — Foreign key → hash_tag_tbl.hash_tag_id — NOT NULL
popup_image_tbl (팝업이미지)
- popup_image_id (이미지번호) — BIGINT — Primary key — NOT NULL
- popup_id (팝업 id) — BIGINT — Foreign key → popup_tbl.popup_id — NOT NULL
- image_file_name (저장된 이미지 이름) — VARCHAR(100) — NOT NULL
popup_tbl (팝업등록폼)
- popup_id (팝업 id) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.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 (입장료) — CARCHAR(20)
qna_answer_tbl (qna 답글)
- answer_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
- qna_id (질문 id) — BIGINT — Foreign key → qna_tbl.qna_id — NOT NULL
- answer (답변) — TEXT
- created_at (답변 작성일) — DATETIME
- updated_at (답변 수정일) — DATETIME
qna_tbl (qna)
- qna_id (질문 id) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
- title (제목) — VARCHAR(100) — NOT NULL
- content (내용) — TEXT — NOT NULL
- category_name (카테고리) — VARCHAR(45)
- created_at (작성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
- status (답변상태) — enum('답변중,'답변완료') — NOT NULL
review_comment_tbl (리뷰댓글)
- review_comment_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
- review_id (리뷰 글번호) — BIGINT — Foreign key → review_tbl.review_id — NOT NULL
- conetnt (댓글) — TEXT
- created_at (댓글 작성일) — DATETIME
- updated_at (댓글 수정일) — DATETIME
review_image_tbl (리뷰 이미지)
- review_iamge_id (이미지번호) — BIGINT — Primary key — NOT NULL
- review_id (리뷰 글번호) — BIGINT — Foreign key → review_tbl.review_id — NOT NULL
- image_file_name (저장된 이미지 이름) — VARCHAR(100) — NOT NULL
review_tbl (리뷰 글)
- review_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
- title (리뷰 제목) — VARCHAR(100) — NOT NULL
- content (리뷰 내용) — TEXT — NOT NULL
- created_at (작성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
user_hash_tag_tbl (추천해시태그)
- user_hash_tag_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (회원번호) — BIGINT — Foreign key → user_tbl.id — NOT NULL
- hash_tag_id (해시태그 번호) — BIGINT — Foreign key → hash_tag_tbl.hash_tag_id — NOT NULL
user_tbl (회원)
- 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('active','deleted')
- birth_date (생년월일) — DATETIME
- gender (성별) — VARCHAR(20)
- tot_point (총 포인트) — BIGINT
- profile (프로필) — VARCHAR(100)