zipzip
Tables (13)
apartment
- id — bigint — Primary key — NOT NULL
- name — varchar(255)
- addr — varchar(255)
- build_year — int
- latitude — varchar(255)
- longitude — varchar(255)
- apt_seq — varchar(255)
- dong_name — varchar(255)
- sgg_cd — varchar(20)
- umd_cd — varchar(20)
- road_nm_sgg_cd — varchar(20)
- dong_code — varchar(20)
apartment_like
- id — bigint — Primary key — NOT NULL
- member_id — bigint — NOT NULL
- apt_id — varchar(100) — NOT NULL
chat
- id — bigint — Primary key — NOT NULL
- chatroom_id — bigint — NOT NULL
- sender_type — varchar(50) — NOT NULL
- message — text — NOT NULL
- timestamp — datetime — NOT NULL
chatroom
- id — bigint — Primary key — NOT NULL
- member_id — bigint — NOT NULL
community
- id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- like_cnt — int
- member_id — bigint — NOT NULL
- apt_id — varchar(64)
- post_date — datetime
- update_date — datetime
community_like
- id — bigint — Primary key — NOT NULL
- member_id — bigint — NOT NULL
- community_id — bigint — NOT NULL
dong
- id — int — Primary key — NOT NULL
- dong_code — char(10) — NOT NULL
- dong_name — varchar(50) — NOT NULL
- gungu_id — int — NOT NULL
gungu
- id — int — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- sido_id — int — NOT NULL
housedeals
- id — bigint — Primary key — NOT NULL
- apt_seq — varchar(20) — 아파트코드
- 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) — 거래가격
member
- id — bigint — Primary key — NOT NULL
- name — varchar(255)
- email — varchar(100) — NOT NULL
- password — varchar(255) — NOT NULL
- role — varchar(20)
- image — varchar(255)
- isSocial — tinyint(1)
- kakao_id — varchar(255)
- apt_id — varchar(50)
- refresh_token — varchar(512)
notice
- id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — text — NOT NULL
- member_id — bigint — NOT NULL
- post_date — datetime — NOT NULL
- update_date — datetime
- view_count — int
registry_stats
- id — bigint — Primary key — NOT NULL
- rgs_ym — varchar(7) — NOT NULL
- rgsPurpsNm — varchar(50) — NOT NULL
- sgg_nm — varchar(50)
- rgs_cnt — int
sido
- id — int — Primary key — NOT NULL
- name — varchar(20) — NOT NULL