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)