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