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