akiya
Tables (6)
Favorites (Untitled2)
- Favorites_id — number — Primary key — NOT NULL
- member_id (member_id2) — varchar2(50) — Foreign key → member.member_id — NOT NULL
- house_id — varchar2(20) — Foreign key → house.house_id — NOT NULL
attached_file
- attached_id — number — Primary key — NOT NULL
- house_id (house_id2) — varchar2(20) — Foreign key → house.house_id — NOT NULL
- filename — varchar2(2000)
condition (Untitled5)
- condition_id — number — Primary key — NOT NULL
- member_id (member_id2) — varchar2(50) — Foreign key → member.member_id — NOT NULL
- bus — varchar2(20)
- subway — varchar2(20)
- convini — varchar2(20)
- hospital — varchar2(20)
- aircon — varchar2(20)
- bathroom — varchar2(20)
- parking — varchar2(20)
- washer — varchar2(20)
- pet — varchar2(20)
- autolock — varchar2(20)
- housesize_max — number
- housesize_min — number
- price_max — number
- price_min — number
house (Untitled3)
- house_id — varchar2(20) — Primary key — NOT NULL
- city — varchar2(20)
- address — varhcar2(100)
- price — number
- completed — varchar2(20)
- structure — varchar2(20)
- floor — number
- housesize — number
- longitude — FLOAT
- latitude — FLOAT
- bus — varchar2(20)
- subway — varchar2(20)
- convini — varchar2(20)
- hospital — varchar2(20)
- aircon — varchar2(20)
- bathroom — varchar2(20)
- parking — varchar2(20)
- washer — varchar2(20)
- pet — varchar2(20)
- autolock — varchar2(20)
member (Untitled)
- member_id — varchar2(50) — Primary key — NOT NULL
- password — varchar2(20)
- email — varchar2(100)
- birth — date
- Revised — varchar2(20)
structure (Untitled7)
- structure_id — number — Primary key — NOT NULL
- structure — varchar2(20)
- condition_id (condition_id2) — number — Foreign key → condition.condition_id — NOT NULL
- member_id (member_id2) — varchar2(50) — Foreign key → condition.member_id — NOT NULL