scheduler

Tables (3)

Member (Untitled)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR(255)
  • 이름 (name) — VARCHAR(45)
  • 패스워드 (password) — VARCHAR(255)
  • 생성일시 (createdAt) — DATETIME
  • 수정일시 (updatedAt) — DATETIME
  • Field — DATETIME

comment (Untitled3)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • FK (schedule_id) — BIGINT — Foreign key → schedule.PK — NOT NULL
  • FK (member_id) — BIGINT — Foreign key → Member.PK — NOT NULL
  • 내용 (contents) — LONGTEXT
  • 생성일시 (createdAt) — DATETIME
  • 수정일시 (updatedAt) — DATETIME

schedule (Untitled2)

  • PK (id) — BIGINT — Primary key — NOT NULL
  • FK (member_id) — BIGINT — Foreign key → Member.PK — NOT NULL
  • 할일 (title) — VARCHAR(255)
  • 상세 (contents) — LONGTEXT
  • 생성일시 (createdAt) — DATETIME
  • 수정일시 (updatedAt) — DATETIME