Plank
테이블 (7)
메시지 (message)
- message_id — PK — 기본 키 — NOT NULL
- team_id (target_team_id) — FK — 외래 키 → 팀.team_id — NOT NULL
- sender_id — FK
- content — NULL
- created_at — NOT NULL
멤버 (team_members)
- team_member_id — PK — 기본 키 — NOT NULL
- team_id (target_team_id) — PK — 외래 키 → 팀.team_id — NOT NULL
- team_id — FK
- user_id — FK
- role — NOT NULL
- joined_at — NOT NULL
사용자 (users)
- user_id — PK — 기본 키 — NOT NULL
- email — NOT NULL — NOT NULL
- password_hash — NOT NULL
- name — NOT NULL
- nickname — NOT NULL
- profile_image_url — NOT NULL
- status_message (status_messasge) — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
스케쥴 (schedules)
- schedule_id — PK — 기본 키 — NOT NULL
- user_id — FK — 외래 키 → 프로젝트.user_id — NOT NULL
- team_id (target_team_id) — FK — 외래 키 → 프로젝트.team_id — NOT NULL
- project_id (project_id2) — FK — 외래 키 → 프로젝트.project_id — NOT NULL
- title — NOT NULL
- content — NULL
- start_at — NOT NULL
- end_at — NOT NULL
- status — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
알림 (notifications)
- notification_id — PK — 기본 키 — NOT NULL
- user_id — PK — 외래 키 → 사용자.user_id — NOT NULL
- type — NOT NULL
- title — NOT NULL
- message — NOT NULL
- is_read — NOT NULL
- created_at — NOT NULL
팀 (teams)
- team_id (target_team_id) — PK — 기본 키 — NOT NULL
- leader_id — FK
- team_name — NOT NULL
- description — NULL
- created_at — NOT NULL
- updated_at — NOT NULL
프로젝트 (projects)
- project_id — PK — 기본 키 — NOT NULL
- user_id — FK — 외래 키 → 사용자.user_id — NOT NULL
- team_id (target_team_id) — FK — 외래 키 → 팀.team_id — NOT NULL
- title — NOT NULL
- description — NULL
- tech_stack — NULL
- github_url — NULL
- demo_url — NULL
- status — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL