MyApart

Tables (5)

apt

  • id — NOT NULL — Primary key — NOT NULL
  • apt_name
  • first_division
  • second_division
  • third_division
  • apt_code

notification_info

  • apt_id — NOT NULL — Foreign key → apt.id — NOT NULL
  • alarm_price (alaram_price)
  • pyung
  • id (id2) — NOT NULL — Foreign key → user.id — NOT NULL

rent_price

  • id — NOT NULL — Primary key — NOT NULL
  • year
  • month
  • day
  • price
  • price_per_area
  • apt_id — NOT NULL — Foreign key → apt.id — NOT NULL

sale_price

  • id — NOT NULL — Primary key — NOT NULL
  • year
  • month
  • day
  • price
  • price_per_area
  • apt_id — NOT NULL — Foreign key → apt.id — NOT NULL

user

  • id — NOT NULL — Primary key — NOT NULL
  • Field