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