The Zip

Tables (9)

amenity_info (편의시설)

  • amenity_id (Key) — Primary key — NOT NULL
  • dormitory_id (Key2) — Foreign key → dormitory.dormitory_id — NOT NULL
  • college_id (Key22) — Foreign key → dormitory.college_id — NOT NULL
  • name (Field)
  • floor (Field2)

charter (Untitled5)

  • charter_id (Key) — Primary key — NOT NULL
  • apt_seq (Key2) — varchar(20) — Foreign key → houseinfos.apt_seq — NOT NULL
  • charter_dong (Field)
  • charter_kind (월세전세)
  • floor (Field2)
  • deal_year (Field3)
  • deal_month (Field4)
  • deal_day (Field5)
  • deposit (보증금)
  • rent (임대료)
  • building_use (건물용도)
  • contract_type (신규계약구분)

college (대학)

  • college_id (Key) — Primary key — NOT NULL
  • MEMBER_ID (Key2) — Foreign key → member.MEMBER_ID — NOT NULL
  • college_dong (Field4)
  • name (Field)
  • latitude (Field2)
  • longitude (Field3)
  • url (Field5) — varchar

dongcodes (Untitled2)

  • dong_code (Key) — varchar(10) — Primary key — NOT NULL
  • sido_name (Field) — varchar(30)
  • gugun_name (Field2) — varchar(30)
  • dong_name (Field3) — varchar(30)
  • MEMBER_ID (Key2) — Foreign key → member.MEMBER_ID — NOT NULL

dormitory (기숙사)

  • dormitory_id (Key) — Primary key — NOT NULL
  • college_id (Key2) — Foreign key → college.college_id — NOT NULL
  • name (Field)
  • room_number (Field2) — varchar
  • room_count (Field3) — int
  • capacity (Field4)
  • deposit (Field5)
  • rent (Field6)
  • dormitory_kind (Field7) — varchar
  • Field8

dormitory_image (Untitled6)

  • dormitory_image_id (Key) — Primary key — NOT NULL
  • dormitory_id (Key2) — Foreign key → dormitory.dormitory_id — NOT NULL
  • college_id (Key22) — Foreign key → dormitory.college_id — NOT NULL
  • image_url (Field)

housedeals (Untitled3)

  • no (Key) — Primary key — NOT NULL
  • apt_seq (Key3) — varchar(20) — Foreign key → houseinfos.apt_seq — NOT NULL
  • apt_dong (Key2) — varchar(10) — Foreign key → dongcodes.dong_code — NOT NULL
  • floor (Field3)
  • deal_year (Field4)
  • deal_month (Field5)
  • deal_day (Field6)
  • exclu_use_ar (Field7) — decimal(7,2)
  • deal_amount (Field8) — varchar(10)
  • MEMBER_ID (Key4) — Foreign key → member.MEMBER_ID — NOT NULL

houseinfos (Untitled4)

  • apt_seq (Key) — varchar(20) — Primary key — NOT NULL
  • sgg_cd (Field) — varchar(5)
  • umd_cd (Field2) — varchar(5)
  • umd_nm (Field3) — varchar(20)
  • jibun (Field4) — varchar(10)
  • road_nm_sgg_cd (Field5) — varchar(5)
  • road_nm (Field6) — varchar(20)
  • road_nm_bonbun (Field7) — varchar(10)
  • road_nm_bubun (Field8) — varchar(10)
  • apt_nm (Field9) — varchar(40)
  • build_year (Field10) — int
  • latitude (Field11) — varchar(45)
  • longitude (Field12) — varchar(45)
  • Field13

member (Untitled)

  • MEMBER_ID (Key) — Primary key — NOT NULL
  • Field
  • ROLE (Field2)
  • CREATED_AT (Field3)
  • UPDATED_AT (Field4)
  • DELETED_AT (Field5)