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)