PlanerGram
Tables (19)
ATTRACTION (관광지)
- attraction_id (관광지 식별자) — BIGINT — Primary key
- name (이름) — VARCHAR
- address (주소) — VARCHAR
- description (소개글) — VARCHAR
- price (입장료) — INT
- likeCount (좋아요 숫자) — INT
BOARD (게시판)
- board_id (게시판 식별자) — BIGINT — Primary key
- board_name (이름) — VARCHAR
PLATFORM (기차 OPEN API 역코드 변환)
- platform_id (플랫폼 식별자) — BIGINT — Primary key
- city_Code (도시코드) — VARCHAR
- city_Name (도시이름) — VARCHAR
- nodeId (기차역 코드) — VARCHAR
- nodeName (기차역 이름) — VARCHAR
POST (게시글)
- post_id (게시글 식별자) — BIGINT — Primary key
- user_id (유저 식별자) — BIGINT — Foreign key → USER.user_id
- board_id (게시판 식별자2) — BIGINT — Foreign key → BOARD.board_id
- title (제목) — VARCHAR
- contents (본문) — VARCHAR
- like_count (좋아요 숫자) — INT
- read_count (조회수) — INT
- boardName (게시판 이름(DTO)) — VARCHAR
- nickname (작성자 닉네임(DTO)) — VARCHAR
POST_ATTRACTION (참고된 관광지)
- post_attraction_id (참고된 관광지 식별자) — BIGINT — Primary key
- attraction_id (관광지 식별자) — BIGINT — Foreign key → ATTRACTION.attraction_id
- post_id (게시글 식별자) — BIGINT — Foreign key → POST.post_id
- name(DTO) (이름) — VARCHAR
- address(DTO) (주소) — VARCHAR
- description(DTO) (소개글) — VARCHAR
- price(DTO) (입장료) — INT
- likeCount(DTO) (좋아요 숫자) — INT
POST_LIKE (유저가 좋아요 누른 게시글)
- post_like_id (유저가 좋아요 누른 게시글 식별자) — BIGINT — Primary key — NOT NULL
- post_id (게시글 식별자2) — BIGINT — Foreign key → POST.post_id
- user_id (유저 식별자) — BIGINT — Foreign key → USER.user_id
POST_RENTCAR (참고된 렌트카)
- post_rentcar_id (참고된 렌트카 식별자) — BIGINT — Primary key — NOT NULL
- rentcar_id (렌트카 식별자2) — BIGINT — Foreign key → RENTCAR.rentcar_id
- post_id (게시글 식별자) — BIGINT — Foreign key → POST.post_id
- address(DTO) (업체주소) — VARCHAR
- companyName(DTO) (업체이름) — VARCHAR
- carSort(DTO) (차량종류) — VARCHAR
- carName(DTO) (차량이름) — VARCHAR
- likeCount(DTO) (좋아요 숫자) — INT
POST_STAY (참고된 숙소)
- post_stay_id (참고된 숙소 식별자) — BIGINT — Primary key — NOT NULL
- stay_id (숙소 식별자) — BIGINT — Foreign key → STAY.stay_id
- post_id (게시글 식별자) — BIGINT — Foreign key → POST.post_id
- name(DTO) (이름) — VARCHAR
- address(DTO) (주소) — VARCHAR
- price(DTO) (1박당 가격) — INT
- checkIn(DTO) (체크인 시간) — DATATIME
- checkOut(DTO) (체크아웃 시간) — DATATIME
- likeCount(DTO) (좋아요 숫자) — INT
POST_TRAIN (참고된 기차)
- post_train_id (참고된 기차 식별자) — BIGINT — Primary key — NOT NULL
- post_id (게시글 식별자) — BIGINT — Foreign key → POST.post_id
- depplacename (출발역) — VARCHAR
- arrplacename (도착역) — VARCHAR
- depplandtime (출발시간) — VARCHAR
- arrplandtime (도착시간) — VARCHAR
- adultcharge (요금) — INT
- trainno (기차번호) — INT
RENTCAR (렌트카)
- rentcar_id (렌트카 식별자) — BIGINT — Primary key
- address (업체주소) — VARCHAR
- companyName (업체이름) — VARCHAR
- carSort (차량종류) — VARCHAR
- carName (차량이름) — VARCHAR
- likeCount (좋아요 숫자) — INT
REPLY (댓글)
- reply_id (댓글 식별자) — BIGINT — Primary key
- post_id (게시글 식별자) — BIGINT — Foreign key → POST.post_id
- user_id (유저 식별자) — BIGINT — Foreign key → USER.user_id
- contents (내용) — VARCHAR
- nickName(DTO) (작성자 닉네임) — VARCHAR
RentCar_Like (유저가 좋아요 누른 렌트카)
- rentCar_like_id (유저가 좋아요 누른 렌트카 식별자) — BIGINT — Primary key — NOT NULL
- rentcar_id (렌트카 식별자) — BIGINT — Foreign key → RENTCAR.rentcar_id
- user_id (유저 식별자) — BIGINT — Foreign key → USER.user_id
STAY (숙소)
- stay_id (숙소 식별자) — BIGINT — Primary key
- name (이름) — VARCHAR
- address (주소) — VARCHAR
- price (1박당 가격) — INT
- checkIn (체크인 시간) — DATATIME
- checkOut (체크아웃 시간) — DATATIME
- likeCount (좋아요 숫자) — INT
USER (회원)
- user_id (유저 식별자) — BIGINT — Primary key
- username (로그인 아이디) — VARCHAR
- password (패스워드) — VARCHAR
- nickname (닉네임) — VARCHAR
- roles (SECURITY 권한) — VARCHAR
Untitled
- Field
User_Info (유저상세정보)
- user_info_id (유저 상세정보 식별자) — BIGINT — Primary key
- user_id (유저 식별자) — BIGINT — Foreign key → USER.user_id
- profileImg (프로필 사진URL) — VARCHAR
- email (이메일) — VARCHAR
attraction_Like (유저가 좋아요 누른 관광지)
- attraction_like_id (유저가 좋아요 누른 관광지 식별자) — BIGINT — Primary key — NOT NULL
- user_id (유저 식별자) — BIGINT — Foreign key → USER.user_id
- attraction_id (관광지 식별자2) — BIGINT — Foreign key → ATTRACTION.attraction_id
stay_like (유저가 좋아요 누른 숙소)
- stay_like_id (유저가 좋아요 누른 숙소 식별자) — BIGINT — Primary key — NOT NULL
- stay_id (숙소 식별자2) — BIGINT — Foreign key → STAY.stay_id
- user_id (유저 식별자) — BIGINT — Foreign key → USER.user_id
train_like (유저가 좋아요 누른 기차)
- train_like_id (유저가 좋아요 누른 기차 식별자) — BIGINT — Primary key — NOT NULL
- user_id (유저 식별자) — BIGINT — Foreign key → USER.user_id
- depplacename (출발역) — VARCHAR
- arrplacename (도착역) — VARCHAR
- depplandtime (출발시간) — VARCHAR
- arrplandtime (도착시간) — VARCHAR
- adultcharge (요금) — INT
- trainno (기차번호) — INT