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)