gbictBum
Tables (5)
APT (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- 아파트이름 (APT_name) — VARCHAR
- 주소 (locate) — VARCHAR
- x좌표 (position_x) — VARCHAR
- y좌표 (position_y) — VARCHAR
BUILDING (Untitled2)
- id — BIGINT — Primary key — NOT NULL
- 동이름 (building_num) — BIGINT
- 아파트id (apt_id) — BIGINT — Foreign key → APT.id — NOT NULL
- 총 호수 (total_house) — BIGINT
ELECTRIC_DATA (Untitled4)
- 데이터의 날짜 (id) — BIGINT — Primary key — NOT NULL
- 아파트호수 (houseId) — BIGINT — Foreign key → HOUSE.id — NOT NULL
- 전기량 (value) — double
HOUSE (Untitled3)
- id — BIGINT — Primary key — NOT NULL
- 아파트호수 (house_num) — BIGINT
- 비고 (info) — VARCHAR
- 연락처 (contact) — VARCHAR
- 생성일 (create_at) — date
- 수정일 (updated_at) — date
- 아파트동 (building_id) — BIGINT — Foreign key → BUILDING.id — NOT NULL
WATER_DATA (Untitled5)
- 데이터날짜 (id) — BIGINT — Primary key — NOT NULL
- 아파트호수 (houseId) — BIGINT — Foreign key → HOUSE.id — NOT NULL
- 수도량 (value) — double