ssafyhome
Tables (10)
crime_categories
- crime_ctg_no — INT — Primary key — NOT NULL — Auto Incremental, 범죄종류번호
- ctg_name (Field) — VARCHAR(10) — 범죄명
crimes
- crime_no — INT — Primary key — NOT NULL — Auto Incremental, 범죄번호
- dong_code — VARCHAR(10) — Foreign key → dongcodes.dong_code — NOT NULL — 시구군코드
- crime_ctg_no — INT — Foreign key → crime_categories.crime_ctg_no — NOT NULL — 범죄종류번호
- year — INT — 년도
- count — INT — 범죄건수
dongcodes
- dong_code — VARCHAR(10) — Primary key — NOT NULL
- sido_name — VARCHAR(30)
- gugun_name — VARCHAR(30)
- dong_name — VARCHAR(30)
facilities
- facilities_no — INT — Primary key — NOT NULL — Auto Incremental
- dong_code — VARCHAR(10) — Foreign key → dongcodes.dong_code — NOT NULL — 시구군코드
- facility_ctg_no — INT — Foreign key → facility_categories.facility_ctg_no — NOT NULL — 카테고리
- name — VARCHAR(30) — 시설명
- address — VARCHAR(50) — 주소
- latitude — VARCHAR(45) — 위도
- longitude — VARCHAR(45) — 경도
facility_categories
- facility_ctg_no — INT — Primary key — NOT NULL — Auto Incremental
- ctg_name — VARCHAR(10) — 카테고리명
favorite_facilities
- favorite_facilities_no — INT — Primary key — NOT NULL — Auto Incremental
- facilities_no — INT — Foreign key → facilities.facilities_no — NOT NULL
- members_no — INT — Foreign key → members.members_no — NOT NULL
favorite_housedeals
- favorite_housedeals_no — INT — Primary key — NOT NULL — Auto Incremental
- no — INT — Foreign key → housedeals.no — NOT NULL
- members_no — INT — Foreign key → members.members_no — NOT NULL
housedeals
- no — INT — Primary key — NOT NULL — Auto Incremental
- apt_seq — VARCHAR(20) — Foreign key → houseinfos.apt_seq — NOT NULL
- apt_dong — VARCHAR(40)
- floor — VARCHAR(3)
- deal_year — INT
- deal_month — INT
- deal_day — INT
- exclu_use_ar — DECIMAL(7, 2)
- deal_amount — VARCHAR(10)
houseinfos
- apt_seq — VARCHAR(20) — Primary key — NOT NULL
- sgg_cd — VARCHAR(5)
- umd_cd — VARCHAR(5)
- umd_nm — VARCHAR(20)
- jibun — VARCHAR(10)
- road_nm_sgg_cd — VARCHAR(5)
- road_nm — VARCHAR(20)
- road_nm_bonbun — VARCHAR(10)
- road_nm_bubun — VARCHAR(10)
- apt_nm — VARCHAR(40)
- build_year — INT
- latitude — VARCHAR(45)
- longitude — VARCHAR(45)
members
- members_no — INT — Primary key — NOT NULL — Auto Incremental
- id — VARCHAR(20)
- password — VARCHAR(20)
- name — VARCHAR(45)
- email — VARCHAR(50)
- role — VARCHAR(10) — admin, user, estate 등