exchangers

Tables (9)

apply_place (장소 신청)

  • apply_palce_id (id) — BIGINT — Primary key — NOT NULL
  • ko_name (한글 이름) — VARCHAR
  • en_name (영어 발음 이름) — VARCHAR
  • ko_address (한글 주소) — VARCHAR
  • en_address (영어 발음 주소) — VARCHAR
  • kiosk_available (키오스크 유무) — TINYINT(1)
  • parking_available (주차 유무) — TINYINT(1)
  • english_speaking (영어 가능 여부) — TINYINT(1)
  • restroom_avilable (화장실 유무) — TINYINT(1)
  • description (설명) — VARCHAR
  • category (카테고리) — VARCHAR
  • image (사진) — VARCHAR
  • latitude (위도) — DOUBLE
  • longitude (경도) — DOUBLE
  • accepted (수락 여부) — TINYINT(1)
  • date (날짜) — DATE
  • user_id (id2) — BIGINT — Foreign key → user.user_id — NOT NULL

board (자유게시판)

  • board_id (id) — BIGINT — Primary key — NOT NULL
  • title (제목) — VARCHAR
  • content (내용) — TEXT
  • image (사진) — VARCHAR
  • date (날짜) — DATE
  • like (좋아요) — INT
  • user_id (id2) — BIGINT — Foreign key → user.user_id — NOT NULL

comment (댓글)

  • comment_id (id) — BIGINT — Primary key — NOT NULL
  • content (내용) — VARCHAR
  • like (좋아요) — INT
  • date (날짜) — DATE
  • user_id (id2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • board_id (id3) — BIGINT — Foreign key → board.board_id — NOT NULL
  • comment_id (id4) — BIGINT — Foreign key → comment.comment_id — NOT NULL

keyword (키워드)

  • keyword_id (id) — BIGINT — Primary key — NOT NULL
  • content (키워드 메세지) — VARCHAR
  • category (카테고리) — VARCHAR

place (장소)

  • palce_id (id) — BIGINT — Primary key — NOT NULL
  • ko_name (한글 이름) — VARCHAR
  • en_name (영어 발음 이름) — VARCHAR
  • ko_address (한글 주소) — VARCHAR
  • en_address (영어 발음 주소) — VARCHAR
  • kiosk_available (키오스크 유무) — TINYINT(1)
  • parking_available (주차 유무) — TINYINT(1)
  • english_speaking (영어 가능 여부) — TINYINT(1)
  • restroom_avilable (화장실 유무) — TINYINT(1)
  • description (설명) — VARCHAR
  • category (카테고리) — VARCHAR
  • image (사진) — VARCHAR
  • latitude (위도) — DOUBLE
  • longitude (경도) — DOUBLE

review (후기)

  • review_id (id) — BIGINT — Primary key — NOT NULL
  • rating (별점) — FLOAT
  • content (후기 내용) — TEXT
  • user_id (id2) — BIGINT — Foreign key → user.user_id — NOT NULL
  • palce_id (id3) — BIGINT — Foreign key → place.palce_id — NOT NULL
  • date (날짜) — DATE

review_images (리뷰 사진)

  • review_image_id (Key) — BIGINT — Primary key — NOT NULL
  • image (후기 이미지) — VARCHAR
  • review_id (id) — BIGINT — Foreign key → review.review_id — NOT NULL

review_keywords (리뷰 키워드)

  • review_keyword_id (id) — BIGINT — Primary key — NOT NULL
  • keyword_id (id2) — BIGINT — Foreign key → keyword.keyword_id — NOT NULL
  • review_id (id3) — BIGINT — Foreign key → review.review_id — NOT NULL

user (유저)

  • user_id (id) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VACHAR
  • password (비밀번호) — VARCHAR
  • nick_name (이름) — VARCHAR
  • profile_image (사용자 이미지) — VARCHAR(255)