프로젝트플래너
테이블 (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