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