sharoo

Tables (5)

house (집)

  • id (아이디) — int — Primary key — NOT NULL
  • user_id (유저아이디) — int — Foreign key → user.id — NOT NULL
  • start_date (시작날짜) — date
  • end_date (끝날짜) — date
  • room_count (방 개수) — int
  • toilet_count (화장실 개수) — int
  • address (주소) — string
  • point (좌표) — point
  • deposit (보증금) — int
  • monthly_rent (월세) — int
  • max_people (정원) — int
  • sex (성별) — char
  • description (설명) — string
  • kind (주택유형) — char
  • area (m^2) — int
  • title (주택이름) — string
  • ended (마감여부) — boolean

image (집 이미지)

  • id (아이디) — int — Primary key — NOT NULL
  • image (이미지) — string
  • house_id (하우스 아이디) — int — Foreign key → house.id — NOT NULL

interest (관심항목)

  • id (아이디) — int — Primary key — NOT NULL
  • user_id (유저아이디) — int — Foreign key → user.id — NOT NULL
  • house_id (하우스 아이디) — int — Foreign key → house.id — NOT NULL

review (후기)

  • id (아이디) — id — Primary key — NOT NULL
  • writer_id (글쓴사람 아이디) — int — Foreign key → user.id — NOT NULL
  • house_id (하우스 아이디) — int — Foreign key → house.id — NOT NULL
  • score (별점) — int
  • description (설명) — string
  • target_id (타겟 아이디) — int — Foreign key → user.id — NOT NULL

user (유저)

  • id (아이디) — int — Primary key — NOT NULL
  • name (이름) — string
  • introduction (소개) — string
  • profile_image (프로필이미지) — string
  • email (이메일) — string
  • password (비밀번호) — string
  • sex (성별) — char
  • phone_number (전화번호) — string
  • provider (OAuth제공자) — string
  • provider_key (OAuth제공자키) — string
  • salt (솔트) — string
  • birthday (생일) — Date