fortress

Tables (4)

address

  • 주소아이디 (address_id) — INT — Primary key — NOT NULL
  • 집아이디 (house_id) — INT — Foreign key → house.집아이디 — NOT NULL
  • 주소 (address) — VARCHAR(200)

house

  • 집아이디 (house_id) — INT — Primary key — NOT NULL
  • 월세금액 (month_price) — INT — NOT NULL
  • 보증금액 (deposit_price) — BIGINT — NOT NULL

report

  • 리포트아이디 (report_id) — INT — Primary key — NOT NULL
  • 유저아이디 (user_id) — INT — Foreign key → user.유저아이디 — NOT NULL
  • 집아이디 (house_id) — INT — Foreign key → house.집아이디 — NOT NULL
  • 보증금유형 (price_type) — INT — NOT NULL
  • 월세금액 (user_month) — INT — NOT NULL
  • 보증금액 (user_deposit) — BIGINT — NOT NULL
  • 등급 (rate) — INT — NOT NULL

user

  • 유저아이디 (user_id) — INT — Primary key — NOT NULL
  • 구글이메일 (gmail) — VARCHAR(70)