DB_project1

Tables (5)

agent (Untitled)

  • ID — Primary key — NOT NULL
  • 거래정보 (transaction)
  • 이름 (name)
  • phone_num (Field3)
  • 소속 중개사무소 (company)
  • 자기소개 (readme)

company (Untitled2)

  • ID — Primary key — NOT NULL
  • 중개사무소명 (name)
  • 대표 (president)
  • 대표번호 (representative_num)
  • 소재지 (location)
  • 등록번호 (registration_num)

property (Untitled3)

  • 가격 (price)
  • 유형 (p_type)
  • 학군 (school_district)
  • 입주시기 (move_in_date)
  • 세대 (household)
  • 평수 (pyeong)
  • 위치 (location)

transaction (Untitled5)

  • 거래시기 (date)
  • 거래유형 (t__type)
  • 거래가격 (Field3)

type (Untitled4)

  • Field (studio)
  • Field2 (one-bedroom)
  • Field3 (multi-bedroom)
  • Field4 (detached)