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 (일정)