Res_db_dong_count

Tables (5)

ACCOUNTS_MYUSER

  • ID — VARCHAR2(100 CHAR) — Primary key — NOT NULL
  • USERNAME — VARCHAR(255)
  • PASSWORD — VARCHAR(255)
  • GENDER — VARCHAR(255)
  • AGE — VARCHAR(255)

CATE_WEIGHTS

  • IDX — INT — Primary key
  • USERNAME — VARCHAR2(150 CHAR) — Foreign key → ACCOUNTS_MYUSER.ID — NOT NULL
  • CAR_SHR_NUM — INT
  • ANI_HSPT_NUM — INT
  • LEISURE_NUM — INT
  • GYM_NUM — INT
  • GOLF_NUM — INT
  • STARBUCKS_NUM — INT
  • MC_NUM — INT
  • VEGAN_CNT — INT
  • SAFE_DLVR_NUM — INT
  • KIDS_NUM — INT
  • NOISE_VIBRATION_NUM — INT
  • PARK_NUM — INT
  • COLIVING_NUM — INT
  • MZ_POP_CNT — INT
  • TRANSPORTATION — INT
  • EDUCATION — INT
  • PARENTING — INT
  • SAFETY — INT
  • MEDICAL — INT
  • FACILITIES — INT

DONG_CNT

  • DONG_CODE — INT — Primary key
  • DONG — VARCHAR2(30 CHAR)
  • GU — VARCHAR2(30 CHAR)
  • CAR_SHR_NUM — FLOAT
  • ANI_HSPT_NUM — FLOAT
  • LEISURE_NUM — FLOAT
  • GYM_NUM — FLOAT
  • GOLF_NUM — FLOAT
  • STARBUCKS_NUM — FLOAT
  • MC_NUM — FLOAT
  • VEGAN_CNT — FLOAT
  • SAFE_DLVR_NUM — FLOAT
  • KIDS_NUM — FLOAT
  • NOISE_VIBRATION_NUM — FLOAT
  • PARK_NUM — FLOAT
  • COLIVING_NUM — FLOAT
  • MZ_POP_CNT — FLOAT
  • TRANSPORTATION — FLOAT
  • EDUCATION — FLOAT
  • PARENTING — FLOAT
  • SAFETY — FLOAT
  • MEDICAL — FLOAT
  • FACILITIES — FLOAT
  • STD_DAY — VARCHAR2(30 CHAR)

DONG_COORD

  • DONG_CODE — INT — Primary key — NOT NULL
  • SI_DO — VARCHAR2(26 CHAR)
  • GU — VARCHAR2(26 CHAR)
  • DONG — VARCHAR2(26 CHAR)
  • LAT — FLOAT
  • LON — FLOAT

INFRA_ADMIN

  • IDX — INT — Primary key — NOT NULL
  • NAME — VARCHAR2(100 CHAR)
  • CATE — VARCHAR2(30 CHAR)
  • DONG_CODE — INT
  • GU — VARCHAR2(26 CHAR)
  • DONG — VARCHAR2(26 CHAR)
  • LAT — FLOAT
  • LON — FLOAT
  • STD_DAY — VARCHAR2(10 CHAR)