연습용
테이블 (8)
AdminInquiry
- inquiry_id — INT
- user_id — INT
- content — TEXT — NOT NULL
- admin_reply — TEXT
- created_at — DATETIME — NOT NULL
Community
- post_id — INT
- user_id — INT
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- likes — INT — NOT NULL
- created_at — DATETIME — NOT NULL
CommunityReply
- reply_id — INT
- user_id — INT
- post_id — INT
- content — TEXT — NOT NULL
- likes — INT — NOT NULL
- created_at — DATETIME — NOT NULL
Notice
- notice_id — INT
- admin_id — INT
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
Report
- report_id — INT
- user_id — INT
- notice_id — INT
- content — TEXT — NOT NULL
- admin_reply — TEXT
- created_at — DATETIME — NOT NULL
Schedule
- schedule_id — INT
- user_id — INT
- category — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- target_dong — VARCHAR(10) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
User
- user_id — INT
- username — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- apartment — VARCHAR(255) — NOT NULL
- approval — BOOLEAN — NOT NULL
Vote
- vote_id — INT
- user_id — INT
- title — VARCHAR(255) — NOT NULL
- option1 — VARCHAR(255) — NOT NULL
- option2 — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
- closed_at — DATETIME — NOT NULL