WWM-PROJECT

Tables (5)

Group (그룹)

  • groupid (그룹아이디) — INT — Primary key — NOT NULL
  • url (그룹url) — CHAR
  • name (그룹명) — CHAR
  • startdate (시작일자)
  • enddate (종료일자)

GroupMember (그룹원)

  • groupid (그룹아이디) — INT — Foreign key → Group.groupid — NOT NULL
  • Job (권한) — INT
  • userid (유저이메일) — CHAR — Foreign key → User.userid — NOT NULL

User (유저)

  • userid (유저이메일) — CHAR — Primary key — NOT NULL
  • address (주소) — CHAR

mygroup (가입된 그룹목록)

  • userid (유저이메일) — CHAR — Foreign key → User.userid — NOT NULL
  • groupid (그룹아이디) — INT — Foreign key → Group.groupid — NOT NULL

timetable (시간그래프)

  • timetable (시간그래프id) — INT — Primary key — NOT NULL
  • userid (유저이메일) — CHAR — Foreign key → User.userid — NOT NULL
  • day (날짜) — DATETIME
  • schedule (일정)