Bsanpe
Tables (10)
apartment_parks
- apartment_id — BIGINT — Foreign key → apartments.apartment_id
- park_id — BIGINT — Foreign key → parks.park_id — NOT NULL
- created_at — TIMESTAMP
apartment_schools
- apartment_id — BIGINT — Foreign key → apartments.apartment_id
- school_id — BIGINT — Foreign key → elementary_schools.school_id — NOT NULL
- created_at — TIMESTAMP
apartment_stations
- apartment_id — BIGINT — Foreign key → apartments.apartment_id
- station_id — BIGINT — Foreign key → stations.station_id — NOT NULL
- created_at — TIMESTAMP
apartments
- apartment_id — BIGINT — Primary key
- name — VARCHAR(255) — NOT NULL
- brand — VARCHAR(100)
- address — VARCHAR(255) — NOT NULL
- gu_code — VARCHAR(10)
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- is_brand — BOOLEAN
- is_station_area — BOOLEAN
- has_elementary — BOOLEAN
- is_large_complex — BOOLEAN
- is_new_building — BOOLEAN
- has_park_nearby — BOOLEAN
- park_distance — INT
- station_distance — INT
- elementary_school_distance — INT
- constructed_at — DATE
- total_household — INT
- avg_rating — DOUBLE
- review_count — INT
- recommendation_score — DOUBLE
- created_at — TIMESTAMP
elementary_schools
- school_id — BIGINT — Primary key — NOT NULL
- school_name — VARCHAR(255) — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- created_at — TIMESTAMP
favorites
- user_id — VARCHAR(50) — Foreign key → users.id — NOT NULL
- apartment_id — BIGINT — Foreign key → apartments.apartment_id
- favorite_id — BIGINT
- created_at — TIMESTAMP
parks
- park_id — BIGINT — Primary key — NOT NULL
- park_name — VARCHAR(255) — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- created_at — TIMESTAMP
reviews
- review_id — BIGINT — Primary key — NOT NULL
- apartment_id — BIGINT — Foreign key → apartments.apartment_id
- user_id — VARCHAR(50) — Foreign key → users.id — NOT NULL
- rating — DECIMAL(3, 2) — NOT NULL
- comment — TEXT — EX
- created_at — TIMESTAMP
stations
- station_id — BIGINT — Primary key — NOT NULL
- station_name — VARCHAR(255) — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- created_at — TIMESTAMP
users
- id — VARCHAR(50) — Primary key — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP