Schedule

Tables (3)

Comment (댓글)

  • id (comment_id) — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Member.id — NOT NULL
  • schedule_id — bigint — Foreign key → Schedule.id — NOT NULL
  • comment (댓글) — varchar(255) — NOT NULL

Member (유저)

  • id (schedule_id) — bigint — Primary key — NOT NULL
  • username (이름) — varchar(255) — NOT NULL
  • password (비밀번호) — varchar(255) — NOT NULL
  • create_at (생성일) — timestamp — NOT NULL
  • modified_at (수정일) — timestamp — NOT NULL

Schedule (일정)

  • id (schedule_id) — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Member.id — NOT NULL
  • title (할일 제목) — varchar(255) — NOT NULL
  • content (할일 내용) — varchar(255) — NOT NULL
  • done (완료 여부) — boolean — NOT NULL
  • create_at (생성일) — timestamp — NOT NULL
  • modified_at (수정일) — timestamp — NOT NULL