1
Tables (4)
project (프로젝트 관리)
- id — int — Primary key — NOT NULL
- title (제목) — varchar
- start (시작일) — date
- end (종료일) — date
- role (역할) — varchar
- Field
schedule (일정관리)
- id (Key) — int — Primary key — NOT NULL
- user_id (유저아이디) — varchar — Foreign key → user.id — NOT NULL
- start (시작일) — date
- end (종료일) — date
- time (시간) — time
- title (제목) — varchar
- content (내용) — varchar
- is_completed (일정완료) — boolean
- Field
user (유저)
- id — varchar — Primary key — NOT NULL
- email (이메일) — varchar
- pw (비밀번호) — varchar
- name (이름) — varchar
- social (소셜로그인)
user_project_mapping (매핑)
- project_id (Key) — Foreign key → project.id — NOT NULL
- user_id (id) — varchar — Foreign key → user.id — NOT NULL