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