스케쥴

테이블 (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