PlanIt

Tables (6)

Curriculum (커리큘럼)

  • id (Key) — Long — Primary key — NOT NULL
  • hostId (호스트ID) — Long — Foreign key → User.id — NOT NULL
  • name (커리큘럼이름) — String
  • startDate (시작일) — DateTime
  • endDate (종료일) — DateTime
  • createdDate (생성일) — DateTime
  • modifiedDate (수정일) — DateTime

Guest (게스트)

  • Key — Long — Primary key — NOT NULL
  • curriculumId (커리큘럼ID) — Long — Foreign key → Curriculum.id — NOT NULL
  • hostId (유저ID) — Long — Foreign key → Curriculum.hostId — NOT NULL
  • invite (초대상태) — boolean
  • Field

Schedule (일정)

  • id (Key) — Long — Primary key — NOT NULL
  • curriculumId (커리큘럼ID) — Long — Foreign key → Curriculum.id — NOT NULL
  • content (내용) — String
  • day (일자) — Date
  • createdDate (생성일) — DateTime
  • modifiedDate (수정일) — DateTime

SpinGame (원판돌리기)

  • id (Key) — Long — Primary key — NOT NULL
  • content (내용) — String

User (유저)

  • id (Key) — Long — Primary key — NOT NULL
  • username (ID) — String
  • password (PW) — String
  • nickname (닉네임) — String
  • email (Email) — String
  • createdDate (생성일) — DateTime
  • modifiedDate (수정일) — DateTime

comment (댓글)

  • id (Key) — Long — Primary key — NOT NULL
  • scheduleId (일정ID) — Long — Foreign key → Schedule.id — NOT NULL
  • authorId (작성자ID) — Long — Foreign key → User.id — NOT NULL
  • content (내용) — String
  • createdDate (생성일) — DateTime
  • modifiedDate (수정일) — DateTime