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