Residence_Operate_DB
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)