study-member
Tables (5)
SiteUser-studyroom (Untitled)
- user_id (id_mem) — Long — Foreign key → SiteUser.user_id — NOT NULL
- study_id (id_study) — Long — Foreign key → studyRoom.study_id — NOT NULL
Memo (Untitled3)
- memo_id (Key2) — Long — Primary key — NOT NULL
- daily_id (Key) — Long — Foreign key → dailyStudy.daily_id — NOT NULL
- user_id (id) — Long — Foreign key → SiteUser.user_id — NOT NULL
- study_id (id2) — Long — Foreign key → studyRoom.study_id — NOT NULL
- content (Field2) — varChar
SiteUser (member)
- user_id (id) — Long — Primary key — NOT NULL
- username (name) — varChar
- password — varChar
- nickname (Field) — varChar
dailyStudy (Untitled2)
- daily_id (Key) — Long — Primary key — NOT NULL
- nday (Field2) — int
- study_id (id) — Long — Foreign key → studyRoom.study_id — NOT NULL
studyRoom (study)
- study_id (id) — Long — Primary key — NOT NULL
- title — varChar
- endDate — Date
- learningObjective (Field2) — varChar
- isOpen (Field3) — boolean
- createDate (Field4) — Date
- numOfUser (Field) — int