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