미니프로젝트

테이블 (8)

power generation (---)

  • year_ (Key) — int — 기본 키 — NOT NULL
  • seoul (Field) — int
  • busan (Field2) — int
  • daegu (Field3) — int
  • incheon (Field4) — int
  • gwangju (Field5) — int
  • daejeon (Field6) — int
  • ulsan (Field7) — int
  • sejong (Field8) — int
  • gyeonggi (Field9) — int
  • gangwon (Field10) — int
  • chungbuk (Field11) — int
  • chungnam (Field12) — int
  • jeonbuk (Field13) — int
  • jeonnam (Field14) — int
  • gyeongbuk (Field15) — int
  • gyeongnam (Field16) — int
  • jeju (Field17) — int

power_distribution (_)

  • power_A (Key) — float — 기본 키 — NOT NULL
  • pd_B (Field) — float
  • amount_of_loss_A_B (Field2) — float
  • pd_loss_rate (Field3) — float

power_sales (___)

  • ps_C (Key) — float — 기본 키 — NOT NULL
  • pd_B_2 (Field) — float
  • amount_of_loss_B_C (Field2) — float
  • ps_loss_rate (Field3) — float

powers (__)

  • year (Key) — float — 기본 키 — NOT NULL
  • power_A (Key2) — float — 외래 키 → power_distribution.power_A — NOT NULL
  • ps_C (Key3) — float — 외래 키 → power_sales.ps_C — NOT NULL
  • amount_of_total_loss_A_C (Field2) — float
  • total_loss_rate (Field3) — float

배전판매량 (power_sales)

  • 배전손실_판매량C (ps_C) — float — 기본 키 — NOT NULL
  • 송변전손실_배전량B (pd_B_2) — float
  • 손실량_B_C (amount_of_loss_B_C) — float
  • 손실률 (ps_loss_rate) — float

송변전 (power_distribution)

  • 송전단_전력량A (power_A) — float — 기본 키 — NOT NULL
  • 송변전손실_배전량B (pd_B) — float
  • 송변전손실_손실량_A_B (amount_of_loss_A_B) — float
  • 송변전손실_손실률 (pd_loss_rate) — float

전력량 (power)

  • 연도 (year) — int — 기본 키 — NOT NULL
  • 송전단_전력량A (power_A) — float — 외래 키 → 송변전.송전단_전력량A — NOT NULL
  • 배전손실_판매량C (ps_C) — float — 외래 키 → 배전판매량.배전손실_판매량C — NOT NULL
  • 종합손실_손실량_A_C (amount_of_total_loss_A_C) — float
  • 종합손실률 (total_loss_rate) — float

전력발전량 (power generation)

  • 연도_ (year_) — int — 기본 키 — NOT NULL
  • 서울 (seoul) — int
  • 부산 (busan) — int
  • 대구 (daegu) — int
  • 인천 (incheon) — int
  • 광주 (gwangju) — int
  • 대전 (daejeon) — int
  • 울산 (ulsan) — int
  • 세종 (sejong) — int
  • 경기 (gyeonggi) — int
  • 강원 (gangwon) — int
  • 충북 (chungbuk) — int
  • 충남 (chungnam) — int
  • 전북 (jeonbuk) — int
  • 전남 (jeonnam) — int
  • 경북 (gyeongbuk) — int
  • 경남 (gyeongnam) — int
  • 제주 (jeju) — int