개인 프로젝트 ERD(리팩토링 ver)

테이블 (8)

board

  • board_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • status — ENUM('WAITING','ANSWERED')
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

board_reply

  • board_reply_id — BIGINT — 기본 키 — NOT NULL
  • reply_content — TEXT
  • author_name — VARCHAR(100)
  • board_id — BIGINT — 외래 키 → board.board_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

disposal_schedule

  • schedule_id — BIGINT — 기본 키 — NOT NULL
  • region_id — BIGINT — 외래 키 → region.region_id — NOT NULL
  • category — ENUM( 'PLASTIC', 'PAPER', 'STEEL', 'GLASS', 'WRAP', 'STYROFOAM', 'FOOD', 'GENERAL', 'ETC' ) — NOT NULL
  • disposal_day — VARCHAR(100) — NOT NULL
  • disposal_time — VARCHAR(100)

feedback

  • feedback_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • detail_id — BIGINT — 외래 키 → trash_detail.detail_id — NOT NULL
  • feedback_type — ENUM( 'CLASSIFICATION_ERROR', 'SCHEDULE_ERROR', 'CONTENT_ERROR', 'MISSING_INFO', 'ETC' )
  • content — VARCHAR(1000) — NOT NULL
  • feedback_status — ENUM( 'WAITING', 'ANSWERED' )
  • created_at — DATETIME — NOT NULL

feedback_reply

  • feedback_reply_id — BIGINT — 기본 키 — NOT NULL
  • reply_content — TEXT
  • author_name — VARCHAR(100)
  • feedback_id — BIGINT — 외래 키 → feedback.feedback_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

region

  • region_id — BIGINT — 기본 키 — NOT NULL
  • city — VARCHAR(100) — NOT NULL
  • district — VARCHAR(100)
  • dong — VARCHAR(100)

trash_detail

  • detail_id — BIGINT — 기본 키 — NOT NULL
  • region_id — BIGINT — 외래 키 → region.region_id — NOT NULL
  • category — ENUM( 'PLASTIC', 'PAPER', 'STEEL', 'GLASS', 'WRAP', 'STYROFOAM', 'FOOD', 'GENERAL', 'ETC' ) — NOT NULL
  • item_name — VARCHAR(255)
  • disposal_method — TEXT
  • pre_treatment — TEXT
  • caution — TEXT

users

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100)
  • role — ENUM('USER','ADMIN') — NOT NULL
  • region_id — BIGINT — 외래 키 → region.region_id
  • created_at — DATETIME
  • updated_at — DATETIME