Greeney

Tables (19)

board_category (게시판 카테고리)

  • board_category_id (Key) — int — Primary key — NOT NULL — unique
  • board_id (게시글 아이디) — int — Foreign key → board_table.board_id — NOT NULL — unique
  • board_category_name (카테고리 이름)

board_comment_table (게시판 댓글)

  • board_comment_id (댓글 id) — Primary key — NOT NULL
  • board_id (게시글 id) — Foreign key → board_table.board_id — NOT NULL
  • user_id (유저 id) — Foreign key → user_table.user_id — NOT NULL
  • board_comment_content (댓글 내용)
  • board_comment_time (댓글 작성 시간)

board_table (게시글)

  • board_id (게시글 id) — int — Primary key — NOT NULL — unique
  • board_title (게시글 제목)
  • board_content (게시글 내용)
  • board_picture (게시글 사진)
  • user_id (게시글 저자) — int — Foreign key → user_table.user_id — NOT NULL
  • board_time (작성 시간)
  • board_like (좋아요 수)
  • board_comment (댓글 수)

challenge_table (도전과제)

  • challenge_id (Key) — int(10) — Primary key — NOT NULL — unique
  • challenge_name (도전과제명) — varchar — NOT NULL — unique

hotel_comment_table (숙소 리뷰)

  • hotel_comment (Key3) — Primary key — NOT NULL
  • hotel_id (Key) — int — Foreign key → hotel_table.hotel_id — NOT NULL — unique
  • user_id (Key2) — int(10) — Foreign key → user_table.user_id — NOT NULL — unique
  • hotel_comment_content (내용)
  • Field (사진)
  • Field2 (작성시간)
  • Field (평점)

hotel_like_table (호텔 찜)

  • hotel_id (호텔 아이디) — int — Foreign key → hotel_table.hotel_id — NOT NULL — unique
  • user_id (사용자 아이디) — int(10) — Foreign key → user_table.user_id — NOT NULL — unique

hotel_table (숙소)

  • hotel_id (Key) — int — Primary key — NOT NULL — unique
  • hotel_name (숙소명) — varchar
  • hotel_addr (주소) — varchar
  • hotel_tel (전화번호) — varchar
  • hotel_service (숙소서비스 정보) — varchar
  • hotel_info (숙소설명)
  • hotel_la (숙소위도) — varchar
  • hotel_lo (숙소경도) — varchar
  • hotel_star (숙소 평점) — int
  • hotel_image (숙소 사진) — varchar

restaurant_comment_table (식당 리뷰)

  • restaurant_id (식당 아이디) — int — Foreign key → restaurant_table.restaurant_id — NOT NULL — unique
  • user_id (Key) — int(10) — Foreign key → user_table.user_id — NOT NULL — unique

restaurant_like_table (식당 찜)

  • restaurant_id (식당 아이디) — int — Foreign key → restaurant_table.restaurant_id — NOT NULL — unique
  • user_id (Key) — int(10) — Foreign key → user_table.user_id — NOT NULL — unique

restaurant_table (식당)

  • restaurant_id (식당 아이디) — int — Primary key — NOT NULL — unique
  • restaurant_name (식당명) — varchar
  • restaurant_addr (주소) — varchar
  • restaurant_tel (전화번호) — varchar
  • restaurant_menuinfo (메뉴설명) — varchar
  • restaurant_la (식당위도) — varchar
  • restaurant_lo (식당경도) — varchar
  • restaurant_star (식당 평점) — int

rstaurant_image_table (식당사진)

  • rstrnt_image_id (식당사진아이디) — Primary key — NOT NULL
  • restaurant_id (식당 아이디) — int — Foreign key → restaurant_table.restaurant_id — NOT NULL — unique
  • rstrnt_image (식당 사진)

title_table (칭호)

  • title_id (Key) — int(10) — Primary key — NOT NULL — unique
  • title_name (칭호명) — varchar — NOT NULL

tourcourse_like_table (여행코스 찜)

  • user_id (Key) — int(10) — Foreign key → user_table.user_id — NOT NULL — unique
  • tourcourse_id (여행코스 아이디) — int — Foreign key → tourcourse_table.tourcourse_id — NOT NULL

tourcourse_table (여행코스)

  • tourcourse_id (여행코스 아이디) — int — Primary key — NOT NULL
  • tourspot_id (관광지 아이디) — int — Foreign key → tourspot_table.tourspot_id — NOT NULL — unique
  • hotel_id (숙소 아이디) — int — Foreign key → hotel_table.hotel_id — NOT NULL — unique
  • restaurant_id (식당 아이디) — int — Foreign key → restaurant_table.restaurant_id — NOT NULL — unique
  • tourcourse_location (지역명) — varchar
  • tourcourse_name (코스명) — varchar

tourspot_comment_table (관광지 리뷰)

  • tourspot_comment_id (리뷰댓글 아이디) — int — Primary key — NOT NULL — unique
  • tourspot_id (게시글 아이디) — int — Foreign key → tourspot_table.tourspot_id — NOT NULL — unique
  • user_id (작성자) — int — Foreign key → user_table.user_id — NOT NULL — unique
  • tourspot_comment_content (리뷰 내용)
  • tourspot_comment_picture (리뷰 사진)
  • tourspot_comment_time (리뷰 작성 시간)
  • tourspot_comment_star (리뷰 평점)

tourspot_like_table (관광지 찜)

  • tourspot_id (관광지 아이디) — int — Foreign key → tourspot_table.tourspot_id — NOT NULL — unique
  • user_id (사용자 아이디) — int — Foreign key → user_table.user_id — NOT NULL

tourspot_table (관광지)

  • tourspot_id (Key) — int — Primary key — NOT NULL — unique
  • tourspot_name (관광지명) — varchar
  • tourspot_addr (주소) — varchar
  • tourspot_tel (전화번호) — varchar
  • tourspot_site (홈페이지) — varchar
  • tourspot_parking (주차가능여부)
  • tourspot_audio (오디오) — varchar
  • tourspot_summary (설명) — varchar
  • tourspot_star (평점) — int
  • tourspot_short (짧은설명) — varchar
  • tourspot_image (사진) — varchar

tourspot_tag_table (태그)

  • tourspot_tag_id (Key) — int — Primary key — NOT NULL — unique
  • tourspot_id (Key2) — int — Foreign key → tourspot_table.tourspot_id — NOT NULL — unique
  • tag_content (태그 내용) — varchar — NOT NULL

user_table (유저)

  • user_id (Key) — int(10) — Primary key — NOT NULL — unique
  • user_nickname (닉네임) — varchar — NOT NULL — unique
  • user_email (이메일) — varchar — NOT NULL — unique
  • user_password (패스워드) — varchar — NOT NULL
  • user_phonenum (휴대폰 번호) — varchar — NOT NULL — unique
  • user_birthdate (생년월일) — varchar — NOT NULL
  • user_gender (성별) — tinyint — NOT NULL
  • user_title (칭호) — varchar — Foreign key → title_table.title_id
  • challenge_num (달성 도전과제 수) — int(10)
  • user_is_super (슈퍼관리자여부) — tinyint — NOT NULL
  • user_picture (프로필사진) — varchar