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)