소프트웨어 프로젝트
테이블 (6)
friend
- id — INT
- user_id — INT — NOT NULL
- friend_user_id — INT — NOT NULL
personal_timetable
- timetable_id — INT
- user_id — INT — NOT NULL
- day_of_week — ENUM('Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun') — NOT NULL
- subject — VARCHAR(100) — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- place — VARCHAR(100)
pod
- pod_id — INT
- name — VARCHAR(100) — NOT NULL
- subject — VARCHAR(100) — NOT NULL
- deadline — DATE
- created_at — TIMESTAMP
pod_member
- id — INT
- pod_id — INT — NOT NULL
- user_id — INT — NOT NULL
team_schedule
- schedule_id — INT
- pod_id — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- start_datetime — DATETIME — NOT NULL
- end_datetime — DATETIME — NOT NULL
- place — VARCHAR(100)
user
- user_id — INT
- student_number — VARCHAR(20) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP