ScheduleDevelop

Tables (3)

Comments (댓글)

  • primary key (id) — bigint — Primary key — NOT NULL
  • foreign key (schedule_id) — bigint — Foreign key → Schedules.foreign key — NOT NULL
  • 내용 (contents) — varchar
  • 생성 날짜 (createdAt) — datetime
  • Field3 — datetime

Schedules (일정)

  • primary key (id) — bigint — Primary key — NOT NULL
  • foreign key (user_id) — bigint — Foreign key → Users.primary key — NOT NULL
  • 일정 제목 (title) — varchar
  • 일정 내용 (contents) — varchar
  • 생성 날짜 (createdAt) — datetime
  • 수정 날짜 (modifiedAt) — datetime

Users (유저)

  • primary key (id) — bigint — Primary key — NOT NULL
  • 이름 (username) — varchar
  • 이메일 (email) — varchar
  • 생성 날짜 (createdAt) — datetime
  • 수정 날짜 (modifiedAt) — datetime