database toy project
Tables (3)
area (지역)
- 지역아이디 (area_id) — INT — Primary key — NOT NULL
- 시도명 (adr_do) — CHARAT
- 시군구명 (adr_si) — CHARAT
trash (쓰레기)
- 아이디 (trash_id) — INT — Primary key — NOT NULL
- 지역아이디 (area_id) — INT — Foreign key → area.지역아이디 — NOT NULL
- 아이디 (trashUsage_id) — INT — Foreign key → trashUsage.아이디 — NOT NULL
- 종량제봉투종류 (trash_type) — CHARAT
- 종량제봉투사용대상 (trash_user) — CHARAT
- 1L가격 (lL_price) — INT
- 1.5L가격 (1.5L_price) — INT
- 2L가격 (2L_price) — INT
- 2.5L가격 (2.5L_price) — INT
- 3L가격 (3L_price) — INT
- 5L가격 (5L_price) — INT
- 10L가격 (10L_price) — INT
- 20L가격 (20L_price) — INT
- 30L가격 (30L_price) — INT
- 50L가격 (50L_price) — INT
- 60L가격 (60L_price) — INT
- 75L가격 (75L_price) — INT
- 100L가격 (100L_price) — INT
- 125L가격 (125L_price) — INT
trashUsage (Untitled)
- 아이디 (trashUsage_id) — INT — Primary key — NOT NULL
- 봉투종류 (trashUsage_type) — CHARAT