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