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