TRASH

테이블 (6)

User (Untitled2)

  • Key — 기본 키 — NOT NULL
  • pw (Field2) — VARCHAR(20)
  • email (Field) — VARCHAR(20)

disposeLocation (Untitled6)

  • loctionID (Key) — INT — 기본 키 — NOT NULL
  • Field

how ToDispose (Untitled3)

  • toolID (Key) — INT — 기본 키 — NOT NULL
  • locationID (Field) — INT
  • disposeStart (Field2) — DATETIME
  • disposeEnd (Field3) — DATETIME
  • collectDay (Field4) — DATE
  • department (Field5) — VARCHAR(20)
  • departTel (Field6) — VARCHAR(20)

map (Untitled5)

  • location (Field) — TEXT

trashTool (Untitled4)

  • toolID (Key2) — INT — 외래 키 → how ToDispose.toolID — NOT NULL
  • name (Field) — VARCHAR(10)
  • price (Field2) — INT
  • volume (Field3) — INT

가계부 (Untitled)

  • Key — 기본 키 — NOT NULL
  • 개인배출량 (Field) — Double
  • 지역배출량 (Field2) — Double