jpa-schedule-task

Tables (4)

comment

  • comment_id — Long — Primary key — NOT NULL
  • schedule_id — Long — Foreign key → schedule.schedule_id — NOT NULL
  • username — varchar
  • contents — varchar
  • createDate — datetime
  • updateDate — datetime

schedule

  • schedule_id — Long — Primary key — NOT NULL
  • title — varchar
  • contents — varchar
  • createDate — datetime
  • updateDate — datetime

user

  • user_id — Long — Primary key — NOT NULL
  • username — varchar
  • email — varchar
  • createDate — datetime
  • updateDate — datetime

userSchedule

  • id — Long — Primary key — NOT NULL
  • schedule_id — Long — Foreign key → schedule.schedule_id — NOT NULL
  • user_id — Long — Foreign key → user.user_id — NOT NULL
  • role — varchar