개인 프로젝트 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