Schema for apartments

CREATE TABLE apartments (
    name TEXT PRIMARY KEY,
    price INTEGER,
    area REAL,
    floor_num INTEGER,
    floor_total INTEGER,
    is_top INTEGER,
    direction TEXT,
    metro TEXT,
    metro_dist INTEGER,
    lat REAL,
    lng REAL,
    dist_sjtu REAL,
    food INTEGER,
    shop INTEGER,
    cafe INTEGER,
    mall INTEGER,
    human_score REAL,
    geo_ok INTEGER,
    has_dry_wet INTEGER,
    htype TEXT,
    tags TEXT,
    feat_tags TEXT,
    scraped INTEGER
, bath_area REAL, elevator TEXT, water TEXT, elec TEXT, heat TEXT, first_rent TEXT, furniture_n INTEGER, appliance_n INTEGER, xinshe_ver TEXT, sign_type TEXT, room_sizes TEXT, complex_info TEXT, furniture_list TEXT, appliance_list TEXT, drive_min INTEGER, station_lat REAL, station_lng REAL, geo_note TEXT, raw_text TEXT, raw_tree TEXT, ingested INTEGER DEFAULT 0, pay_modes TEXT, min_lease TEXT, verify_code TEXT, view_count INTEGER, rating REAL, checkin_date TEXT, room_breakdown TEXT, park INTEGER, gym INTEGER, env_score REAL, biz INTEGER, bar INTEGER, convenience INTEGER, cinema INTEGER, bookstore INTEGER, hospital INTEGER, pharmacy INTEGER, bank INTEGER, library INTEGER, drive_xuhui_m INTEGER, drive_xuhui_s INTEGER, drive_minhang_m INTEGER, drive_minhang_s INTEGER);
CREATE VIEW 房源总览 AS
SELECT 
  name AS '小区',
  price AS '月租',
  area AS '面积',
  htype AS '户型',
  floor_num || '/' || floor_total AS '楼层',
  CASE is_top WHEN 1 THEN '✓' ELSE '' END AS '顶楼',
  CASE has_dry_wet WHEN 1 THEN '✓' ELSE '' END AS '干湿分离',
  direction AS '朝向',
  xinshe_ver AS '心舍版本',
  elevator AS '电梯',
  water AS '用水',
  elec AS '用电',
  heat AS '采暖',
  metro AS '地铁',
  ROUND(human_score, 1) AS '人味儿',
  ROUND(dist_sjtu, 1) AS '距交大km',
  pay_modes AS '付款方式',
  rating AS '评分',
  checkin_date AS '可入住',
  room_breakdown AS '房间面积',
  tags AS '标签',
  lat AS '纬度',
  lng AS '经度',
  ingested AS '已采集'
FROM apartments
ORDER BY human_score DESC NULLS LAST