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

point_tbl (Untitled)

    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('활성','비활성')