스케쥴
테이블 (5)
Calendar
- calendar_id — INT — 기본 키
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP
- user_id (user_id3) — INT — 외래 키 → User.user_id
Calendar_Info
- calendar_info_id — INT — 기본 키
- calendar_id (calendar_id2) — INT — 외래 키 → Calendar.calendar_id
- description — TEXT
- color — VARCHAR(20)
Comment
- comment_id — INT — 기본 키
- schedule_id (schedule_id2) — INT — 외래 키 → Schedule.schedule_id
- user_id (user_id2) — INT — 외래 키 → User.user_id
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
Schedule
- schedule_id — INT — 기본 키
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- location — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- calendar_id — INT — 외래 키 → Calendar.calendar_id
User
- user_id — INT — 기본 키
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP