Schedule

Tables (4)

Comments (comments)

  • CommentsKey (comments_key) — bigint — Primary key — NOT NULL
  • commenter — varchar(100)
  • comments — varchar(100)
  • createdDateTime (created_date_time) — datetime
  • modifiedDateTime (modified_date_time) — datetime
  • scheduleKey (schedule_key) — bigint — Foreign key → Schedule.scheduleKey — NOT NULL

Member (member)

  • userKey (user_key) — bigint — Primary key — NOT NULL
  • userName (user_name) — varchar(100)
  • userEmail (user_email) — varchar(100)
  • password — varchar(100)
  • createdDateTime (created_date_time) — datetime
  • modifiedDateTime (modified_date_time) — datetime

Schedule (schedule)

  • scheduleKey (schedule_key) — bigint — Primary key — NOT NULL
  • writerName (writer_name) — varchar(100)
  • scheduleDate (schedule_date) — date
  • scheduleTitle (schedule_title) — varchar(100)
  • scheduleDescription (schedule_description) — varchar(100)
  • createdDateTime (created_date_time) — datetime
  • ModifiedDateTime (modified_date_time) — datetime

schedule_member (schedule_mamber)

  • scheduleKey (schedule_key) — bigint — Foreign key → Schedule.scheduleKey — NOT NULL
  • userKey (user_key) — bigint — Foreign key → Member.userKey — NOT NULL