프로젝트플래너

테이블 (4)

memberChats

  • id — INT — 기본 키
  • content — Text
  • createdAt — DATETIME
  • modifyedAt — DATETIME
  • deletedAt — DATETIME
  • senderId — INT — 외래 키 → members.id
  • receiveId — INT — 외래 키 → members.id

members

  • id — INT — 기본 키
  • email — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50)
  • password (Field) — VARCHAR(50)
  • createdAt — DATETIME
  • modifyedAt — DATETIME
  • deletedAt — DATETIME

projectmembers

  • ProjectId — INT — 외래 키 → projects.id
  • MemberId — INT — 외래 키 → members.id
  • createdAt — DATETIME
  • modifyedAt — DATETIME

projects

  • id — INT — 기본 키
  • Owner_id — INT — 외래 키 → members.id
  • name — VARCHAR(255) — NOT NULL
  • url — VARCHAR(255)
  • createdAt — DATETIME
  • modifyedAt — DATETIME
  • deletedAt — DATETIME